APPS.IGS_EN_GEN_008 dependencies on IGS_CA_GEN_002

Line 80: IGS_CA_GEN_002.cals_clc_dt_from_dai(daiv.ci_sequence_number,

76: CURSOR cur_pe_usr_adisc (cp_person_type igs_pe_person_types.person_type_code%TYPE)
77: IS
78: SELECT nvl(daiv.absolute_val,
79: IGS_CA_GEN_001.calp_set_alias_value(daiv.absolute_val,
80: IGS_CA_GEN_002.cals_clc_dt_from_dai(daiv.ci_sequence_number,
81: daiv.CAL_TYPE,
82: daiv.DT_ALIAS, daiv.sequence_number) ) ) alias_val
83: FROM igs_pe_usr_adisc_all pua,
84: igs_ca_da_inst daiv

Line 352: igs_ca_gen_002.cals_clc_dt_from_dai(dai.ci_sequence_number,

348: -- at the institutional level for the logged on person
349: CURSOR cur_inst_date_aliases
350: IS
351: SELECT igs_ca_gen_001.calp_set_alias_value(dai.absolute_val,
352: igs_ca_gen_002.cals_clc_dt_from_dai(dai.ci_sequence_number,
353: dai.cal_type,
354: dai.dt_alias,
355: dai.sequence_number
356: )

Line 2279: IGS_CA_GEN_002.cals_clc_dt_from_dai(dai.ci_sequence_number, dai.CAL_TYPE,

2275: CURSOR cur_pe_usr_arg( cp_person_type IN igs_pe_person_types.person_type_code%TYPE)
2276: IS
2277: SELECT nvl(dai.absolute_val,
2278: IGS_CA_GEN_001.calp_set_alias_value(dai.absolute_val,
2279: IGS_CA_GEN_002.cals_clc_dt_from_dai(dai.ci_sequence_number, dai.CAL_TYPE,
2280: dai.DT_ALIAS, dai.sequence_number) ) ) alias_val
2281: FROM IGS_PE_USR_ARG_ALL pua,
2282: IGS_CA_DA_INST dai
2283: WHERE pua.person_type = cp_person_type

Line 2512: IGS_CA_GEN_002.cals_clc_dt_from_dai(dai.ci_sequence_number, dai.CAL_TYPE,

2508: CURSOR cur_pe_usr_arg( cp_person_type IN igs_pe_person_types.person_type_code%TYPE)
2509: IS
2510: SELECT nvl(dai.absolute_val,
2511: IGS_CA_GEN_001.calp_set_alias_value(dai.absolute_val,
2512: IGS_CA_GEN_002.cals_clc_dt_from_dai(dai.ci_sequence_number, dai.CAL_TYPE,
2513: dai.DT_ALIAS, dai.sequence_number) ) ) alias_val
2514: FROM igs_ca_da_inst dai,igs_pe_usr_arg_all pua
2515: WHERE pua.person_type = cp_person_type
2516: AND dai.dt_alias = pua.grad_sch_dt_alias