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.

APPS.IGF_AW_PACKAGING dependencies on IGF_AW_TARGET_GRP

Line 1009: x_group_code igf_aw_target_grp_all.group_cd%TYPE ,

1005: */
1006:
1007: -- All students who fall within the current Target group are processed
1008: CURSOR c_group(
1009: x_group_code igf_aw_target_grp_all.group_cd%TYPE ,
1010: x_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ,
1011: x_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
1012: ) IS
1013: SELECT fa_detail.base_id,

Line 7687: x_group_cd igf_aw_target_grp_all.group_cd%TYPE,

7683: l_fabase c_fabase%ROWTYPE;
7684:
7685: -- Retrieves all the Formula Policies
7686: CURSOR c_frml_plcy(
7687: x_group_cd igf_aw_target_grp_all.group_cd%TYPE,
7688: x_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
7689: x_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
7690: ) IS
7691: SELECT tgrp.*

Line 7692: FROM igf_aw_target_grp_all tgrp

7688: x_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
7689: x_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
7690: ) IS
7691: SELECT tgrp.*
7692: FROM igf_aw_target_grp_all tgrp
7693: WHERE tgrp.cal_type = x_ci_cal_type
7694: AND tgrp.sequence_number = x_ci_sequence_number
7695: AND tgrp.group_cd = x_group_cd;
7696:

Line 8342: x_group_code igf_aw_target_grp_all.group_cd%TYPE,

8338:
8339: -- Retrieves all the funds that are part of the Formula Code in Sequence
8340: -- It has a link to igf_aw_award_t with a flag = 'CF' ie the valid funds
8341: CURSOR c_fund(
8342: x_group_code igf_aw_target_grp_all.group_cd%TYPE,
8343: x_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
8344: x_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
8345: x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
8346: x_process_id NUMBER

Line 13106: cp_grp_code igf_aw_target_grp_all.group_cd%TYPE,

13102: l_dp igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE;
13103:
13104: -- Get award group
13105: CURSOR c_awd_grp(
13106: cp_grp_code igf_aw_target_grp_all.group_cd%TYPE,
13107: cp_award_year VARCHAR2
13108: ) IS
13109: SELECT description
13110: FROM igf_aw_target_grp_all

Line 13110: FROM igf_aw_target_grp_all

13106: cp_grp_code igf_aw_target_grp_all.group_cd%TYPE,
13107: cp_award_year VARCHAR2
13108: ) IS
13109: SELECT description
13110: FROM igf_aw_target_grp_all
13111: WHERE group_cd = cp_grp_code
13112: AND cal_type = TRIM(SUBSTR(cp_award_year,1,10))
13113: AND sequence_number = TO_NUMBER(SUBSTR(p_award_year,11));
13114: l_awd_grp c_awd_grp%ROWTYPE;

Line 13353: cp_group_cd igf_aw_target_grp_all.group_cd%TYPE

13349: l_count NUMBER := 0;
13350:
13351: -- Get distribution plan associated with a target group
13352: CURSOR c_tgrp_dist(
13353: cp_group_cd igf_aw_target_grp_all.group_cd%TYPE
13354: ) IS
13355: SELECT adplans_id
13356: FROM igf_aw_target_grp
13357: WHERE group_cd = cp_group_cd;

Line 13356: FROM igf_aw_target_grp

13352: CURSOR c_tgrp_dist(
13353: cp_group_cd igf_aw_target_grp_all.group_cd%TYPE
13354: ) IS
13355: SELECT adplans_id
13356: FROM igf_aw_target_grp
13357: WHERE group_cd = cp_group_cd;
13358: l_tgrp_dist c_tgrp_dist%ROWTYPE;
13359: lv_result VARCHAR2(80);
13360: lv_method_code igf_aw_awd_dist_plans.dist_plan_method_code%TYPE;