APPS.PQH_CORPS_EXTRA_INFO_API dependencies on HR_ALL_ORGANIZATION_UNITS

Line 15: FROM hr_all_organization_units

11: CURSOR csr_chk_valid_org IS
12: SELECT 'Y'
13: FROM DUAL
14: WHERE EXISTS (SELECT 1
15: FROM hr_all_organization_units
16: WHERE organization_id = fnd_number.canonical_to_number(p_organization_id)
17: AND p_effective_date BETWEEN date_from AND NVL(date_to,hr_general.end_of_time));
18: l_valid_org varchar2(10) := 'N';
19: CURSOR csr_dup_org_chk IS

Line 111: FROM hr_all_organization_units

107: CURSOR csr_valid_institution IS
108: SELECT 'Y'
109: FROM dual
110: WHERE EXISTS (SELECT 1
111: FROM hr_all_organization_units
112: WHERE organization_id = fnd_number.canonical_to_number(p_institution_id)
113: AND p_effective_date BETWEEN date_from AND nvl(date_to,hr_general.end_of_time));
114: l_valid_institution varchar2(10) :='N';
115: CURSOR csr_chk_dup_exam IS

Line 186: FROM hr_all_organization_units

182: CURSOR csr_valid_institution IS
183: SELECT 'Y'
184: FROM dual
185: WHERE EXISTS (SELECT 1
186: FROM hr_all_organization_units
187: WHERE organization_id = fnd_number.canonical_to_number(p_institution_id)
188: AND p_effective_date BETWEEN date_from AND nvl(date_to,hr_general.end_of_time));
189: l_valid_institution varchar2(10) :='N';
190: CURSOR csr_dup_train_dtls IS