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

Line 894: IGS_PE_PERSON_ID_TYP pit

890: -- gmaheswa: Added START_DT <> END_DT OR END_DT IS NULL condition as part of bug 3882788
891: CURSOR c_api_pit IS
892: SELECT api.pe_person_id
893: FROM IGS_PE_ALT_PERS_ID api,
894: IGS_PE_PERSON_ID_TYP pit
895: WHERE api.pe_person_id = p_person_id AND
896: (api.start_dt IS NULL OR
897: (api.start_dt <= p_appl_dt AND
898: NVL(api.end_dt, IGS_GE_DATE.IGSCHAR('9999/01/01')) >= p_appl_dt) AND