APPS.PA_PURGE_VALIDATE_CAPITAL dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 18: FROM ap_invoice_distributions_all aid

14: CURSOR IsVenInvPending IS
15: SELECT 'VENDOR INVOICE PENDING'
16: FROM dual
17: WHERE EXISTS ( SELECT aid.invoice_id
18: FROM ap_invoice_distributions_all aid
19: WHERE aid.project_id = p_project_id
20: AND (p_active_flag = 'C' or
21: aid.expenditure_item_date < trunc(p_purge_to_date))
22: AND aid.pa_addition_flag <> 'Y');

Line 35: FROM ap_invoice_distributions_all aid,

31: CURSOR IsVenInvPending IS
32: SELECT 'VENDOR INVOICE PENDING'
33: FROM dual
34: WHERE EXISTS ( SELECT aid.invoice_id
35: FROM ap_invoice_distributions_all aid,
36: ap_invoices_all ai
37: WHERE aid.project_id = p_project_id
38: AND aid.invoice_id = ai.invoice_id
39: AND ai.invoice_type_lookup_code <> 'EXPENSE REPORT'

Line 184: FROM ap_invoice_distributions_all aid,

180: AND nvl(pctv1.quantity_cancelled,0) =0
181: UNION /* Added for bug 2553822 */
182: /* Bug 2598071 SELECT aid.invoice_id */
183: SELECT aid.invoice_id
184: FROM ap_invoice_distributions_all aid,
185: ap_invoices_all ai
186: WHERE aid.project_id = p_project_id
187: AND aid.invoice_id = ai.invoice_id
188: AND ai.source <> 'Oracle Project Accounting'