DBA Data[Home] [Help]

APPS.PAY_KR_SPAY_EFILE dependencies on HR_LOCATIONS_ALL

Line 92: ,hr_locations_all hla

88: FROM hr_organization_information hoi
89: ,hr_organization_information ihoi
90: ,hr_organization_information choi
91: ,hr_organization_units hou
92: ,hr_locations_all hla
93: WHERE hou.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
94: and hou.organization_id = hoi.organization_id
95: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
96: and hou.organization_id = ihoi.organization_id