APPS.IGF_AW_CANCEL_AWD dependencies on IGF_AW_FUND_MAST_ALL

Line 15: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

11: */
12:
13: FUNCTION chk_awd_exp_date (
14: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
15: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
16: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
17: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
18: p_run_mode IN igf_lookups_view.lookup_code%TYPE
19: )

Line 38: CURSOR c_fund_exp_da(cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE)

34: ||
35: || (reverse chronological order - newest change first)
36: */
37:
38: CURSOR c_fund_exp_da(cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
39: IS
40: SELECT fund_exp_da
41: FROM igf_aw_fund_mast_all
42: WHERE fund_id = cp_fund_id;

Line 41: FROM igf_aw_fund_mast_all

37:
38: CURSOR c_fund_exp_da(cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
39: IS
40: SELECT fund_exp_da
41: FROM igf_aw_fund_mast_all
42: WHERE fund_id = cp_fund_id;
43:
44: l_awd_exp_date DATE := NULL;
45: l_fund_exp_da igf_aw_fund_mast_all.fund_exp_da%TYPE;

Line 45: l_fund_exp_da igf_aw_fund_mast_all.fund_exp_da%TYPE;

41: FROM igf_aw_fund_mast_all
42: WHERE fund_id = cp_fund_id;
43:
44: l_awd_exp_date DATE := NULL;
45: l_fund_exp_da igf_aw_fund_mast_all.fund_exp_da%TYPE;
46: l_result BOOLEAN;
47:
48: BEGIN
49: