APPS.JAI_CMN_RGM_RECORDING_PKG dependencies on AP_INVOICES_ALL

Line 431: FROM ap_invoices_all apa

427:
428: /*Added for POT for CM/DM issue begin*/
429: CURSOR cur_invoice_type(cp_invoice_distribution_id NUMBER) IS
430: SELECT apa.invoice_type_lookup_code
431: FROM ap_invoices_all apa
432: , ap_invoice_distributions_all ada
433: WHERE apa.invoice_id = ada.invoice_id
434: AND ada.invoice_distribution_id = cp_invoice_distribution_id;
435:

Line 440: FROM ap_invoices_all apa

436: --Added by Qiong for bug#13456083 begin
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: ------------------------------------------------

Line 447: lv_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;

443: AND ada.invoice_payment_id = cp_invoice_payment_id;
444: ------------------------------------------------
445: --Added by Qiong for bug#13456083 end
446:
447: lv_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;
448: /*Added for POT for CM/DM issue end*/
449: --Added by Wenqiong for Bug 14253668 begin
450: ----------------------------------------------
451: CURSOR check_trx_type (cp_customer_trx_line_id NUMBER)IS

Line 1170: FROM ap_invoices_all aia

1166: PRAGMA AUTONOMOUS_TRANSACTION;
1167: CURSOR get_inv_num_std IS
1168: SELECT aia.invoice_num
1169: , aia.invoice_type_lookup_code
1170: FROM ap_invoices_all aia
1171: , ap_invoice_distributions_all aida
1172: WHERE aia.invoice_id = aida.invoice_id
1173: AND aida.invoice_distribution_id = pn_invoice_distribution_id;
1174: BEGIN

Line 1280: FROM ap_invoices_all aia

1276:
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:

Line 1285: lv_invoice_num ap_invoices_all.invoice_num%TYPE;

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;
1286: lv_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;
1287: lv_invoice_num_str VARCHAR2(300);
1288:
1289: --Add by Xiao for bug#12598609, end

Line 1286: lv_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;

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;
1286: lv_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;
1287: lv_invoice_num_str VARCHAR2(300);
1288:
1289: --Add by Xiao for bug#12598609, end
1290: