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_ST_GEN_001 dependencies on IGS_PE_PERSON_ID_TYP

Line 287: IGS_PE_PERSON_ID_TYP pit

283: CURSOR c_api_pit(
284: cp_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE) IS
285: SELECT api.api_person_id
286: FROM IGS_PE_ALT_PERS_ID api,
287: IGS_PE_PERSON_ID_TYP pit
288: WHERE api.pe_person_id = cp_person_id AND
289: pit.person_id_type = api.person_id_type AND
290: pit.s_person_id_type = 'OBSOLETE';
291: BEGIN

Line 388: IGS_PE_PERSON_ID_TYP pit

384: CURSOR c_api_pit(
385: cp_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE) IS
386: SELECT api.api_person_id
387: FROM IGS_PE_ALT_PERS_ID api,
388: IGS_PE_PERSON_ID_TYP pit
389: WHERE api.pe_person_id = cp_person_id AND
390: pit.person_id_type = api.person_id_type AND
391: pit.s_person_id_type = 'OBSOLETE';
392: BEGIN