DBA Data[Home] [Help]

APPS.IGF_SP_ASSIGN_PUB dependencies on IGF_AW_FUND_TP

Line 255: cp_c_ld_cal_type igf_aw_fund_tp.tp_cal_type%TYPE,

251: CURSOR c_check_spn_awd(cp_c_fund_code igf_aw_fund_mast.fund_code%TYPE,
252: cp_c_fund_status igf_aw_fund_mast.discontinue_fund%TYPE,
253: cp_c_aw_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
254: cp_n_aw_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
255: cp_c_ld_cal_type igf_aw_fund_tp.tp_cal_type%TYPE,
256: cp_n_ld_sequence_number igf_aw_fund_tp.tp_sequence_number%TYPE)
257: IS
258: SELECT m.fund_id
259: FROM igf_aw_fund_mast m,

Line 256: cp_n_ld_sequence_number igf_aw_fund_tp.tp_sequence_number%TYPE)

252: cp_c_fund_status igf_aw_fund_mast.discontinue_fund%TYPE,
253: cp_c_aw_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
254: cp_n_aw_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
255: cp_c_ld_cal_type igf_aw_fund_tp.tp_cal_type%TYPE,
256: cp_n_ld_sequence_number igf_aw_fund_tp.tp_sequence_number%TYPE)
257: IS
258: SELECT m.fund_id
259: FROM igf_aw_fund_mast m,
260: igf_aw_fund_tp t

Line 260: igf_aw_fund_tp t

256: cp_n_ld_sequence_number igf_aw_fund_tp.tp_sequence_number%TYPE)
257: IS
258: SELECT m.fund_id
259: FROM igf_aw_fund_mast m,
260: igf_aw_fund_tp t
261: WHERE m.fund_id = t.fund_id AND
262: m.fund_code = cp_c_fund_code AND
263: m.ci_cal_type = cp_c_aw_cal_type AND
264: m.ci_sequence_number = cp_n_aw_sequence_number AND