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: --
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
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;