13:
14: --
15: Cursor csr_org_info_exists is
16: select 1
17: from hr_organization_information
18: where organization_id = p_organization_id
19: and org_information_context = p_org_info_type_code
20: and org_information1 = p_org_information1;
21: --
92:
93: --
94: Cursor csr_org_info_exists is
95: select 1
96: from hr_organization_information
97: where organization_id = (select organization_id
98: from hr_organization_information
99: where org_information_id = p_org_information_id)
100: and org_information_context = p_org_info_type_code
94: Cursor csr_org_info_exists is
95: select 1
96: from hr_organization_information
97: where organization_id = (select organization_id
98: from hr_organization_information
99: where org_information_id = p_org_information_id)
100: and org_information_context = p_org_info_type_code
101: and org_information1 = p_org_information1
102: and org_information_id <> p_org_information_id;