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