DBA Data[Home] [Help]

APPS.AR_PREPAYMENTS dependencies on AR_CASH_RECEIPTS_ALL

Line 1239: from ar_cash_receipts_all cr, ar_receivable_applications ra

1235: /*--------------------------------------
1236: Check if payment set id is valid
1237: ---------------------------------------*/
1238: select count(*) into l_dummy
1239: from ar_cash_receipts_all cr, ar_receivable_applications ra
1240: where ra.payment_set_id= l_payment_set_id
1241: AND cr.cash_receipt_id = ra.cash_receipt_id;
1242:
1243: if l_dummy = 0 then

Line 1266: from ar_cash_receipts_all cr, ar_receivable_applications ra

1262: /*--------------------------------------
1263: Check if t_bank_account_id is valid
1264: ---------------------------------------*/
1265: select count(*) into l_dummy
1266: from ar_cash_receipts_all cr, ar_receivable_applications ra
1267: where ra.payment_set_id= l_payment_set_id
1268: AND cr.cash_receipt_id = ra.cash_receipt_id
1269: and cr.customer_bank_account_id = t_bank_account_id;
1270:

Line 1295: from ar_cash_receipts_all cr, ar_receivable_applications ra

1291: /*--------------------------------------
1292: Check if t_receipt_method_id is valid
1293: ---------------------------------------*/
1294: select count(*) into l_dummy
1295: from ar_cash_receipts_all cr, ar_receivable_applications ra
1296: where ra.payment_set_id= l_payment_set_id
1297: AND cr.cash_receipt_id = ra.cash_receipt_id
1298: and cr.receipt_method_id = t_receipt_method_id;
1299: