APPS.JAI_CMN_RGM_RECORDING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 432: , ap_invoice_distributions_all ada

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

Line 530: if p_source_table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL' then

526: --Added by Wenqiong for Bug 14253668 end
527:
528: /*Added for POT for CM/DM issue begin*/
529: IF p_source = jai_constants.source_ap THEN
530: if p_source_table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL' then
531: OPEN cur_invoice_type(p_source_document_id);
532: FETCH cur_invoice_type INTO lv_invoice_type;
533: CLOSE cur_invoice_type;
534: --Added by Qiong for bug#13456083 begin

Line 1171: , ap_invoice_distributions_all aida

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

Line 1371: IF p_source_table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL' THEN

1367:
1368: -- ended, ssumaith for Bug 6664855
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;