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.IGS_UC_QUAL_DETS_IMP_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 134: CURSOR cur_per_no(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

130: FROM igs_av_stnd_unit_lvl_all
131: WHERE qual_dets_id = cp_qual_dets_id;
132:
133: --Get the Person Number for the Person ID passed.
134: CURSOR cur_per_no(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
135: SELECT person_number
136: FROM igs_pe_person_base_v
137: WHERE person_id = cp_person_id;
138:

Line 136: FROM igs_pe_person_base_v

132:
133: --Get the Person Number for the Person ID passed.
134: CURSOR cur_per_no(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
135: SELECT person_number
136: FROM igs_pe_person_base_v
137: WHERE person_id = cp_person_id;
138:
139: --To Identify whether the qualification is valid or not
140: CURSOR cur_qual_valid ( cp_person_id igs_uc_qual_dets.person_id%TYPE,

Line 200: l_person_number igs_pe_person_base_v.person_number%TYPE;

196: l_mesg_data VARCHAR2(2000);
197: l_rowid VARCHAR2(25);
198: l_validation_status BOOLEAN ;
199: l_rec_found VARCHAR2(1);
200: l_person_number igs_pe_person_base_v.person_number%TYPE;
201:
202: BEGIN
203:
204: --anwest 18-JAN-2006 Bug# 4950285 R12 Disable OSS Mandate