APPS.PQH_CORPS_EXTRA_INFO_API dependencies on DUAL

Line 13: FROM DUAL

9: ,p_organization_id IN VARCHAR2
10: ,p_corps_extra_info_id IN NUMBER DEFAULT NULL) IS
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));

Line 21: FROM DUAL

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
20: SELECT 'Y'
21: FROM DUAL
22: WHERE EXISTS (SELECT 1
23: FROM pqh_corps_extra_info
24: WHERE corps_definition_id = p_corps_definition_id
25: AND information_type = 'ORGANIZATION'

Line 60: FROM dual

56: ,p_field_of_prof_activity_id IN VARCHAR2
57: ,p_corps_extra_info_id IN NUMBER DEFAULT NULL) IS
58: CURSOR csr_chk_valid_prof_field IS
59: SELECT 'Y'
60: FROM dual
61: WHERE EXISTS (SELECT 1
62: FROM per_shared_types
63: WHERE shared_type_id = fnd_number.canonical_to_number(p_field_of_prof_activity_id));
64: l_valid_prof_field varchar2(10) := 'N';

Line 68: FROM dual

64: l_valid_prof_field varchar2(10) := 'N';
65: l_proc varchar2(72) := g_package||'.validate_corps_prof_field_info';
66: CURSOR csr_dup_prof_field_chk IS
67: SELECT 'Y'
68: FROM dual
69: WHERE EXISTS (SELECT 1
70: FROM pqh_corps_extra_info
71: WHERE corps_definition_id = p_corps_definition_id
72: AND information_type = 'FILERE'

Line 109: FROM dual

105: ,p_exam_name IN VARCHAR2
106: ,p_corps_extra_info_id IN NUMBER DEFAULT NULL) IS
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));

Line 117: FROM dual

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
116: SELECT 'Y'
117: FROM dual
118: WHERE EXISTS (SELECT 1
119: FROM pqh_corps_extra_info
120: WHERE information_type = 'EXAM'
121: AND corps_definition_id = p_corps_definition_id

Line 177: FROM dual

173: ,p_mandatory_flag IN VARCHAR2
174: ,p_corps_extra_info_id IN NUMBER DEFAULT NULL) IS
175: CURSOR csr_valid_qualification IS
176: SELECT 'Y'
177: FROM dual
178: WHERE EXISTS (SELECT 1
179: FROM per_qualification_types
180: WHERE qualification_type_id = fnd_number.canonical_to_number(p_qualification_id) );
181: l_valid_qualification varchar2(10) := 'N';

Line 184: FROM dual

180: WHERE qualification_type_id = fnd_number.canonical_to_number(p_qualification_id) );
181: l_valid_qualification varchar2(10) := 'N';
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));

Line 192: FROM dual

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
191: SELECT 'Y'
192: FROM dual
193: WHERE EXISTS (SELECT 1
194: FROM pqh_corps_extra_info
195: WHERE corps_definition_id = p_corps_definition_id
196: AND information_type = 'TRAINING'

Line 268: FROM dual

264: -- ----------------------------------------------------------------------------
265: PROCEDURE chk_prim_field_for_corps(p_corps_extra_info_id IN NUMBER) IS
266: CURSOR csr_prim_field_for_corps IS
267: SELECT 'Y'
268: FROM dual
269: WHERE EXISTS (SELECT 1
270: FROM pqh_corps_definitions cpd,
271: pqh_corps_extra_info cei
272: WHERE cei.information_type = 'FILERE'