DBA Data[Home] [Help]

APPS.PAY_US_MWR_REPORTING_PKG dependencies on HR_LOCATIONS

Line 120: ,hr_locations loc

116: ,per_gen_hierarchy_nodes pghn -- parent organization
117: ,per_gen_hierarchy_nodes pghn2 -- establishment organizations
118: ,hr_organization_information hoi
119: ,hr_organization_units hou
120: ,hr_locations loc
121: ,hr_location_extra_info lei
122: where pgh.hierarchy_id = Pay_Magtape_Generic.Get_Parameter_Value(
123: 'TRANSFER_HIERARCHY_ID') --parameter p_hierarchy_id
124: and pghv.HIERARCHY_VERSION_id = Pay_Magtape_Generic.Get_Parameter_Value(