DBA Data[Home] [Help]

APPS.PA_INVOICE_ACTIONS dependencies on PA_AGREEMENTS_ALL

Line 449: FROM pa_draft_invoices INV, pa_agreements_all AGREE, /* fix bug 2082864 for MCB2 */

445: decode(nvl(PROJCUST.bill_another_project_flag,'N'),
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

Line 675: pa_agreements_all AGREE, /* fix bug 2082864 for MCB2 */

671: INTO l_dummy
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