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_AWD_DISB_ALL

Line 742: FROM igf_aw_awd_disb_all disb

738: AND awd.base_id = p_base_id
739: AND NOT EXISTS(
740: SELECT disb.ld_cal_type,
741: disb.ld_sequence_number
742: FROM igf_aw_awd_disb_all disb
743: WHERE disb.award_id = awd.award_id
744: MINUS
745: SELECT ld_cal_type,
746: ld_sequence_number

Line 1137: FROM igf_aw_awd_disb_all adisb

1133:
1134: -- Retrieves all simulated disbursement records
1135: CURSOR c_sim_adisb ( cp_award_id igf_aw_award_all.award_id%TYPE ) IS
1136: SELECT adisb.rowid row_id
1137: FROM igf_aw_awd_disb_all adisb
1138: WHERE adisb.award_id = cp_award_id;
1139:
1140: -- Retrieves all simulated award records
1141: CURSOR c_sim_awd ( cp_base_id igf_aw_award_all.base_id%TYPE ) IS

Line 1422: FROM igf_aw_awd_disb_all disb

1418: cp_award_id igf_aw_award_all.award_id%TYPE
1419: ) IS
1420: SELECT disb.rowid row_id,
1421: disb.*
1422: FROM igf_aw_awd_disb_all disb
1423: WHERE award_id = cp_award_id;
1424:
1425: -- Get Fund Code from fund_id
1426: CURSOR c_fund_code(

Line 2244: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE

2240:
2241: -- Get a specific disbursment for an award
2242: CURSOR c_disb(
2243: cp_award_id igf_aw_award_all.award_id%TYPE,
2244: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
2245: ) IS
2246: SELECT rowid row_id,
2247: disb.*
2248: FROM igf_aw_awd_disb_all disb

Line 2248: FROM igf_aw_awd_disb_all disb

2244: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
2245: ) IS
2246: SELECT rowid row_id,
2247: disb.*
2248: FROM igf_aw_awd_disb_all disb
2249: WHERE award_id = cp_award_id
2250: AND disb_num = cp_disb_num;
2251:
2252: l_disb c_disb%ROWTYPE;

Line 2293: l_attendance_type_code igf_aw_awd_disb_all.attendance_type_code%TYPE;

2289: ln_com_perct NUMBER;
2290: l_alt_pell_schedule igf_aw_award_all.alt_pell_schedule%TYPE;
2291: lb_awards_created BOOLEAN;
2292: lv_update_notif_stat VARCHAR(2);
2293: l_attendance_type_code igf_aw_awd_disb_all.attendance_type_code%TYPE;
2294: l_base_attendance_type_code igf_aw_awd_disb_all.base_attendance_type_code%TYPE;
2295: ln_total_disb_num NUMBER;
2296: lv_awd_notif_status VARCHAR2(1);
2297: SKIP_RECORD EXCEPTION;

Line 2294: l_base_attendance_type_code igf_aw_awd_disb_all.base_attendance_type_code%TYPE;

2290: l_alt_pell_schedule igf_aw_award_all.alt_pell_schedule%TYPE;
2291: lb_awards_created BOOLEAN;
2292: lv_update_notif_stat VARCHAR(2);
2293: l_attendance_type_code igf_aw_awd_disb_all.attendance_type_code%TYPE;
2294: l_base_attendance_type_code igf_aw_awd_disb_all.base_attendance_type_code%TYPE;
2295: ln_total_disb_num NUMBER;
2296: lv_awd_notif_status VARCHAR2(1);
2297: SKIP_RECORD EXCEPTION;
2298:

Line 2330: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE

2326:
2327: -- Get disbursements which should be cancelled
2328: CURSOR c_disb_cancel(
2329: cp_award_id igf_aw_award_all.award_id%TYPE,
2330: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
2331: ) IS
2332: SELECT *
2333: FROM igf_aw_awd_disb
2334: WHERE award_id = cp_award_id

Line 2342: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE

2338:
2339: -- Get pell disb orig
2340: CURSOR c_pell_disb_orig(
2341: cp_award_id igf_aw_award_all.award_id%TYPE,
2342: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
2343: ) IS
2344: SELECT rfmd.ROWID row_id,
2345: rfmd.*
2346: FROM igf_gr_rfms_all rfms,

Line 3845: is directly picked from the IGF_AW_AWD_DISB_ALL table.

3841: /* this PELL award has been already originated.
3842: so insert a disbursement origination record for this new disbursement
3843: we do this only for phase-in participant years - for full participant years,
3844: there will no IGF_GR_RFMS_DISB record. While sending the origination, the data
3845: is directly picked from the IGF_AW_AWD_DISB_ALL table.
3846: */
3847: lv_row_id := NULL;
3848: lv_rfmd_id := NULL;
3849:

Line 4341: FROM igf_aw_awd_disb_all

4337: -------------------------------------------------------------------
4338:
4339: CURSOR c_adisb IS
4340: SELECT 'x'
4341: FROM igf_aw_awd_disb_all
4342: WHERE award_id = p_award_id
4343: AND trans_type = 'A'
4344: AND ROWNUM = 1;
4345: l_adisb c_adisb%ROWTYPE;

Line 4383: igf_aw_awd_disb_all disb,

