APPS.PER_FR_VALIDATE_DELETE_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 46: from hr_organization_information oi, hr_all_organization_units ou

42: AND x_organization_id = to_number(ORG_INFORMATION3);
43:
44: cursor csr_comp_dads_estab is
45: select 1
46: from hr_organization_information oi, hr_all_organization_units ou
47: where oi.organization_id = ou.organization_id
48: and oi.organization_id = x_organization_id
49: and oi.org_information_context = 'FR_ESTAB_INFO'
50: and to_number (oi.org_information1) =

Line 52: from hr_all_organization_units ou, hr_organization_information oi

48: and oi.organization_id = x_organization_id
49: and oi.org_information_context = 'FR_ESTAB_INFO'
50: and to_number (oi.org_information1) =
51: (select ou.organization_id
52: from hr_all_organization_units ou, hr_organization_information oi
53: where to_number (oi.org_information4) = x_organization_id
54: and oi.organization_id = ou.organization_id
55: and oi.org_information_context = 'FR_COMP_INFO');
56:

Line 59: from hr_organization_information oi, hr_all_organization_units ou

55: and oi.org_information_context = 'FR_COMP_INFO');
56:
57: cursor csr_comp_heaq_estab is
58: select 1
59: from hr_organization_information oi, hr_all_organization_units ou
60: where oi.organization_id = ou.organization_id
61: and oi.organization_id = x_organization_id
62: and oi.org_information_context = 'FR_ESTAB_INFO'
63: and to_number (oi.org_information1) =

Line 65: from hr_all_organization_units ou, hr_organization_information oi

61: and oi.organization_id = x_organization_id
62: and oi.org_information_context = 'FR_ESTAB_INFO'
63: and to_number (oi.org_information1) =
64: (select ou.organization_id
65: from hr_all_organization_units ou, hr_organization_information oi
66: where to_number (oi.org_information5) = x_organization_id
67: and oi.organization_id = ou.organization_id
68: and oi.org_information_context = 'FR_COMP_INFO');
69: