eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGF_AW_PACKAGING dependencies on IGF_AW_AWD_FRML_DET_ALL

Line 5611: x_group_code igf_aw_awd_frml_det_all.formula_code%TYPE,

5607: -- Retrieves all the funds that are part of the Formula Code in Sequence and loads the temporary table
5608: -- If this procedure being called from Single Fund, then retrive the details of fund directly.
5609: -- If not called from Single fund, then load all the funds which are linked to the given group code
5610: CURSOR c_fund_ld(
5611: x_group_code igf_aw_awd_frml_det_all.formula_code%TYPE,
5612: x_ci_cal_type igf_aw_awd_frml_det_all.ci_cal_type%TYPE,
5613: x_ci_sequence_number igf_aw_awd_frml_det_all.ci_sequence_number%TYPE
5614: ) IS
5615: SELECT fmdet.fund_id fund_id,

Line 5612: x_ci_cal_type igf_aw_awd_frml_det_all.ci_cal_type%TYPE,

5608: -- If this procedure being called from Single Fund, then retrive the details of fund directly.
5609: -- If not called from Single fund, then load all the funds which are linked to the given group code
5610: CURSOR c_fund_ld(
5611: x_group_code igf_aw_awd_frml_det_all.formula_code%TYPE,
5612: x_ci_cal_type igf_aw_awd_frml_det_all.ci_cal_type%TYPE,
5613: x_ci_sequence_number igf_aw_awd_frml_det_all.ci_sequence_number%TYPE
5614: ) IS
5615: SELECT fmdet.fund_id fund_id,
5616: fmast.fund_code,

Line 5613: x_ci_sequence_number igf_aw_awd_frml_det_all.ci_sequence_number%TYPE

5609: -- If not called from Single fund, then load all the funds which are linked to the given group code
5610: CURSOR c_fund_ld(
5611: x_group_code igf_aw_awd_frml_det_all.formula_code%TYPE,
5612: x_ci_cal_type igf_aw_awd_frml_det_all.ci_cal_type%TYPE,
5613: x_ci_sequence_number igf_aw_awd_frml_det_all.ci_sequence_number%TYPE
5614: ) IS
5615: SELECT fmdet.fund_id fund_id,
5616: fmast.fund_code,
5617: fmdet.seq_no seq_no,

Line 5686: cp_seq_no igf_aw_awd_frml_det_all.seq_no%TYPE,

5682:
5683: CURSOR c_rmv_funds(
5684: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
5685: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
5686: cp_seq_no igf_aw_awd_frml_det_all.seq_no%TYPE,
5687: cp_formula_code igf_aw_awd_frml_det_all.formula_code%TYPE,
5688: cp_ci_cal_type igf_aw_awd_frml_det_all.ci_cal_type%TYPE,
5689: cp_ci_sequence_number igf_aw_awd_frml_det_all.ci_sequence_number%TYPE
5690: ) IS

Line 5687: cp_formula_code igf_aw_awd_frml_det_all.formula_code%TYPE,

5683: CURSOR c_rmv_funds(
5684: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
5685: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
5686: cp_seq_no igf_aw_awd_frml_det_all.seq_no%TYPE,
5687: cp_formula_code igf_aw_awd_frml_det_all.formula_code%TYPE,
5688: cp_ci_cal_type igf_aw_awd_frml_det_all.ci_cal_type%TYPE,
5689: cp_ci_sequence_number igf_aw_awd_frml_det_all.ci_sequence_number%TYPE
5690: ) IS
5691: SELECT fmdet.seq_no, fmdet.pe_group_id, grp.group_cd

Line 5688: cp_ci_cal_type igf_aw_awd_frml_det_all.ci_cal_type%TYPE,

5684: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
5685: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
5686: cp_seq_no igf_aw_awd_frml_det_all.seq_no%TYPE,
5687: cp_formula_code igf_aw_awd_frml_det_all.formula_code%TYPE,
5688: cp_ci_cal_type igf_aw_awd_frml_det_all.ci_cal_type%TYPE,
5689: cp_ci_sequence_number igf_aw_awd_frml_det_all.ci_sequence_number%TYPE
5690: ) IS
5691: SELECT fmdet.seq_no, fmdet.pe_group_id, grp.group_cd
5692: FROM igf_aw_awd_frml_det fmdet,

Line 5689: cp_ci_sequence_number igf_aw_awd_frml_det_all.ci_sequence_number%TYPE

5685: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
5686: cp_seq_no igf_aw_awd_frml_det_all.seq_no%TYPE,
5687: cp_formula_code igf_aw_awd_frml_det_all.formula_code%TYPE,
5688: cp_ci_cal_type igf_aw_awd_frml_det_all.ci_cal_type%TYPE,
5689: cp_ci_sequence_number igf_aw_awd_frml_det_all.ci_sequence_number%TYPE
5690: ) IS
5691: SELECT fmdet.seq_no, fmdet.pe_group_id, grp.group_cd
5692: FROM igf_aw_awd_frml_det fmdet,
5693: igf_aw_fund_mast fmast,

Line 5758: cp_group_code igf_aw_awd_frml_det_all.formula_code%TYPE,

5754:
5755: CURSOR c_other_awards(
5756: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
5757: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
5758: cp_group_code igf_aw_awd_frml_det_all.formula_code%TYPE,
5759: cp_ci_cal_type igf_aw_awd_frml_det_all.ci_cal_type%TYPE,
5760: cp_ci_sequence_number igf_aw_awd_frml_det_all.ci_sequence_number%TYPE
5761: ) IS
5762: SELECT DISTINCT fmast.fund_id,

Line 5759: cp_ci_cal_type igf_aw_awd_frml_det_all.ci_cal_type%TYPE,

5755: CURSOR c_other_awards(
5756: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
5757: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
5758: cp_group_code igf_aw_awd_frml_det_all.formula_code%TYPE,
5759: cp_ci_cal_type igf_aw_awd_frml_det_all.ci_cal_type%TYPE,
5760: cp_ci_sequence_number igf_aw_awd_frml_det_all.ci_sequence_number%TYPE
5761: ) IS
5762: SELECT DISTINCT fmast.fund_id,
5763: fmast.lock_award_flag,

Line 5760: cp_ci_sequence_number igf_aw_awd_frml_det_all.ci_sequence_number%TYPE

5756: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
5757: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
5758: cp_group_code igf_aw_awd_frml_det_all.formula_code%TYPE,
5759: cp_ci_cal_type igf_aw_awd_frml_det_all.ci_cal_type%TYPE,
5760: cp_ci_sequence_number igf_aw_awd_frml_det_all.ci_sequence_number%TYPE
5761: ) IS
5762: SELECT DISTINCT fmast.fund_id,
5763: fmast.lock_award_flag,
5764: fmast.re_pkg_verif_flag,

Line 5779: FROM igf_aw_awd_frml_det_all fmdet

5775: AND aprd.ci_cal_type = fmast.ci_cal_type
5776: AND aprd.ci_sequence_number = fmast.ci_sequence_number
5777: AND aprd.award_prd_cd = cp_awd_prd_code
5778: AND awd.fund_id NOT IN (SELECT fmdet.fund_id
5779: FROM igf_aw_awd_frml_det_all fmdet
5780: WHERE fmdet.formula_code = cp_group_code
5781: AND fmdet.ci_cal_type = cp_ci_cal_type
5782: AND fmdet.ci_sequence_number = cp_ci_sequence_number);
5783: