DBA Data[Home] [Help]

APPS.ARP_TRX_VALIDATE dependencies on AR_RECEIPT_METHODS

Line 1323: FROM ar_receipt_methods arm,

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

Line 1927: FROM ar_receipt_methods arm,

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

Line 1997: FROM ar_receipt_methods arm,

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