APPS.IGF_AW_ROLLOVER dependencies on IGF_AW_FUND_EXCL_ALL

Line 42: CURSOR c_get_fund_todo ( cp_ref_fund_id igf_aw_fund_excl_all.fund_id%TYPE

38: --
39: --------------------------------------------------------------------------------
40:
41: --Cursor to fetch the todo details attached to the fund id
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

Line 54: CURSOR c_fund_td ( cp_ref_fund_id igf_aw_fund_excl_all.fund_id%TYPE

50: l_get_fund_todo c_get_fund_todo%ROWTYPE;
51:
52:
53: --Cursor to fetch the todo items attached to the fund id
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,

Line 225: CURSOR c_get_feeclass ( cp_ref_fund_id igf_aw_fund_excl_all.fund_id%TYPE

221: --
222: --------------------------------------------------------------------------------
223:
224: -- Get the details of the feeclasses for a given Fund ID
225: CURSOR c_get_feeclass ( cp_ref_fund_id igf_aw_fund_excl_all.fund_id%TYPE
226: ) IS
227: SELECT fcls.fclass_id, fcls.fee_class
228: FROM igf_aw_fund_feeclas_all fcls
229: WHERE fund_id = cp_ref_fund_id;

Line 277: CURSOR c_get_units ( cp_ref_fund_id igf_aw_fund_excl_all.fund_id%TYPE

273: --
274: --------------------------------------------------------------------------------
275:
276: -- Get the details of the pay units for a given Fund ID
277: CURSOR c_get_units ( cp_ref_fund_id igf_aw_fund_excl_all.fund_id%TYPE
278: ) IS
279: SELECT unt.unit_cd
280: FROM igf_aw_fund_unit_all unt
281: WHERE fund_id = cp_ref_fund_id;

Line 341: CURSOR c_get_programs ( cp_ref_fund_id igf_aw_fund_excl_all.fund_id%TYPE

337: --
338: --------------------------------------------------------------------------------
339:
340: -- Get the details of the pay programs for a given Fund ID
341: CURSOR c_get_programs ( cp_ref_fund_id igf_aw_fund_excl_all.fund_id%TYPE
342: ) IS
343: SELECT prg.course_cd
344: FROM igf_aw_fund_prg_all prg
345: WHERE fund_id = cp_ref_fund_id;

Line 407: CURSOR c_fund_excl( cp_ref_fund_id igf_aw_fund_excl_all.fund_id%TYPE

403: --
404: --------------------------------------------------------------------------------
405:
406: -- Get the details of the existing Exclusive Funds for a given Fund ID
407: CURSOR c_fund_excl( cp_ref_fund_id igf_aw_fund_excl_all.fund_id%TYPE
408: ) IS
409: SELECT excl.fund_code
410: FROM igf_aw_fund_excl_all excl
411: WHERE excl.fund_id = cp_ref_fund_id;

Line 410: FROM igf_aw_fund_excl_all excl

406: -- Get the details of the existing Exclusive Funds for a given Fund ID
407: CURSOR c_fund_excl( cp_ref_fund_id igf_aw_fund_excl_all.fund_id%TYPE
408: ) IS
409: SELECT excl.fund_code
410: FROM igf_aw_fund_excl_all excl
411: WHERE excl.fund_id = cp_ref_fund_id;
412:
413: -- check whether the fund is a discontinued fund or not
414: CURSOR c_chk_disc_fund( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,