APPS.PA_FUNDS_CONTROL_PKG1 dependencies on AP_INVOICES_ALL

Line 2735: ap_invoices_all apinv

2731: ,'NONREC_TAX',DECODE(apd.prepay_distribution_id,NULL,apd.line_type_lookup_code,'PREPAY')
2732: ,apd.line_type_lookup_code)
2733: FROM ap_invoice_distributions_all apd ,
2734: psa_bc_xla_events_gt xlaevt,
2735: ap_invoices_all apinv
2736: WHERE apd.bc_event_id = xlaevt.event_id
2737: AND apd.project_id IS NOT NULL
2738: AND NVL(apd.pa_addition_flag, 'X' ) <> 'T'
2739: AND apinv.invoice_id = apd.invoice_id

Line 2806: ap_invoices_all apinv

2802: ,'NONREC_TAX',DECODE(apd.prepay_distribution_id,NULL,decode(apd.line_type_lookup_code,'NONREC_TAX','SELF_ASSESSED_TAX',apd.line_type_lookup_code),'PREPAY')
2803: ,decode(apd.line_type_lookup_code,'NONREC_TAX','SELF_ASSESSED_TAX',apd.line_type_lookup_code))
2804: FROM ap_self_assessed_tax_dist_all apd ,
2805: psa_bc_xla_events_gt xlaevt,
2806: ap_invoices_all apinv
2807: WHERE apd.bc_event_id = xlaevt.event_id
2808: AND apd.project_id IS NOT NULL
2809: AND NVL(apd.pa_addition_flag, 'X' ) <> 'T'
2810: AND apinv.invoice_id = apd.invoice_id

Line 3246: ap_invoices_all apinv

3242: apd.expenditure_item_date,
3243: apd.org_id,
3244: apinv.vendor_id
3245: FROM ap_invoice_distributions_all apd,
3246: ap_invoices_all apinv
3247: WHERE apd.invoice_distribution_id = p_inv_dist_id
3248: AND apinv.invoice_id = apd.invoice_id
3249: UNION /*Bug 13602288 :Self Assessed Tax Changes*/
3250: SELECT apd.set_of_books_id,

Line 3255: ap_invoices_all apinv

3251: apd.expenditure_item_date,
3252: apd.org_id,
3253: apinv.vendor_id
3254: FROM ap_self_assessed_tax_dist_all apd,
3255: ap_invoices_all apinv
3256: WHERE apd.invoice_distribution_id = p_inv_dist_id
3257: AND apinv.invoice_id = apd.invoice_id;
3258:
3259: --R12 Funds Management Uptake:Deleted CBC related logic