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_CUSTOMERS_CONTACTS_UTILS dependencies on PA_PROJECT_TYPES

Line 925: FROM pa_project_types

921: l_cc_prvdr_flag VARCHAR2(1);
922:
923: CURSOR C1(c_project_id NUMBER) IS
924: SELECT cc_prvdr_flag
925: FROM pa_project_types
926: WHERE project_type =
927: (SELECT project_type
928: FROM pa_projects_all
929: WHERE project_id = c_project_id);

Line 1031: pa_project_types b

1027: FROM
1028: /* Commented for Bug 2499051
1029: pa_projects a,
1030: */
1031: pa_project_types b
1032: WHERE b.project_type_class_code = 'CONTRACT' AND
1033: b.project_type =
1034: (SELECT project_type
1035: FROM pa_projects_all

Line 1131: FROM pa_project_types pt

1127:
1128: -- Start of addition for bug 5554475
1129: select pt.cc_prvdr_flag
1130: into l_cc_prvdr_flag
1131: FROM pa_project_types pt
1132: , pa_projects p
1133: WHERE p.project_type = pt.project_type
1134: AND p.project_id = p_project_id
1135: AND p.org_id = pt.org_id;