4379:
4380: CURSOR c_awd IS
4381: SELECT 'x'
4382: FROM igf_aw_award_all awd,
4383: igf_aw_awd_disb_all disb,
4384: igf_aw_awd_prd_term aprd
4385: WHERE awd.fund_id = p_fund_id
4386: AND awd.base_id = p_base_id
4387: AND awd.award_status IN ('ACCEPTED','OFFERED','CANCELLED')

Line 4542: FROM igf_aw_awd_disb_all

4538: SELECT 'x'
4539: FROM DUAL
4540: WHERE EXISTS(
4541: SELECT 'x'
4542: FROM igf_aw_awd_disb_all
4543: WHERE award_id = p_award_id
4544: AND (ld_cal_type, ld_sequence_number) IN(
4545: SELECT ld_cal_type,
4546: ld_sequence_number

Line 4553: FROM igf_aw_awd_disb_all

4549: AND ci_sequence_number = p_ci_sequence_number
4550: AND award_prd_cd = p_awd_prd_code))
4551: AND EXISTS(
4552: SELECT 'x'
4553: FROM igf_aw_awd_disb_all
4554: WHERE award_id = p_award_id
4555: AND (ld_cal_type, ld_sequence_number) NOT IN(
4556: SELECT ld_cal_type,
4557: ld_sequence_number

Line 4914: igf_aw_awd_disb_all disb,

4910: AND lv_fed_fund_code <> 'PELL'
4911: AND awd.award_id IN(
4912: SELECT DISTINCT awd.award_id
4913: FROM igf_aw_award_all awd,
4914: igf_aw_awd_disb_all disb,
4915: igf_aw_awd_prd_term aprd
4916: WHERE awd.fund_id = cp_fund_id
4917: AND awd.base_id = cp_base_id
4918: AND awd.award_id = disb.award_id

Line 5768: igf_aw_awd_disb_all disb,

5764: fmast.re_pkg_verif_flag,
5765: fmast.donot_repkg_if_code
5766: FROM igf_aw_award_all awd,
5767: igf_aw_fund_mast_all fmast,
5768: igf_aw_awd_disb_all disb,
5769: igf_aw_awd_prd_term aprd
5770: WHERE fmast.fund_id = awd.fund_id
5771: AND awd.base_id = cp_base_id
5772: AND awd.award_id = disb.award_id

Line 6677: igf_aw_awd_disb_all disb,

6673: x_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
6674: ) IS
6675: SELECT COUNT(fmast.fund_code) ftotal
6676: FROM igf_aw_award_all awd,
6677: igf_aw_awd_disb_all disb,
6678: igf_aw_fund_mast_all fmast,
6679: igf_aw_awd_prd_term aprd
6680: WHERE fmast.fund_code = x_fund_code
6681: AND awd.base_id = x_base_id

Line 7580: FROM igf_aw_awd_disb_all disb

7576: AND awd.base_id = p_base_id
7577: AND NOT EXISTS(
7578: SELECT disb.ld_cal_type,
7579: disb.ld_sequence_number
7580: FROM igf_aw_awd_disb_all disb
7581: WHERE disb.award_id = awd.award_id
7582: MINUS
7583: SELECT ld_cal_type,
7584: ld_sequence_number

Line 8455: FROM igf_aw_awd_disb_all disb,

8451: cp_fund_id igf_aw_award_all.fund_id%TYPE,
8452: cp_base_id igf_aw_award_all.base_id%TYPE
8453: ) IS
8454: SELECT SUM(disb.disb_gross_amt) yr_total
8455: FROM igf_aw_awd_disb_all disb,
8456: igf_aw_award_all awd,
8457: igf_aw_fund_mast_all fmast
8458: WHERE disb.award_id = awd.award_id
8459: AND fmast.fund_id = awd.fund_id

Line 8488: igf_aw_awd_disb_all disb,

8484: SELECT
8485: NVL(SUM(NVL(disb.disb_gross_amt,0)),0) lf_total,
8486: COUNT(DISTINCT awd.award_id) lf_count
8487: FROM
8488: igf_aw_awd_disb_all disb,
8489: igf_aw_award_all awd,
8490: igf_aw_fund_mast_all fmast,
8491: igf_ap_fa_base_rec_all fabase
8492: WHERE fmast.fund_code = cp_fund_code

Line 8812: FROM igf_aw_awd_disb_all disb,

8808: disb.ld_sequence_number,
8809: disb.base_attendance_type_code,
8810: SUM(disb.disb_gross_amt) term_total,
8811: awd.adplans_id
8812: FROM igf_aw_awd_disb_all disb,
8813: igf_aw_award_all awd
8814: WHERE awd.award_id = disb.award_id
8815: AND awd.award_id = p_award_id
8816: GROUP BY disb.ld_cal_type,

Line 8831: FROM igf_aw_awd_disb_all

8827: ) IS
8828: SELECT disb_date,
8829: tp_cal_type,
8830: tp_sequence_number
8831: FROM igf_aw_awd_disb_all
8832: WHERE award_id = cp_award_id
8833: AND ld_cal_type = cp_ld_cal_type
8834: AND ld_sequence_number = cp_ld_sequence_number
8835: AND ROWNUM = 1

Line 12097: FROM igf_aw_awd_disb_all disb

12093: cp_award_id igf_aw_award_all.award_id%TYPE
12094: ) IS
12095: SELECT disb.rowid row_id,
12096: disb.*
12097: FROM igf_aw_awd_disb_all disb
12098: WHERE disb.award_id = cp_award_id
12099: AND disb.trans_type <> 'C'
12100: ORDER BY disb.disb_num;
12101: