APPS.IGS_AD_SS_APPL_UPD_PAGE dependencies on IGS_CA_DA

Line 334: l_adm_appl_due_dt_alias igs_ca_da_inst.dt_alias%TYPE;

330: SELECT adm_appl_due_dt_alias
331: FROM igs_ad_cal_conf
332: WHERE s_control_num = 1;
333:
334: l_adm_appl_due_dt_alias igs_ca_da_inst.dt_alias%TYPE;
335:
336: CURSOR override_cur ( c_adm_cal_type VARCHAR2,
337: c_adm_sequence_number NUMBER,
338: c_adm_cat VARCHAR2,

Line 346: FROM igs_ad_pecrs_ofop_dt pod, igs_ca_da_inst dai

342: SELECT IGS_CA_GEN_001.calp_set_alias_value(
343: dai.absolute_val,
344: IGS_CA_GEN_002.cals_clc_dt_from_dai(
345: dai.ci_sequence_number, dai.CAL_TYPE, dai.DT_ALIAS, dai.sequence_number) ) adm_appl_due_dt_alias
346: FROM igs_ad_pecrs_ofop_dt pod, igs_ca_da_inst dai
347: WHERE dai.dt_alias = pod.dt_alias
348: AND dai.sequence_number = pod.dai_sequence_number
349: AND pod.adm_cal_type = c_adm_cal_type
350: AND pod.adm_ci_sequence_number = c_adm_sequence_number

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 371: l_adm_due_date_alias igs_ca_da_inst_v.alias_val%TYPE;

367: and ci.cal_type = c_adm_cal_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;

Line 468: FROM igs_ca_da da, igs_ca_da_inst dai

464: SELECT MAX( IGS_CA_GEN_001.calp_set_alias_value(
465: dai.absolute_val,
466: IGS_CA_GEN_002.cals_clc_dt_from_dai(
467: dai.ci_sequence_number, dai.CAL_TYPE, dai.DT_ALIAS, dai.sequence_number) )) alias_val
468: FROM igs_ca_da da, igs_ca_da_inst dai
469: WHERE da.s_cal_cat = 'ADMISSION'
470: AND da.dt_alias = v_adm_appl_due_dt_alias
471: AND da.dt_alias = dai.dt_alias
472: AND dai.cal_type = l_adm_cal_type