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_EN_NSC_PKG dependencies on IGS_PE_ALT_PERS_ID

Line 389: FROM igs_pe_alt_pers_id pit,igs_pe_person_id_typ ppit

385: WHERE opt_type = 'NC_STAT_CD'
386: )
387: AND EXISTS
388: (SELECT 'X'
389: FROM igs_pe_alt_pers_id pit,igs_pe_person_id_typ ppit
390: WHERE cp_person_id=pit.pe_person_id
391: AND pit.person_id_type = ppit.person_id_type
392: AND ppit.s_person_id_type = 'SSN'
393: AND pit.start_dt <= SYSDATE

Line 1408: FROM igs_pe_alt_pers_id

1404:
1405: -- Cursor to get the SSN
1406: CURSOR c_ssn_num IS
1407: SELECT api_person_id
1408: FROM igs_pe_alt_pers_id
1409: WHERE pe_person_id = p_student_data.student_id
1410: AND person_id_type
1411: IN (SELECT person_id_type
1412: FROM igs_pe_person_id_typ

Line 1433: FROM igs_pe_alt_pers_id

1429:
1430: -- Cursor to get the previous SSN
1431: CURSOR c_prev_ssn_num IS
1432: SELECT api_person_id
1433: FROM igs_pe_alt_pers_id
1434: WHERE pe_person_id = p_student_data.student_id
1435: AND person_id_type
1436: IN (SELECT person_id_type
1437: FROM igs_pe_person_id_typ