APPS.PQH_INST_TYPE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 12: from hr_organization_information org

8: cursor c1(cp_org_id number)
9: is
10:
11: select distinct 1
12: from hr_organization_information org
13: where org.organization_id = cp_org_id
14: and not exists (select org1.org_information_context
15: from hr_organization_information org1
16: where org1.org_information_context = 'IPEDS_INSTITUTION_TYPE'

Line 15: from hr_organization_information org1

11: select distinct 1
12: from hr_organization_information org
13: where org.organization_id = cp_org_id
14: and not exists (select org1.org_information_context
15: from hr_organization_information org1
16: where org1.org_information_context = 'IPEDS_INSTITUTION_TYPE'
17: and org1.organization_id = cp_org_id);
18:
19: cursor c2(cp_org_id number)

Line 23: from hr_organization_information org

19: cursor c2(cp_org_id number)
20: is
21:
22: select org.org_information1
23: from hr_organization_information org
24: where org.organization_id = cp_org_id
25: and org.org_information_context = 'IPEDS_INSTITUTION_TYPE';
26:
27: l_inst_not_exists varchar2(5);