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

Line 4722: FROM igf_aw_awd_frml_det

4718: WHERE base_id = cp_base_id
4719: AND process_id = l_process_id
4720: AND flag = 'AU'
4721: AND fund_id NOT IN (SELECT fund_id
4722: FROM igf_aw_awd_frml_det
4723: WHERE formula_code = cp_target_group
4724: AND ci_cal_type = cp_ci_cal_type
4725: AND ci_sequence_number = cp_ci_sequence_number);
4726: l_rep_funds c_rep_funds%ROWTYPE;

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 5633: FROM igf_aw_awd_frml_det fmdet,

5629: fmdet.pe_group_id pe_group_id,
5630: fmdet.adplans_id adplans_id,
5631: fmast.re_pkg_verif_flag re_pkg_verif_flag,
5632: NVL(fmdet.lock_award_flag,fmast.lock_award_flag) lock_award_flag
5633: FROM igf_aw_awd_frml_det fmdet,
5634: igf_aw_fund_mast_all fmast
5635: WHERE fmdet.formula_code = x_group_code
5636: AND fmdet.ci_cal_type = x_ci_cal_type
5637: AND fmdet.ci_sequence_number = x_ci_sequence_number

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 5692: FROM igf_aw_awd_frml_det fmdet,

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,
5694: igs_pe_all_persid_group_v grp
5695: WHERE fmast.fund_id = cp_fund_id
5696: AND fmdet.fund_id = fmast.fund_id

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:

Line 8696: seq_no igf_aw_awd_frml_det.seq_no%TYPE,

8692: fund_Code igf_aw_fund_mast_v.fund_code%TYPE,
8693: offered_amt igf_aw_award_t.offered_amt%TYPE,
8694: accepted_amt igf_aw_award_t.accepted_Amt%TYPE,
8695: total NUMBER,
8696: seq_no igf_aw_awd_frml_det.seq_no%TYPE,
8697: adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
8698: award_id igf_aw_award_all.award_id%TYPE,
8699: lock_award_flag igf_aw_award_all.lock_award_flag%TYPE
8700: );