APPS.IGF_AW_ROLLOVER dependencies on IGF_AW_FUND_TD_MAP_ALL

Line 46: igf_aw_fund_td_map_all map

42: CURSOR c_get_fund_todo ( cp_ref_fund_id igf_aw_fund_excl_all.fund_id%TYPE
43: ) IS
44: SELECT DISTINCT mst.*
45: FROM igf_ap_td_item_mst_all mst,
46: igf_aw_fund_td_map_all map
47: WHERE map.fund_id = cp_ref_fund_id
48: AND map.item_sequence_number = mst.todo_number;
49:
50: l_get_fund_todo c_get_fund_todo%ROWTYPE;

Line 58: FROM igf_aw_fund_td_map_all ftodo,

54: CURSOR c_fund_td ( cp_ref_fund_id igf_aw_fund_excl_all.fund_id%TYPE
55: ) IS
56: SELECT tdm.item_code,
57: tdm.career_item
58: FROM igf_aw_fund_td_map_all ftodo,
59: igf_ap_td_item_mst_all tdm
60: WHERE tdm.todo_number = ftodo.item_sequence_number
61: AND ftodo.fund_id = cp_ref_fund_id;
62:

Line 93: l_item_sequence_number igf_aw_fund_td_map_all.item_sequence_number%TYPE;

89:
90: l_rowid VARCHAR2(25);
91: l_todo_number igf_ap_td_item_mst.todo_number%TYPE;
92: l_ftodo_id igf_aw_fund_td_map.ftodo_id%TYPE;
93: l_item_sequence_number igf_aw_fund_td_map_all.item_sequence_number%TYPE;
94: l_todo_item igf_ap_td_item_mst_all.item_code%TYPE := NULL;
95: lv_return_flg VARCHAR2(1);
96:
97: BEGIN