DBA Data[Home] [Help]

APPS.PAY_ZA_IRP5_MAGTAPE_PKG dependencies on HR_LOCATIONS

Line 51: hr_locations hloc

47: 'TRANSFER_EMP_POSTCODE=P', nvl(substr(hloc.postal_code, 1, 80), '&&&'),
48: 'TRANSFER_LEG_ENTITY_ID=P', haou.organization_id
49: from hr_all_organization_units haou,
50: hr_organization_information hoi,
51: hr_locations hloc
52: where hoi.organization_id = haou.organization_id
53: and pay_magtape_generic.get_parameter_value('BUS_GRP') = haou.business_group_id
54: and hoi.org_information_context = 'ZA_LEGAL_ENTITY'
55: and hloc.location_id (+) = haou.location_id