DBA Data[Home] [Help]

APPS.OE_PREPAYMENT_PVT dependencies on AR_RECEIPT_CLASSES

Line 301: ar_receipt_classes rc

297: INTO l_remittance_bank_account_id
298: FROM ar_receipt_methods rm,
299: ap_bank_accounts ba,
300: ar_receipt_method_accounts rma ,
301: ar_receipt_classes rc
302: WHERE rm.receipt_method_id = p_receipt_method_id
303: and rm.receipt_method_id = rma.receipt_method_id
304: and rc.receipt_class_id = rm.receipt_class_id
305: and rc.creation_method_code = 'AUTOMATIC'

Line 2736: ar_receipt_classes rc,

2732: CURSOR AR_RECEIPTS_CUR(p_payment_set_id IN NUMBER) IS
2733: SELECT rc.creation_status creation_status,
2734: nvl(rm.payment_type_code, 'CHECK') payment_type_code
2735: FROM ar_cash_receipts cr,
2736: ar_receipt_classes rc,
2737: ar_receipt_methods rm,
2738: ar_receivable_applications ar
2739: WHERE rm.receipt_class_id = rc.receipt_class_id
2740: AND cr.receipt_method_id = rm.receipt_method_id