APPS.IGF_AW_ROLLOVER dependencies on IGF_AW_FUND_TD_MAP

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 92: l_ftodo_id igf_aw_fund_td_map.ftodo_id%TYPE;

88:
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:

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

Line 187: igf_aw_fund_td_map_pkg.insert_row (

183: END IF;
184:
185: l_rowid := NULL;
186: l_ftodo_id := NULL;
187: igf_aw_fund_td_map_pkg.insert_row (
188: x_rowid => l_rowid,
189: x_ftodo_id => l_ftodo_id,
190: x_fund_id => p_new_fund_id,
191: x_item_sequence_number => l_item_sequence_number