DBA Data[Home] [Help]

APPS.PA_INVOICE_ACTIONS dependencies on PA_PROJECT_CUSTOMERS

Line 450: pa_project_customers PROJCUST,

446: 'Y', 'INTERNAL-INVOICE',
447: 'EXTERNAL-INVOICE'))
448: INTO l_customer_id,l_bill_ship_to_customer_id, l_bill_to, l_ship_to, l_invoice_category
449: FROM pa_draft_invoices INV, pa_agreements_all AGREE, /* fix bug 2082864 for MCB2 */
450: pa_project_customers PROJCUST,
451: pa_projects PROJ,
452: pa_project_types PROJTYPE
453: WHERE INV.project_id = P_Project_id
454: AND INV.draft_invoice_num = P_Draft_Invoice_Num

Line 676: pa_project_customers PROJCUST

672: FROM pa_draft_invoices i,
673: pa_projects p,
674: pa_project_types pt,
675: pa_agreements_all AGREE, /* fix bug 2082864 for MCB2 */
676: pa_project_customers PROJCUST
677: WHERE i.ra_invoice_number = l_RA_Invoice_Num
678: AND NOT EXISTS ( SELECT 'x'
679: FROM pa_draft_invoices x
680: WHERE x.project_id = P_Project_ID