DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_RECORDING_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 1299: FROM AR_RECEIVABLE_APPLICATIONS_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
1299: FROM AR_RECEIVABLE_APPLICATIONS_ALL
1300: WHERE RECEIVABLE_APPLICATION_ID = p_source_document_id;
1301:
1302: CURSOR get_ar_trx_num(c_customer_trx_id NUMBER) IS
1303: SELECT trx_number

Line 1385: ELSIF p_source_table_name = 'AR_RECEIVABLE_APPLICATIONS_ALL' THEN

1381: FETCH get_receipt_num INTO lv_invoice_num;
1382: CLOSE get_receipt_num;*/
1383: lv_invoice_num := p_attribute1;
1384: lv_invoice_num_str := 'Receipt Number: '||lv_invoice_num;
1385: ELSIF p_source_table_name = 'AR_RECEIVABLE_APPLICATIONS_ALL' THEN
1386: /* OPEN get_ar_receipt_id;
1387: FETCH get_ar_receipt_id INTO ln_cash_receipt_id,ln_customer_trx_id;
1388: CLOSE get_ar_receipt_id;*/
1389: