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_WRKFLOW_PKG dependencies on IGS_SS_APP_PGM_STG

Line 100: From IGS_SS_ADM_APPL_STG aa, IGS_SS_APP_PGM_STG aap

96:
97: /* Program parameter has been provided,include application without calendar is YES and calendar range is CURRENT */
98: Cursor c_incom_appl_pgm_curr_anc IS
99: Select aa.person_id
100: From IGS_SS_ADM_APPL_STG aa, IGS_SS_APP_PGM_STG aap
101: Where
102: aap.SS_ADM_APPL_ID = aa.SS_ADM_APPL_ID(+)
103: And ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
104: AND (p_person_id_group IS NOT NULL AND

Line 144: From IGS_SS_ADM_APPL_STG aa, IGS_SS_APP_PGM_STG aap

140:
141: /* Program parameter has been provided,include application without calendar is NO and calendar range is CURRENT */
142: Cursor c_incom_appl_pgm_curr IS
143: Select aa.person_id
144: From IGS_SS_ADM_APPL_STG aa, IGS_SS_APP_PGM_STG aap
145: Where aap.SS_ADM_APPL_ID = aa.SS_ADM_APPL_ID(+)
146: And ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
147: AND (p_person_id_group IS NOT NULL AND
148: aa.person_id IN (SELECT person_id

Line 327: From IGS_SS_ADM_APPL_STG aa, IGS_SS_APP_PGM_STG aap

323:
324: /* Program parameter has been provided,include application without calendar is YES and calendar range is CURRFUTURE */
325: Cursor c_incom_appl_pgm_cnf_anc IS
326: Select aa.person_id
327: From IGS_SS_ADM_APPL_STG aa, IGS_SS_APP_PGM_STG aap
328: Where
329: aap.SS_ADM_APPL_ID = aa.SS_ADM_APPL_ID(+)
330: And ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
331: AND (p_person_id_group IS NOT NULL AND

Line 421: From IGS_SS_ADM_APPL_STG aa, IGS_SS_APP_PGM_STG aap

417:
418: /* Program parameter has been provided,include application without calendar is YES and calendar range is CURRFUTURE */
419: Cursor c_incom_appl_pgm_cnf IS
420: Select aa.person_id
421: From IGS_SS_ADM_APPL_STG aa, IGS_SS_APP_PGM_STG aap
422: Where aap.SS_ADM_APPL_ID = aa.SS_ADM_APPL_ID(+)
423: And ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
424: AND (p_person_id_group IS NOT NULL AND
425: aa.person_id IN (SELECT person_id