APPS.IGF_AP_GEN_001 dependencies on IGS_CA_DA_INST_V

Line 481: FROM igs_ca_da_inst_v daiv,

477: FUNCTION get_enr_eff_dt_alias_val (cp_cal_type IN igs_Ca_inst.cal_type%TYPE,
478: cp_sequence_number IN igs_ca_inst.sequence_number%TYPE)RETURN DATE IS
479: CURSOR c_min_date IS
480: SELECT TRUNC(MIN(daiv.alias_val)) enrolled_start_dt
481: FROM igs_ca_da_inst_v daiv,
482: igs_en_cal_conf secc
483: WHERE
484: secc.s_control_num = 1 AND
485: daiv.cal_type = cp_cal_type AND