APPS.IGS_EN_GEN_008 dependencies on IGS_CA_GEN_001

Line 79: IGS_CA_GEN_001.calp_set_alias_value(daiv.absolute_val,

75: --modified cursor for bug 3696257
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,

Line 351: SELECT igs_ca_gen_001.calp_set_alias_value(dai.absolute_val,

347: -- cursor for getting the date aliases that are defined
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

Line 2278: IGS_CA_GEN_001.calp_set_alias_value(dai.absolute_val,

2274: -- Modiified cursor for performance bug 3696153
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

Line 2511: IGS_CA_GEN_001.calp_set_alias_value(dai.absolute_val,

2507: --Modified the cursor for performance bug 3696257
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