APPS.IGS_AD_SS_APPL_UPD_PAGE dependencies on IGS_CA_GEN_002

Line 344: IGS_CA_GEN_002.cals_clc_dt_from_dai(

340: c_s_adm_prcs_type VARCHAR2
341: ) IS
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

Line 361: IGS_CA_GEN_002.cals_clc_dt_from_dai(

357: c_adm_sequence_number NUMBER
358: ) IS
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

Line 466: IGS_CA_GEN_002.cals_clc_dt_from_dai(

462:
463: CURSOR c_dai IS
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