DBA Data[Home] [Help]

APPS.HR_FI_VALIDATE_PKG dependencies on PER_QUALIFICATIONS

Line 206: from per_qualifications pq

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

Line 232: FROM per_qualifications

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

Line 258: from per_qualifications pq

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'