DBA Data[Home] [Help]

APPS.PER_GB_ORG_INFO dependencies on HR_ORGANIZATION_INFORMATION

Line 20: from hr_organization_information

16:
17: --
18: Cursor csr_org_info_exists is
19: select 1
20: from hr_organization_information
21: where organization_id = p_organization_id
22: and org_information_context = p_org_info_type_code
23: and org_information1 = p_org_information1;
24: --

Line 139: from hr_organization_information

135:
136: --
137: Cursor csr_org_info_exists is
138: select 1
139: from hr_organization_information
140: where organization_id = (select organization_id
141: from hr_organization_information
142: where org_information_id = p_org_information_id)
143: and org_information_context = p_org_info_type_code

Line 141: from hr_organization_information

137: Cursor csr_org_info_exists is
138: select 1
139: from hr_organization_information
140: where organization_id = (select organization_id
141: from hr_organization_information
142: where org_information_id = p_org_information_id)
143: and org_information_context = p_org_info_type_code
144: and org_information1 = p_org_information1
145: and org_information_id <> p_org_information_id;