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

Line 77: IGS_PE_ALT_PERS_ID.api_person_id%TYPE, cp_alt_person_id_type

73: v_last_char VARCHAR2(1);
74:
75:
76: CURSOR c_api ( cp_api_person_id
77: IGS_PE_ALT_PERS_ID.api_person_id%TYPE, cp_alt_person_id_type
78: IGS_PE_ALT_PERS_ID.person_id_type%TYPE) IS
79: SELECT pe_person_id
80: FROM IGS_PE_ALT_PERS_ID
81: WHERE api_person_id = cp_api_person_id

Line 78: IGS_PE_ALT_PERS_ID.person_id_type%TYPE) IS

74:
75:
76: CURSOR c_api ( cp_api_person_id
77: IGS_PE_ALT_PERS_ID.api_person_id%TYPE, cp_alt_person_id_type
78: IGS_PE_ALT_PERS_ID.person_id_type%TYPE) IS
79: SELECT pe_person_id
80: FROM IGS_PE_ALT_PERS_ID
81: WHERE api_person_id = cp_api_person_id
82: AND person_id_type = cp_alt_person_id_type

Line 80: FROM IGS_PE_ALT_PERS_ID

76: CURSOR c_api ( cp_api_person_id
77: IGS_PE_ALT_PERS_ID.api_person_id%TYPE, cp_alt_person_id_type
78: IGS_PE_ALT_PERS_ID.person_id_type%TYPE) IS
79: SELECT pe_person_id
80: FROM IGS_PE_ALT_PERS_ID
81: WHERE api_person_id = cp_api_person_id
82: AND person_id_type = cp_alt_person_id_type
83: AND start_dt < SYSDATE
84: AND NVL(end_dt,SYSDATE) >= SYSDATE;