[Home] [Help]
377: , adl.ind_compiled_set_id
378: from ap_invoices I,
379: ap_invoice_distributions D,
380: gms_award_distributions ADL,
381: GL_LEDGERS G
382: where i.invoice_id = d.invoice_id
383: and pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
384: I.invoice_id,
385: nvl(d.base_amount,d.amount),
457: , adl.ind_compiled_set_id
458: from ap_invoices I,
459: ap_invoice_distributions D,
460: gms_award_distributions ADL,
461: GL_LEDGERS G
462: where i.invoice_id = d.invoice_id
463: and pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
464: I.invoice_id,
465: nvl(d.base_amount,d.amount),
515: , adl.ind_compiled_set_id
516: from AP_INVOICES I,
517: AP_SELF_ASSESSED_TAX_DIST apsat,
518: gms_award_distributions ADL,
519: GL_LEDGERS G
520: where i.invoice_id = apsat.invoice_id
521: and pa_cmt_utils.get_apdist_amt(apsat.invoice_distribution_id,
522: I.invoice_id,
523: nvl(apsat.base_amount,apsat.amount),
576: , adl.ind_compiled_set_id
577: from ap_invoices I,
578: ap_invoice_distributions D,
579: gms_award_distributions ADL,
580: gl_ledgers g
581: where i.invoice_id = d.invoice_id
582: and pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
583: I.invoice_id,
584: nvl(d.base_amount,d.amount),
650: , adl.ind_compiled_set_id
651: from ap_invoices I,
652: ap_invoice_distributions D,
653: gms_award_distributions ADL,
654: gl_ledgers g
655: where i.invoice_id = d.invoice_id
656: and pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
657: I.invoice_id,
658: nvl(d.base_amount,d.amount),
703: , adl.ind_compiled_set_id
704: from AP_INVOICES I,
705: AP_SELF_ASSESSED_TAX_DIST_ALL apsat,
706: gms_award_distributions ADL,
707: gl_ledgers g
708: where i.invoice_id = apsat.invoice_id
709: and pa_cmt_utils.get_apdist_amt(apsat.invoice_distribution_id,
710: I.invoice_id,
711: nvl(apsat.base_amount,apsat.amount),
2761: adl.bud_task_id,
2762: adl.ind_compiled_set_id
2763: FROM ap_invoice_distributions APD,
2764: gms_award_distributions ADL,
2765: gl_ledgers G
2766: where adl.invoice_distribution_id = APD.invoice_distribution_id
2767: and adl.adl_status = 'A'
2768: and adl.award_id = P_record.award_id
2769: and nvl(adl.burdenable_raw_cost,0) <> 0
2794: adl.bud_task_id,
2795: ADL.IND_COMPILED_SET_ID
2796: FROM AP_SELF_ASSESSED_TAX_DIST APSAT,
2797: gms_award_distributions ADL,
2798: GL_LEDGERS G
2799: where adl.invoice_distribution_id = APSAT.invoice_distribution_id
2800: and adl.adl_status = 'A'
2801: and adl.award_id = P_record.award_id
2802: and NVL(ADL.BURDENABLE_RAW_COST,0) <> 0
3019: sum(nvl(adl.burdenable_raw_cost,0)) sum_burden,
3020: count(*) sum_count
3021: FROM ap_invoice_distributions AP,
3022: gms_award_distributions ADL,
3023: gl_ledgers G
3024: where adl.invoice_distribution_id = AP.invoice_distribution_id
3025: and adl.adl_status = 'A'
3026: and adl.award_id = bc_pkt_rec.award_id
3027: and ap.expenditure_type = bc_pkt_rec.expenditure_type
3045: sum(nvl(adl.burdenable_raw_cost,0)) sum_burden,
3046: COUNT(*) SUM_COUNT
3047: FROM AP_SELF_ASSESSED_TAX_DIST APSAT,
3048: gms_award_distributions ADL,
3049: gl_ledgers G
3050: where adl.invoice_distribution_id = APSAT.invoice_distribution_id
3051: and adl.adl_status = 'A'
3052: and adl.award_id = bc_pkt_rec.award_id
3053: and APSAT.expenditure_type = bc_pkt_rec.expenditure_type
3669: 'N',
3670: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) ) sum_amount
3671: FROM ap_invoice_distributions AP,
3672: gms_award_distributions ADL,
3673: GL_LEDGERS G
3674: where adl.invoice_distribution_id = AP.invoice_distribution_id
3675: and adl.adl_status = 'A'
3676: and adl.award_id = p_award_id
3677: and ap.expenditure_type = p_expenditure_type