APPS.IGS_AD_SS_APPL_UPD_PAGE dependencies on IGS_CA_INST

Line 363: FROM IGS_CA_DA_INST ca, igs_ca_inst ci

359: SELECT IGS_CA_GEN_001.calp_set_alias_value(
360: ca.absolute_val,
361: IGS_CA_GEN_002.cals_clc_dt_from_dai(
362: ca.ci_sequence_number, ca.CAL_TYPE, ca.DT_ALIAS, ca.sequence_number) ) alias_val
363: FROM IGS_CA_DA_INST ca, igs_ca_inst ci
364: WHERE ca.dt_alias = l_adm_appl_due_dt_alias
365: and ci.cal_type = ca.cal_type
366: and ci.sequence_number = ca.ci_sequence_number
367: and ci.cal_type = c_adm_cal_type

Line 372: l_adm_cal_type igs_ca_inst.cal_type%TYPE;

368: and ci.sequence_number = c_adm_sequence_number
369: ORDER BY 1 desc;
370:
371: l_adm_due_date_alias igs_ca_da_inst_v.alias_val%TYPE;
372: l_adm_cal_type igs_ca_inst.cal_type%TYPE;
373: l_adm_sequence_number igs_ca_inst.sequence_number%TYPE;
374: l_admission_cat igs_ad_cat.admission_cat%TYPE;
375: l_s_adm_prcs_type igs_ad_pecrs_ofop_dt.s_admission_process_type%TYPE;
376: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

Line 373: l_adm_sequence_number igs_ca_inst.sequence_number%TYPE;

369: ORDER BY 1 desc;
370:
371: l_adm_due_date_alias igs_ca_da_inst_v.alias_val%TYPE;
372: l_adm_cal_type igs_ca_inst.cal_type%TYPE;
373: l_adm_sequence_number igs_ca_inst.sequence_number%TYPE;
374: l_admission_cat igs_ad_cat.admission_cat%TYPE;
375: l_s_adm_prcs_type igs_ad_pecrs_ofop_dt.s_admission_process_type%TYPE;
376: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
377:

Line 376: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

372: l_adm_cal_type igs_ca_inst.cal_type%TYPE;
373: l_adm_sequence_number igs_ca_inst.sequence_number%TYPE;
374: l_admission_cat igs_ad_cat.admission_cat%TYPE;
375: l_s_adm_prcs_type igs_ad_pecrs_ofop_dt.s_admission_process_type%TYPE;
376: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
377:
378:
379: BEGIN
380: l_adm_due_date_alias:=NVL(l_adm_due_date_alias,NULL);

Line 456: l_adm_cal_type igs_ca_inst.cal_type%TYPE ;

452: adm_appl_final_dt_alias
453: FROM IGS_AD_CAL_CONF
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);

Line 457: l_adm_sequence_number igs_ca_inst.sequence_number%TYPE;

453: FROM IGS_AD_CAL_CONF
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: