eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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'

Line 1601: pa_project_types ptype

1597:
1598: CURSOR get_intercompany_flag_csr IS
1599: SELECT NVL(ptype.cc_prvdr_flag, 'N')
1600: FROM pa_projects proj,
1601: pa_project_types ptype
1602: WHERE proj.PROJECT_ID = p_project_id
1603: AND proj.PROJECT_TYPE = ptype.PROJECT_TYPE;
1604:
1605: CURSOR get_centralized_flag_csr IS