eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_SQWL_UDF dependencies on PAY_MAGTAPE_GENERIC

Line 922: where pgh.hierarchy_id = Pay_Magtape_Generic.Get_Parameter_Value(

918: ,hr_organization_information hoi
919: ,hr_organization_units hou
920: ,hr_locations loc
921: ,hr_location_extra_info lei
922: where pgh.hierarchy_id = Pay_Magtape_Generic.Get_Parameter_Value(
923: 'TRANSFER_HIERARCHY_ID') --parameter p_hierarchy_id
924: and pghv.HIERARCHY_VERSION_id =Pay_Magtape_Generic.Get_Parameter_Value(
925: 'TRANSFER_HIERARCHY_VERSION') --parameter p_hierarchy_verision_number
926: and pgh.hierarchy_id = pghv.hierarchy_id

Line 924: and pghv.HIERARCHY_VERSION_id =Pay_Magtape_Generic.Get_Parameter_Value(

920: ,hr_locations loc
921: ,hr_location_extra_info lei
922: where pgh.hierarchy_id = Pay_Magtape_Generic.Get_Parameter_Value(
923: 'TRANSFER_HIERARCHY_ID') --parameter p_hierarchy_id
924: and pghv.HIERARCHY_VERSION_id =Pay_Magtape_Generic.Get_Parameter_Value(
925: 'TRANSFER_HIERARCHY_VERSION') --parameter p_hierarchy_verision_number
926: and pgh.hierarchy_id = pghv.hierarchy_id
927: and pghv.hierarchy_version_id = pghn.hierarchy_version_id
928: and pghn.node_type = 'PAR'

Line 937: and loc.region_2 = Pay_Magtape_Generic.Get_Parameter_Value(

933: and pghv.hierarchy_version_id = pghn2.hierarchy_version_id
934: and pghn.business_group_id = pghn2.business_group_id
935: and pghn2.node_type = 'EST'
936: and pghn2.entity_id = loc.location_id
937: and loc.region_2 = Pay_Magtape_Generic.Get_Parameter_Value(
938: 'TRANSFER_STATE')
939: and loc.location_id = lei.location_id
940: and lei.information_type = 'Multi Work Site Information'
941: and loc.location_id = cp_location_id;