!!Retrieve the ID of a date-sensitive child record !Functionality: This function retrieves the ID for a date sensitive record given a parent alias and ID (and optional as of date) !Parameters: |TABLE_ALIAS | The table alias (e.g. EID) of the parent table (__not the child table__) |PARENT ID | The ID of the parent record |AS OF | ''Optional''. Provides a date frame to retrieve the data. If it is not provided, the current system date will be used. !Returns: Varchar2 (even though the return value is a numeric ID) !Errors: |{{** BAD Table Alias}} |When there is no table found in [IMTD] with the alias provided |{{** No UK constraint found with ...}} |When the table alias provided does not have a date sensitive child table |{{** Select failed on child table ...}} |When a date sensitive child record could not be located as of the date specified !Example: {{p2k_pu.get_child_id('DWR',dwr_id)}} ;:will return the ID of the effective record from P2K_CM_WORK_RULE_DETAILS (the child of DWR - P2K_CM_WORK_RULES) as of today Where this could be used is if you know the information of a header record, but now want to get something from the date-sensitive detail. You can use the combination of the [P2K_PU.GC] function and this function to get the column information from the child record. For example, If I know the Work Rule (DWR) and I want to get the Standard Hours per day from the date sensitive detail (DWRD), the reference would be: {{{ p2k_pu.gc('DWRD','STD_HOURS_PER_DAY', p2k_pu.get_child_id('DWR',dwr_id) ) }}} ---- ![Notes|Edit:Internal.P2K_PU.GET_CHILD_ID] [{InsertPage page='Internal.P2K_PU.GET_CHILD_ID' default='Click to create a new notes page'}]