DBA Data[Home] [Help]

APPS.HR_FI_VALIDATE_PKG dependencies on PER_QUALIFICATIONS

Line 201: from per_qualifications pq

197: validate_number(p_qua_information1,NULL,'HR_376605_FI_EDUCATION_CODE');
198: IF p_qua_information2 ='Y' THEN
199: select count(*)
200: into l_count
201: from per_qualifications pq
202: where pq.business_group_id = p_business_group_id
203: and pq.person_id = p_person_id
204: and pq.qua_information_category='FI'
205: and pq.qua_information2='Y';

Line 227: FROM per_qualifications

223: l_business_group_id NUMBER;
224:
225: CURSOR c_person_id IS
226: SELECT person_id,business_group_id
227: FROM per_qualifications
228: WHERE qualification_id = p_qualification_id;
229:
230: BEGIN
231: --

Line 253: from per_qualifications pq

249: CLOSE c_person_id;
250:
251: select count(*)
252: into l_count
253: from per_qualifications pq
254: where pq.business_group_id = l_business_group_id
255: and pq.person_id = l_person_id
256: and pq.qualification_id <> p_qualification_id
257: and pq.qua_information_category='FI'