DBA Data[Home] [Help]

APPS.PAY_US_MWR_REPORTING_PKG dependencies on HR_LOCATIONS

Line 125: ,hr_locations loc

121: ,per_gen_hierarchy_nodes pghn -- parent organization
122: ,per_gen_hierarchy_nodes pghn2 -- establishment organizations
123: ,hr_organization_information hoi
124: ,hr_organization_units hou
125: ,hr_locations loc
126: ,hr_location_extra_info lei
127: where pgh.hierarchy_id = Pay_Magtape_Generic.Get_Parameter_Value(
128: 'TRANSFER_HIERARCHY_ID') --parameter p_hierarchy_id
129: and pghv.HIERARCHY_VERSION_id = Pay_Magtape_Generic.Get_Parameter_Value(