DBA Data[Home] [Help]

APPS.GMS_BUDGET_BALANCE dependencies on PA_CMT_UTILS

Line 458: pa_currency.round_currency_amt(decode(sign(pa_cmt_utils.get_apdist_amt( aid.invoice_distribution_id,

454: sysdate,
455: FND_GLOBAL.LOGIN_ID,
456: -- Added below NVL clause as the base_amount stores correct amount in multi currency scenario
457: -- Bug 1980810 PA Rounding function added
458: pa_currency.round_currency_amt(decode(sign(pa_cmt_utils.get_apdist_amt( aid.invoice_distribution_id,
459: aid.invoice_id,
460: nvl(aid.base_amount,aid.amount),
461: 'N', 'GMS', nvl(g.sla_ledger_cash_basis_flag,'N'))),
462: 1, pa_cmt_utils.get_apdist_amt( aid.invoice_distribution_id,

Line 462: 1, pa_cmt_utils.get_apdist_amt( aid.invoice_distribution_id,

458: pa_currency.round_currency_amt(decode(sign(pa_cmt_utils.get_apdist_amt( aid.invoice_distribution_id,
459: aid.invoice_id,
460: nvl(aid.base_amount,aid.amount),
461: 'N', 'GMS', nvl(g.sla_ledger_cash_basis_flag,'N'))),
462: 1, pa_cmt_utils.get_apdist_amt( aid.invoice_distribution_id,
463: aid.invoice_id,
464: nvl(aid.base_amount,aid.amount),
465: 'N', 'GMS', nvl(g.sla_ledger_cash_basis_flag,'N')) ,
466: 0)), -- Bug 2386531

Line 467: pa_currency.round_currency_amt(decode(sign(pa_cmt_utils.get_apdist_amt( aid.invoice_distribution_id,

463: aid.invoice_id,
464: nvl(aid.base_amount,aid.amount),
465: 'N', 'GMS', nvl(g.sla_ledger_cash_basis_flag,'N')) ,
466: 0)), -- Bug 2386531
467: pa_currency.round_currency_amt(decode(sign(pa_cmt_utils.get_apdist_amt( aid.invoice_distribution_id,
468: aid.invoice_id,
469: nvl(aid.base_amount,aid.amount),
470: 'N', 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') )),
471: -1,abs( pa_cmt_utils.get_apdist_amt( aid.invoice_distribution_id,

Line 471: -1,abs( pa_cmt_utils.get_apdist_amt( aid.invoice_distribution_id,

467: pa_currency.round_currency_amt(decode(sign(pa_cmt_utils.get_apdist_amt( aid.invoice_distribution_id,
468: aid.invoice_id,
469: nvl(aid.base_amount,aid.amount),
470: 'N', 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') )),
471: -1,abs( pa_cmt_utils.get_apdist_amt( aid.invoice_distribution_id,
472: aid.invoice_id,
473: nvl(aid.base_amount,aid.amount),
474: 'N', 'GMS', nvl(g.sla_ledger_cash_basis_flag,'N') )),
475: 0)),--Bug 2386531

Line 512: and pa_cmt_utils.get_apdist_amt( aid.invoice_distribution_id,

508: and gps.application_id = 101
509: and gps.set_of_books_id = x_sob_id
510: and adl.project_id = x_project_id
511: and adl.award_id = x_award_id
512: and pa_cmt_utils.get_apdist_amt( aid.invoice_distribution_id,
513: aid.invoice_id,
514: nvl(aid.base_amount,aid.amount),
515: 'N', 'GMS', nvl(g.sla_ledger_cash_basis_flag,'N') ) <> 0
516: and nvl(aid.match_status_flag, 'X') = 'A'