APPS.AR_RECEIPT_LIB_PVT dependencies on AR_OPEN_TRX_V

Line 3473: -- instead of accessing the view ar_open_trx_v. This is because

3469: --called from the BR Remittance program
3470:
3471: -- To handle the case where the apply routine is called from the
3472: -- BR Remittance program, we refer to the underlying tables directly
3473: -- instead of accessing the view ar_open_trx_v. This is because
3474: -- as per the view definition of ar_open_trx_v it will not return the
3475: -- 'reserved'(having reserved_type and reserved_value not null)
3476: -- transactions(Bill).
3477:

Line 3474: -- as per the view definition of ar_open_trx_v it will not return the

3470:
3471: -- To handle the case where the apply routine is called from the
3472: -- BR Remittance program, we refer to the underlying tables directly
3473: -- instead of accessing the view ar_open_trx_v. This is because
3474: -- as per the view definition of ar_open_trx_v it will not return the
3475: -- 'reserved'(having reserved_type and reserved_value not null)
3476: -- transactions(Bill).
3477:
3478: IF arp_global.sysparam.pay_unrelated_invoices_flag = 'Y' THEN

Line 3761: ar_open_trx_v ot

3757: p_rec_charges_charged,
3758: p_rec_charges_remaining,
3759: l_location
3760: FROM
3761: ar_open_trx_v ot
3762: WHERE
3763: ot.customer_trx_id = p_customer_trx_id and
3764: ot.invoice_currency_code =
3765: DECODE(NVL(pg_profile_enable_cc,'N'),

Line 3838: ar_open_trx_v ot

3834: p_rec_charges_charged,
3835: p_rec_charges_remaining,
3836: l_location
3837: FROM
3838: ar_open_trx_v ot
3839: WHERE
3840: ot.customer_trx_id = p_customer_trx_id and
3841: ot.invoice_currency_code =
3842: DECODE(NVL(pg_profile_enable_cc,'N'),