DBA Data[Home] [Help]

APPS.ARP_TRX_VALIDATE dependencies on AR_RECEIPT_CLASSES

Line 1324: ar_receipt_classes arc

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

Line 1928: ar_receipt_classes arc

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

Line 2001: ar_receipt_classes arc,

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