DBA Data[Home] [Help]

APPS.PAY_ZA_IRP5_MAGTAPE_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 29: from hr_all_organization_units haou,

25: 'TRANSFER_ADD_2=P', nvl(substr(hoi.org_information7, 1, 80), '&&&'),
26: 'TRANSFER_ADD_3=P', nvl(substr(hoi.org_information8, 1, 80), '&&&'),
27: 'TRANSFER_ADD_4=P', nvl(substr(hoi.org_information9, 1, 80), '&&&'),
28: 'TRANSFER_POST_CODE=P', nvl(substr(hoi.org_information10, 1, 80), '&&&')
29: from hr_all_organization_units haou,
30: hr_organization_information hoi
31: where hoi.organization_id = haou.organization_id
32: and hoi.org_information_context = 'ZA_TAX_FILE_ENTITY'
33: and pay_magtape_generic.get_parameter_value('BUS_GRP') = hoi.organization_id;

Line 49: from hr_all_organization_units haou,

45: 'TRANSFER_EMP_ADD_3=P', nvl(substr(hloc.address_line_3, 1, 80), '&&&'),
46: 'TRANSFER_EMP_ADD_4=P', nvl(substr(hloc.town_or_city, 1, 80), '&&&'),
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