APPS.IGF_AP_GEN_001 dependencies on IGS_CA_DA_INST

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

Line 712: p_date_alias IN igs_ca_da_inst.dt_alias%TYPE

708: FUNCTION get_date_alias_val(
709: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
710: p_cal_type IN igs_ca_inst.cal_type%TYPE,
711: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
712: p_date_alias IN igs_ca_da_inst.dt_alias%TYPE
713: ) RETURN DATE IS
714: ------------------------------------------------------------------
715: --Created by : ssanyal
716: --Date created: 29-Oct-2004

Line 728: cp_dt_alias igs_ca_da_inst.dt_alias%TYPE,

724: --Who When What
725: --veramach 19-Nov-2004 Fixed issues with passing program version
726: -------------------------------------------------------------------
727: CURSOR cur_get_dt(
728: cp_dt_alias igs_ca_da_inst.dt_alias%TYPE,
729: cp_cal_type igs_ca_da_inst.cal_type%TYPE,
730: cp_ci_sequence_number igs_ca_da_inst.ci_sequence_number%TYPE
731: )IS
732: SELECT dainst.*

Line 729: cp_cal_type igs_ca_da_inst.cal_type%TYPE,

725: --veramach 19-Nov-2004 Fixed issues with passing program version
726: -------------------------------------------------------------------
727: CURSOR cur_get_dt(
728: cp_dt_alias igs_ca_da_inst.dt_alias%TYPE,
729: cp_cal_type igs_ca_da_inst.cal_type%TYPE,
730: cp_ci_sequence_number igs_ca_da_inst.ci_sequence_number%TYPE
731: )IS
732: SELECT dainst.*
733: FROM igs_ca_da_inst dainst

Line 730: cp_ci_sequence_number igs_ca_da_inst.ci_sequence_number%TYPE

726: -------------------------------------------------------------------
727: CURSOR cur_get_dt(
728: cp_dt_alias igs_ca_da_inst.dt_alias%TYPE,
729: cp_cal_type igs_ca_da_inst.cal_type%TYPE,
730: cp_ci_sequence_number igs_ca_da_inst.ci_sequence_number%TYPE
731: )IS
732: SELECT dainst.*
733: FROM igs_ca_da_inst dainst
734: WHERE dainst.dt_alias = cp_dt_alias

Line 733: FROM igs_ca_da_inst dainst

729: cp_cal_type igs_ca_da_inst.cal_type%TYPE,
730: cp_ci_sequence_number igs_ca_da_inst.ci_sequence_number%TYPE
731: )IS
732: SELECT dainst.*
733: FROM igs_ca_da_inst dainst
734: WHERE dainst.dt_alias = cp_dt_alias
735: AND dainst.cal_type = cp_cal_type
736: AND dainst.ci_sequence_number = cp_ci_sequence_number;
737: lc_dt_inst cur_get_dt%ROWTYPE;