eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_NO_VALIDATE_PKG dependencies on PER_QUALIFICATIONS

Line 1133: from per_qualifications pq

1129:
1130: IF p_qua_information2 ='Y' THEN
1131: select count(*)
1132: into l_count
1133: from per_qualifications pq
1134: where pq.business_group_id = p_business_group_id
1135: and pq.person_id = p_person_id
1136: and pq.qua_information_category='NO'
1137: and pq.qua_information2='Y';

Line 1161: FROM per_qualifications

1157: l_nus2000_code NUMBER;
1158:
1159: CURSOR c_person_id IS
1160: SELECT person_id,business_group_id
1161: FROM per_qualifications
1162: WHERE qualification_id = p_qualification_id;
1163:
1164: /*Bug fix 4950606 : Rewrote the select statement using cursor in qual_update_validate procedure.*/
1165: CURSOR c_information1 IS

Line 1198: from per_qualifications pq

1194: CLOSE c_person_id;
1195:
1196: select count(*)
1197: into l_count
1198: from per_qualifications pq
1199: where pq.business_group_id = l_business_group_id
1200: and pq.person_id = l_person_id
1201: and pq.qualification_id <> p_qualification_id
1202: and pq.qua_information_category='NO'