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.

[Home] [Help]

APPS.IGS_ST_GEN_001 dependencies on IGS_PE_ALT_PERS_ID

Line 284: cp_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE) IS

280: DECLARE
281: v_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;
282: v_continue BOOLEAN;
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

Line 286: FROM IGS_PE_ALT_PERS_ID api,

282: v_continue BOOLEAN;
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';

Line 385: cp_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE) IS

381: DECLARE
382: v_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;
383: v_continue BOOLEAN;
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

Line 387: FROM IGS_PE_ALT_PERS_ID api,

383: v_continue BOOLEAN;
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';