APPS.CSE_AP_PA_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 120: FROM ap_invoice_distributions_all aida

116: FROM dual
117: UNION ALL
118: SELECT 'CSE_IPV_ADJUSTMENT' txn_source , distribution_line_number
119: sys_reference3
120: FROM ap_invoice_distributions_all aida
121: WHERE po_distribution_id = p_po_distribution_id
122: and aida.invoice_id = cdl.system_reference2)
123: AND nvl(ei.net_zero_adjustment_flag, 'N') = 'N'
124: UNION ALL

Line 144: FROM ap_invoice_distributions_all aida

140: FROM dual
141: UNION ALL
142: SELECT 'CSE_IPV_ADJUSTMENT' txn_source , distribution_line_number
143: sys_reference3
144: FROM ap_invoice_distributions_all aida
145: WHERE po_distribution_id = p_po_distribution_id
146: and aida.invoice_id = ti.cdl_system_reference2)
147: ORDER BY instance_id, transaction_source desc;
148:

Line 429: ap_invoice_distributions_all aida,

425: aila.quantity_invoiced,
426: aida.unit_price,
427: aida.price_var_code_combination_id inv_dist_ccid
428: FROM po_distributions_all pda,
429: ap_invoice_distributions_all aida,
430: ap_invoice_lines_all aila,
431: ap_invoices_all aia
432: WHERE EXISTS (
433: SELECT '1' FROM csi_transactions ct

Line 482: FROM ap_invoice_distributions_all aida,

478: aia.invoice_type_lookup_code invoice_type,
479: nvl(aida.amount,0) base_amount,
480: aida.accounting_date,
481: aida.dist_code_combination_id inv_dist_ccid
482: FROM ap_invoice_distributions_all aida,
483: ap_invoices_all aia
484: WHERE aida.invoice_id = p_invoice_id
485: AND aida.project_id = p_project_id
486: AND aida.task_id = p_task_id

Line 701: debug('updating ap_invoice_distributions_all.pa_addition_flag = Y ');

697: END IF;
698:
699: END IF;
700:
701: debug('updating ap_invoice_distributions_all.pa_addition_flag = Y ');
702:
703: UPDATE ap_invoice_distributions_all
704: SET pa_addition_flag = 'Y',
705: last_update_date = sysdate,

Line 703: UPDATE ap_invoice_distributions_all

699: END IF;
700:
701: debug('updating ap_invoice_distributions_all.pa_addition_flag = Y ');
702:
703: UPDATE ap_invoice_distributions_all
704: SET pa_addition_flag = 'Y',
705: last_update_date = sysdate,
706: last_updated_by = fnd_global.user_id,
707: last_update_login = fnd_global.login_id,

Line 716: --debug('updating ap_invoice_distributions_all.pa_addition_flag = Y ');

712: FOR l_ind IN l_ap_ft_tbl.FIRST .. l_ap_ft_tbl.LAST
713: LOOP
714:
715: null;
716: --debug('updating ap_invoice_distributions_all.pa_addition_flag = Y ');
717: END LOOP;
718: END IF;
719:
720: END LOOP;