DBA Data[Home] [Help]

APPS.ARP_TRX_VALIDATE dependencies on AR_RECEIPT_METHODS

Line 1320: FROM ar_receipt_methods arm,

1316: | in the payment method validation. |
1317: +--------------------------------------------------------------------*/
1318: CURSOR receipt_creation_method_cur IS
1319: SELECT arc.creation_method_code
1320: FROM ar_receipt_methods arm,
1321: ar_receipt_classes arc
1322: WHERE arm.receipt_class_id = arc.receipt_class_id
1323: AND arm.receipt_method_id = p_receipt_method_id;
1324:

Line 1924: FROM ar_receipt_methods arm,

1920: Only validate the receipt method*/
1921:
1922: SELECT 'invalid_payment method'
1923: INTO l_temp
1924: FROM ar_receipt_methods arm,
1925: ar_receipt_classes arc
1926: WHERE arm.receipt_class_id = arc.receipt_class_id
1927: AND arm.receipt_method_id = p_receipt_method_id
1928: AND p_trx_date BETWEEN NVL(arm.start_date,

Line 1994: FROM ar_receipt_methods arm,

1990: both validations in sync.*/
1991:
1992: SELECT 'invalid_payment method'
1993: INTO l_temp
1994: FROM ar_receipt_methods arm,
1995: ar_receipt_method_accounts arma,
1996: ce_bank_accounts cba,
1997: ce_bank_acct_uses aba,
1998: ar_receipt_classes arc,