APPS.JAI_CMN_RGM_RECORDING_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 441: , ap_invoice_payments_all ada

437: ----------------------------------------------
438: CURSOR cur_payment_type(cp_invoice_payment_id NUMBER) IS
439: SELECT apa.invoice_type_lookup_code
440: FROM ap_invoices_all apa
441: , ap_invoice_payments_all ada
442: WHERE apa.invoice_id = ada.invoice_id
443: AND ada.invoice_payment_id = cp_invoice_payment_id;
444: ------------------------------------------------
445: --Added by Qiong for bug#13456083 end

Line 536: elsif p_source_table_name = 'AP_INVOICE_PAYMENTS_ALL' then

532: FETCH cur_invoice_type INTO lv_invoice_type;
533: CLOSE cur_invoice_type;
534: --Added by Qiong for bug#13456083 begin
535: ----------------------------------------------
536: elsif p_source_table_name = 'AP_INVOICE_PAYMENTS_ALL' then
537: OPEN cur_payment_type(p_source_document_id);
538: FETCH cur_payment_type INTO lv_invoice_type;
539: CLOSE cur_payment_type;
540: end if;

Line 1281: , ap_invoice_payments_all aipa

1277: CURSOR get_inv_num_pay IS
1278: SELECT aia.invoice_num
1279: , aia.invoice_type_lookup_code
1280: FROM ap_invoices_all aia
1281: , ap_invoice_payments_all aipa
1282: WHERE aia.invoice_id = aipa.invoice_id
1283: AND aipa.invoice_payment_id = p_source_document_id;
1284:
1285: lv_invoice_num ap_invoices_all.invoice_num%TYPE;

Line 1373: ELSIF p_source_table_name = 'AP_INVOICE_PAYMENTS_ALL' THEN

1369:
1370: --Add by Xiao for bug#12598609, begin
1371: IF p_source_table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL' THEN
1372: get_inv_num_std(lv_invoice_num, lv_invoice_type, p_source_document_id);
1373: ELSIF p_source_table_name = 'AP_INVOICE_PAYMENTS_ALL' THEN
1374: OPEN get_inv_num_pay;
1375: FETCH get_inv_num_pay INTO lv_invoice_num, lv_invoice_type;
1376: CLOSE get_inv_num_pay;
1377: --Added by Wenqiong