APPS.IGF_AW_GEN_003 dependencies on IGF_AW_COA_ITEMS

Line 468: -- using igf_aw_coa_items instead

464: -- Removed packaging hold
465: -------------------------------------------------------------------
466: -- adhawan 25-oct-2002 Bug 2613546
467: -- Obsoletion of igf_aw_cit_ssn ,
468: -- using igf_aw_coa_items instead
469: -- Getting pell_coa_amount,
470: -- pell_alt_expense
471: -- and updating in Fa base
472: -- Added pell_alt_exp in update

Line 507: FROM igf_aw_coa_items citsn

503: SUM(NVL(citsn.amount,0)) coa_total,
504: SUM(NVL(citsn.pell_coa_amount,0)) pell_coa,
505: SUM(NVL(citsn.alt_pell_amount,0)) pell_alt_expense,
506: SUM(DECODE(citsn.fixed_cost,'Y',NVL(citsn.amount,0),0) ) fixed_coa
507: FROM igf_aw_coa_items citsn
508: WHERE citsn.base_id = p_base_id ;
509:
510: tot_coa_rec cur_tot_coa%ROWTYPE;
511:

Line 520: FROM igf_aw_coa_items citsn

516: IS
517: SELECT
518: SUM(NVL(citsn.pell_coa_amount,-1)) pell_coa,
519: SUM(NVL(citsn.alt_pell_amount,-1)) pell_alt_expense
520: FROM igf_aw_coa_items citsn
521: WHERE citsn.base_id = p_base_id ;
522:
523: tot_coa_null_rec cur_tot_coa_null%ROWTYPE;
524:

Line 529: FROM igf_aw_coa_items citsn

525: CURSOR cur_tot_coa_cnt (p_base_id igf_ap_fa_base_rec.base_id%TYPE)
526: IS
527: SELECT
528: COUNT(base_id) rec_cnt
529: FROM igf_aw_coa_items citsn
530: WHERE citsn.base_id = p_base_id ;
531:
532: tot_coa_cnt_rec cur_tot_coa_cnt%ROWTYPE;
533: