APPS.HR_DE_ORGANIZATION_UPLOAD dependencies on HR_ORGANIZATION_INFORMATION

Line 51: FROM hr_organization_information

47: --
48: CURSOR c_org_class
49: (p_organization_id NUMBER) IS
50: SELECT org_information2 || ':' || org_information1 value
51: FROM hr_organization_information
52: WHERE organization_id = p_organization_id;
53: --
54: --
55: -- Cursor to return tax office information.

Line 63: ,hr_organization_information i

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'
67: AND i.org_information1 = p_tax_office_no;

Line 79: ,hr_organization_information i

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'
83: AND (i.org_information1 = p_west_betriebsnummer OR i.org_information2 = p_east_betriebsnummer);