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_PERSON_ID_TYP

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 1412: FROM igs_pe_person_id_typ

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
1413: WHERE s_person_id_type = 'SSN')
1414: AND start_dt <= sysdate
1415: AND end_dt IS NULL;
1416:

Line 1437: FROM igs_pe_person_id_typ

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
1438: WHERE s_person_id_type = 'SSN')
1439: AND start_dt <= sysdate
1440: AND end_dt IS NOT NULL
1441: AND start_dt <> end_dt