202: validate_number(p_qua_information1,NULL,'HR_376605_FI_EDUCATION_CODE');
203: IF p_qua_information2 ='Y' THEN
204: select count(*)
205: into l_count
206: from per_qualifications pq
207: where pq.business_group_id = p_business_group_id
208: and pq.person_id = p_person_id
209: and pq.qua_information_category='FI'
210: and pq.qua_information2='Y';
228: l_business_group_id NUMBER;
229:
230: CURSOR c_person_id IS
231: SELECT person_id,business_group_id
232: FROM per_qualifications
233: WHERE qualification_id = p_qualification_id;
234:
235: BEGIN
236: --
254: CLOSE c_person_id;
255:
256: select count(*)
257: into l_count
258: from per_qualifications pq
259: where pq.business_group_id = l_business_group_id
260: and pq.person_id = l_person_id
261: and pq.qualification_id <> p_qualification_id
262: and pq.qua_information_category='FI'