APPS.HR_DE_ORGANIZATION_UPLOAD dependencies on HR_ALL_ORGANIZATION_UNITS

Line 41: FROM hr_all_organization_units

37: (p_business_group_id NUMBER
38: ,p_organization_name VARCHAR2) IS
39: SELECT organization_id
40: ,object_version_number
41: FROM hr_all_organization_units
42: WHERE business_group_id = p_business_group_id
43: AND name = p_organization_name;
44: --
45: --

Line 62: FROM hr_all_organization_units o

58: (p_business_group_id NUMBER
59: ,p_tax_office_no VARCHAR2) IS
60: SELECT o.organization_id
61: ,o.name
62: FROM hr_all_organization_units o
63: ,hr_organization_information i
64: WHERE o.business_group_id = p_business_group_id
65: AND i.organization_id = o.organization_id
66: AND i.org_information_context = 'DE_TAX_OFFICE_INFO'

Line 78: FROM hr_all_organization_units o

74: ,p_east_betriebsnummer VARCHAR2
75: ,p_west_betriebsnummer VARCHAR2) IS
76: SELECT o.organization_id
77: ,o.name
78: FROM hr_all_organization_units o
79: ,hr_organization_information i
80: WHERE o.business_group_id = p_business_group_id
81: AND i.organization_id = o.organization_id
82: AND i.org_information_context = 'DE_SOCIAL_INSURANCE_INFO'