DBA Data[Home] [Help]

APPS.PA_INVOICE_ACTIONS dependencies on PA_PROJECT_TYPES

Line 452: pa_project_types PROJTYPE

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
455: AND AGREE.agreement_id = INV.agreement_id
456: AND PROJCUST.customer_id = AGREE.customer_id

Line 674: pa_project_types pt,

670: SELECT count(*)
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'