DBA Data[Home] [Help]

APPS.ARP_TRX_VALIDATE dependencies on AR_RECEIPT_CLASSES

Line 1321: ar_receipt_classes arc

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:
1325: receipt_creation_method_rec receipt_creation_method_cur%ROWTYPE;

Line 1925: ar_receipt_classes arc

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,
1929: p_trx_date)

Line 1998: ar_receipt_classes arc,

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,
1999: ce_bank_branches_v bp
2000: WHERE arm.receipt_method_id = arma.receipt_method_id
2001: AND arm.receipt_class_id = arc.receipt_class_id
2002: AND arma.remit_bank_acct_use_id = aba.bank_acct_use_id