APPS.IGS_EN_PRC_LOAD dependencies on IGS_CA_GEN_001

Line 307: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL (

303: CURSOR c_sgcc_dai (
304: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
305: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE) IS
306: SELECT NVL( dai.absolute_val,
307: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL (
308: dai.dt_alias,
309: dai.sequence_number,
310: dai.cal_type,
311: dai.ci_sequence_number)) AS census_dt

Line 921: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(

917: cal.effective_end_dt >= SYSDATE)
918: ORDER BY cal.yr_num;
919: CURSOR c_sgcc_dai IS
920: SELECT NVL ( absolute_val,
921: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(
922: dai.dt_alias,
923: dai.sequence_number,
924: dai.cal_type,
925: dai.ci_sequence_number)) AS census_dt