APPS.AP_PREPAY_PKG dependencies on AP_INVOICES_PKG

Line 4455: (ai.invoice_amount - nvl(ap_invoices_pkg.get_amount_withheld(p_invoice_id),0)) - aps.amount_remaining),/*Bug10012482*/

4451:
4452: CURSOR Schedules IS
4453: SELECT aps.payment_num,
4454: DECODE(p_appl_type, 'UNAPPLICATION', ((aps.gross_amount / ai.invoice_amount ) *
4455: (ai.invoice_amount - nvl(ap_invoices_pkg.get_amount_withheld(p_invoice_id),0)) - aps.amount_remaining),/*Bug10012482*/
4456: aps.amount_remaining),
4457: ai.invoice_amount /*Bug10012482*/
4458: FROM ap_payment_schedules aps,
4459: ap_invoices_all ai

Line 4539: nvl(ap_invoices_pkg.get_amount_withheld(p_invoice_id),0))), 'N',

4535: p_payment_currency_code),
4536: 0,'Y',
4537: /*Bug10012482:Taking AWT amounts into account*/
4538: ((gross_amount / l_total_gross_amount) * (l_total_gross_amount -
4539: nvl(ap_invoices_pkg.get_amount_withheld(p_invoice_id),0))), 'N',
4540: 'P'),
4541: last_update_date = SYSDATE,
4542: last_updated_by = p_user_id,
4543: last_update_login = p_last_update_login

Line 4590: nvl(ap_invoices_pkg.get_amount_withheld(p_invoice_id),0))), 'N',

4586: p_payment_currency_code),
4587: 0,'Y',
4588: /*Bug10012482:Taking AWT amounts into account*/
4589: ((gross_amount / l_total_gross_amount) * (l_total_gross_amount -
4590: nvl(ap_invoices_pkg.get_amount_withheld(p_invoice_id),0))), 'N',
4591: 'P'),
4592: last_update_date = SYSDATE,
4593: last_updated_by = p_user_id,
4594: last_update_login = p_last_update_login

Line 4620: nvl(ap_invoices_pkg.get_amount_withheld(p_invoice_id),0)))),

4616: 'APPLICATION',0,
4617: /*Bug10012482:Taking AWT amounts into account*/
4618: ((gross_amount / l_total_gross_amount )
4619: * (l_total_gross_amount -
4620: nvl(ap_invoices_pkg.get_amount_withheld(p_invoice_id),0)))),
4621: payment_status_flag = DECODE(p_appl_type,
4622: 'APPLICATION','Y',
4623: 'N'),
4624: last_update_date = SYSDATE,