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_SS_GEN_001 dependencies on IGS_AD_APTYP_PESTAT

Line 1294: From igs_ad_aptyp_pestat

1290: *****************************************************************************************/
1291: AS
1292: CURSOR c_perstat_types(l_admission_application_type IN VARCHAR2) IS
1293: SELECT persl_stat_type
1294: From igs_ad_aptyp_pestat
1295: WHERE admission_application_type = l_admission_application_type;
1296: l_stmt_count NUMBER;
1297: BEGIN
1298: SELECT COUNT(ss_perstat_id)

Line 3879: cp_group_number IGS_AD_APTYP_PESTAT.group_number%TYPE) IS

3875: -- Personal Statements- PERSONAL_STMTS
3876: -- Cursors c_perstat and c_perstat_group added by abhiskum
3877: CURSOR c_perstat(cp_person_id igs_ad_appl.person_id%TYPE,
3878: cp_adm_appl_number IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE,
3879: cp_group_number IGS_AD_APTYP_PESTAT.group_number%TYPE) IS
3880: SELECT stg.persl_stat_type statement,
3881: DECODE(NVL(mandatory,'N'),'N','No','Yes') required,
3882: group_number,
3883: stg.SS_PERSTAT_ID SS_PERSTAT_ID,

Line 3886: IGS_AD_APTYP_PESTAT aptypperstat

3882: group_number,
3883: stg.SS_PERSTAT_ID SS_PERSTAT_ID,
3884: stg.attach_exists
3885: FROM IGS_SS_APPL_PERSTAT stg,
3886: IGS_AD_APTYP_PESTAT aptypperstat
3887: WHERE stg.persl_Stat_type = aptypperstat.persl_Stat_type
3888: AND stg.admission_application_type = aptypperstat.admission_application_type
3889: AND stg.ss_Adm_appl_id = cp_adm_appl_number
3890: AND stg.PERSON_ID = cp_person_id

Line 3905: (SELECT distinct group_number FROM IGS_SS_APPL_PERSTAT stg, IGS_AD_APTYP_PESTAT setup

3901: null attach_exists,
3902: group_min
3903: FROM IGS_AD_PESTAT_GROUP
3904: WHERE group_number IN
3905: (SELECT distinct group_number FROM IGS_SS_APPL_PERSTAT stg, IGS_AD_APTYP_PESTAT setup
3906: WHERE setup.persl_Stat_type = stg.persl_Stat_type
3907: AND setup.admission_application_type = stg.admission_application_type
3908: AND stg.ss_Adm_appl_id = cp_adm_appl_number AND stg.PERSON_ID = cp_person_id )
3909: AND admission_application_type = cp_ApplType

Line 3920: IGS_AD_APTYP_PESTAT aptypperstat

3916: stg.SS_PERSTAT_ID SS_PERSTAT_ID,
3917: stg.attach_exists,
3918: 0 group_min
3919: FROM IGS_SS_APPL_PERSTAT stg,
3920: IGS_AD_APTYP_PESTAT aptypperstat
3921: WHERE stg.persl_Stat_type = aptypperstat.persl_Stat_type
3922: AND stg.admission_application_type = aptypperstat.admission_application_type
3923: AND group_number IS NULL
3924: AND stg.ss_Adm_appl_id = cp_adm_appl_number