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_LI_IMPORT dependencies on IGF_AW_LI_DISB_INTS

Line 1675: FROM igf_aw_li_disb_ints disbint

1671: trim(fee_class_code) fee_class_code,
1672: authorization_date,
1673: TRIM(attendance_type_code) attendance_type_code,
1674: disbint.base_attendance_type_code -- new col added as part of FA131 COD updates build.
1675: FROM igf_aw_li_disb_ints disbint
1676: WHERE ci_alternate_code = li_awd_rec.ci_alternate_code
1677: AND person_number = li_awd_rec.person_number
1678: AND award_number_txt = li_awd_rec.award_number_txt
1679: ORDER BY disbursement_num;

Line 1683: FROM igf_aw_li_disb_ints

1679: ORDER BY disbursement_num;
1680:
1681: CURSOR c_uniq_fee_class IS
1682: SELECT fee_class_code
1683: FROM igf_aw_li_disb_ints
1684: WHERE person_number = li_awd_rec.person_number
1685: AND award_number_txt = li_awd_rec.award_number_txt
1686: GROUP BY fee_class_code
1687: HAVING COUNT(fee_class_code) > 1;

Line 1696: FROM igf_aw_li_disb_ints

1692: SUM(accepted_amt) total_accepted_amt,
1693: COUNT(disbursement_num) number_of_disb,
1694: NVL(MAX(disbursement_num),0) max_disb_number,
1695: NVL(MIN(disbursement_num),0) min_disb_number
1696: FROM igf_aw_li_disb_ints
1697: WHERE ci_alternate_code = li_awd_rec.ci_alternate_code
1698: AND person_number = li_awd_rec.person_number
1699: AND award_number_txt = li_awd_rec.award_number_txt;
1700:

Line 1722: CURSOR c_get_sp_fee_class(p_fee_class_code igf_aw_li_disb_ints.fee_class_code%TYPE) IS

1718: AND fmast.fund_id = g_fund_id
1719: AND fmast.discontinue_fund = 'N';
1720: c_max_year_spnsr_rec c_max_year_spnsr%ROWTYPE;
1721:
1722: CURSOR c_get_sp_fee_class(p_fee_class_code igf_aw_li_disb_ints.fee_class_code%TYPE) IS
1723: SELECT fee_cls_id
1724: FROM igf_sp_fc_all
1725: WHERE fund_id = g_fund_id
1726: AND fee_class = p_fee_class_code;

Line 1729: CURSOR c_get_dact_fws(p_disbursement_num igf_aw_li_disb_ints.disbursement_num%TYPE) IS

1725: WHERE fund_id = g_fund_id
1726: AND fee_class = p_fee_class_code;
1727: c_get_sp_fee_class_rec c_get_sp_fee_class%ROWTYPE;
1728:
1729: CURSOR c_get_dact_fws(p_disbursement_num igf_aw_li_disb_ints.disbursement_num%TYPE) IS
1730: SELECT disb_activity_num
1731: FROM igf_aw_li_dact_ints
1732: WHERE ci_alternate_code = li_awd_rec.ci_alternate_code
1733: AND person_number = li_awd_rec.person_number

Line 1746: FROM igf_aw_li_disb_ints disbint

1742: c_val_lookup_code_rec c_val_lookup_code%ROWTYPE;
1743:
1744: CURSOR c_get_disb_count IS
1745: SELECT count(*)
1746: FROM igf_aw_li_disb_ints disbint
1747: WHERE disbint.ci_alternate_code = li_awd_rec.ci_alternate_code
1748: AND disbint.person_number = li_awd_rec.person_number
1749: AND disbint.award_number_txt = li_awd_rec.award_number_txt
1750: ORDER BY disbursement_num;

Line 1755: FROM igf_aw_li_disb_ints disbint

1751: l_disb_rec_count PLS_INTEGER;
1752:
1753: CURSOR c_get_uniq_ld_code IS
1754: SELECT count(distinct(ld_alternate_code))
1755: FROM igf_aw_li_disb_ints disbint
1756: WHERE ci_alternate_code = li_awd_rec.ci_alternate_code
1757: AND person_number = li_awd_rec.person_number
1758: AND award_number_txt = li_awd_rec.award_number_txt;
1759: l_uniq_ld_code PLS_INTEGER;

Line 1771: FROM igf_aw_li_disb_ints

1767:
1768: CURSOR cur_legacy_disb_fws_total IS
1769: SELECT COUNT (DISTINCT ld_alternate_code) terms,
1770: COUNT (tp_alternate_code) tp
1771: FROM igf_aw_li_disb_ints
1772: WHERE ci_alternate_code = li_awd_rec.ci_alternate_code
1773: AND person_number = li_awd_rec.person_number
1774: AND award_number_txt = li_awd_rec.award_number_txt;
1775:

Line 1790: cur_legacy_disb_int_rec IN igf_aw_li_disb_ints%ROWTYPE,

1786:
1787: l_padding_string VARCHAR2(100);
1788:
1789: PROCEDURE create_disbursment_record(li_awd_rec IN igf_aw_li_awd_ints%ROWTYPE,
1790: cur_legacy_disb_int_rec IN igf_aw_li_disb_ints%ROWTYPE,
1791: l_disb_rec_ins_status OUT NOCOPY VARCHAR2
1792: ) IS
1793: /***************************************************************
1794: Created By : nsidana

Line 2494: li_awd_disb_rec igf_aw_li_disb_ints%ROWTYPE,

2490: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
2491: END validate_disburs_int_rec;
2492:
2493: PROCEDURE validate_disb_act_int_rec(li_awd_rec igf_aw_li_awd_ints%ROWTYPE,
2494: li_awd_disb_rec igf_aw_li_disb_ints%ROWTYPE,
2495: p_return_status OUT NOCOPY VARCHAR2
2496: ) IS
2497: /***************************************************************
2498: Created By : nsidana

Line 3127: li_awd_disb_rec igf_aw_li_disb_ints%ROWTYPE,

3123: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
3124: END validate_disb_act_int_rec;
3125:
3126: PROCEDURE validate_disb_hold_int_rec(li_awd_rec igf_aw_li_awd_ints%ROWTYPE,
3127: li_awd_disb_rec igf_aw_li_disb_ints%ROWTYPE,
3128: p_return_status OUT NOCOPY VARCHAR2
3129: ) IS
3130: /***************************************************************
3131: Created By : nsidana

Line 3311: DELETE FROM igf_aw_li_disb_ints

3307: WHERE ci_alternate_code = ctx_li_awd_rec.ci_alternate_code
3308: AND person_number = ctx_li_awd_rec.person_number
3309: AND award_number_txt = ctx_li_awd_rec.award_number_txt;
3310:
3311: DELETE FROM igf_aw_li_disb_ints
3312: WHERE ci_alternate_code = ctx_li_awd_rec.ci_alternate_code
3313: AND person_number = ctx_li_awd_rec.person_number
3314: AND award_number_txt = ctx_li_awd_rec.award_number_txt;
3315: