DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_RECORDING_PKG dependencies on AR_CASH_RECEIPTS_ALL

Line 1294: FROM AR_CASH_RECEIPTS_ALL

1290:
1291: --Added by Wenqiong begin
1292: CURSOR get_receipt_num (c_cash_receipt_id NUMBER)IS
1293: SELECT receipt_number
1294: FROM AR_CASH_RECEIPTS_ALL
1295: WHERE cash_receipt_id = c_cash_receipt_id;
1296:
1297: CURSOR get_ar_receipt_id IS
1298: SELECT cash_receipt_id, APPLIED_CUSTOMER_TRX_ID

Line 1379: ELSIF p_source_table_name = 'AR_CASH_RECEIPTS_ALL' THEN

1375: FETCH get_inv_num_pay INTO lv_invoice_num, lv_invoice_type;
1376: CLOSE get_inv_num_pay;
1377: --Added by Wenqiong
1378:
1379: ELSIF p_source_table_name = 'AR_CASH_RECEIPTS_ALL' THEN
1380: /*OPEN get_receipt_num(p_source_document_id);
1381: FETCH get_receipt_num INTO lv_invoice_num;
1382: CLOSE get_receipt_num;*/
1383: lv_invoice_num := p_attribute1;