APPS.IGS_AD_SS_APPL_UPD_PAGE dependencies on IGS_AD_PRCS_CAT_STEP

Line 458: l_adm_cat IGS_AD_PRCS_CAT_STEP.ADMISSION_CAT%TYPE;

454: WHERE s_control_num = 1;
455:
456: l_adm_cal_type igs_ca_inst.cal_type%TYPE ;
457: l_adm_sequence_number igs_ca_inst.sequence_number%TYPE;
458: l_adm_cat IGS_AD_PRCS_CAT_STEP.ADMISSION_CAT%TYPE;
459: l_s_adm_prc_typ IGS_AD_PRCS_CAT_STEP.S_ADMISSION_PROCESS_TYPE%TYPE;
460: l_late_appl_exists VARCHAR2(2000);
461:
462:

Line 459: l_s_adm_prc_typ IGS_AD_PRCS_CAT_STEP.S_ADMISSION_PROCESS_TYPE%TYPE;

455:
456: l_adm_cal_type igs_ca_inst.cal_type%TYPE ;
457: l_adm_sequence_number igs_ca_inst.sequence_number%TYPE;
458: l_adm_cat IGS_AD_PRCS_CAT_STEP.ADMISSION_CAT%TYPE;
459: l_s_adm_prc_typ IGS_AD_PRCS_CAT_STEP.S_ADMISSION_PROCESS_TYPE%TYPE;
460: l_late_appl_exists VARCHAR2(2000);
461:
462:
463: CURSOR c_dai IS

Line 476: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,

472: AND dai.cal_type = l_adm_cal_type
473: AND dai.ci_sequence_number = l_adm_sequence_number;
474:
475: CURSOR c_apcs (
476: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
477: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
478: SELECT 'X'
479: FROM IGS_AD_PRCS_CAT_STEP apcs,
480: IGS_LOOKUPS_VIEW sasty

Line 477: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS

473: AND dai.ci_sequence_number = l_adm_sequence_number;
474:
475: CURSOR c_apcs (
476: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
477: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
478: SELECT 'X'
479: FROM IGS_AD_PRCS_CAT_STEP apcs,
480: IGS_LOOKUPS_VIEW sasty
481: WHERE apcs.admission_cat = cp_admission_cat AND

Line 479: FROM IGS_AD_PRCS_CAT_STEP apcs,

475: CURSOR c_apcs (
476: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
477: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
478: SELECT 'X'
479: FROM IGS_AD_PRCS_CAT_STEP apcs,
480: IGS_LOOKUPS_VIEW sasty
481: WHERE apcs.admission_cat = cp_admission_cat AND
482: apcs.s_admission_process_type = cp_s_admission_process_type AND
483: apcs.s_admission_step_type = 'LATE-APP' AND