APPS.GMS_COST_PLUS_EXTN dependencies on GL_LEDGERS

Line 381: GL_LEDGERS G

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),

Line 442: gl_ledgers g

438: , adl.ind_compiled_set_id
439: from ap_invoices I,
440: ap_invoice_distributions D,
441: gms_award_distributions ADL,
442: gl_ledgers g
443: where i.invoice_id = d.invoice_id
444: and pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
445: I.invoice_id,
446: nvl(d.base_amount,d.amount),

Line 2498: gl_ledgers G

2494: adl.bud_task_id,
2495: adl.ind_compiled_set_id
2496: FROM ap_invoice_distributions APD,
2497: gms_award_distributions ADL,
2498: gl_ledgers G
2499: where adl.invoice_distribution_id = APD.invoice_distribution_id
2500: and adl.adl_status = 'A'
2501: and adl.award_id = P_record.award_id
2502: and nvl(adl.burdenable_raw_cost,0) <> 0

Line 2685: gl_ledgers G

2681: sum(nvl(adl.burdenable_raw_cost,0)) sum_burden,
2682: count(*) sum_count
2683: FROM ap_invoice_distributions AP,
2684: gms_award_distributions ADL,
2685: gl_ledgers G
2686: where adl.invoice_distribution_id = AP.invoice_distribution_id
2687: and adl.adl_status = 'A'
2688: and adl.award_id = bc_pkt_rec.award_id
2689: and ap.expenditure_type = bc_pkt_rec.expenditure_type

Line 3309: GL_LEDGERS G

3305: 'N',
3306: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) ) sum_amount
3307: FROM ap_invoice_distributions AP,
3308: gms_award_distributions ADL,
3309: GL_LEDGERS G
3310: where adl.invoice_distribution_id = AP.invoice_distribution_id
3311: and adl.adl_status = 'A'
3312: and adl.award_id = p_award_id
3313: and ap.expenditure_type = p_expenditure_type