APPS.IGS_AS_NOTIFY_PKG dependencies on IGS_CA_DA_INST

Line 12: FUNCTION get_dt_alias_val (lp_dt_alias IN igs_ca_da_inst.dt_alias%TYPE,

8: || Change History :
9: || Who When What
10: || (reverse chronological order - newest change first)
11: */
12: FUNCTION get_dt_alias_val (lp_dt_alias IN igs_ca_da_inst.dt_alias%TYPE,
13: lp_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,
14: lp_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
15: RETURN DATE IS
16: /*

Line 29: FROM igs_ca_da_inst_v daiv

25: v_alias_val DATE;
26: BEGIN
27:
28: SELECT MAX(daiv.alias_val) INTO v_alias_val
29: FROM igs_ca_da_inst_v daiv
30: WHERE daiv.dt_alias = lp_dt_alias
31: AND daiv.cal_type = lp_teach_cal_type
32: AND daiv.ci_sequence_number = lp_teach_ci_sequence_number;
33: