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_TASKS_MAINT_UTILS dependencies on PA_PROJECT_TYPES_ALL

Line 787: from pa_project_types_all -- Modified pa_project_types to pa_project_types_all for bug#3512486

783:
784: -- MOAC Changes: Bug 4363092: removed nvl with org_id
785: CURSOR c2 IS
786: select nvl(cc_prvdr_flag, 'N')
787: from pa_project_types_all -- Modified pa_project_types to pa_project_types_all for bug#3512486
788: where project_type = p_project_type
789: and org_id = (select org_id from pa_projects_all where project_id = p_project_id); -- Added the and condition for bug#3512486
790:
791: l_c1_flag VARCHAR2(1);

Line 1376: ,PA_PROJECT_TYPES_ALL PPT

1372: FROM PA_PROJECTS_ALL PPA
1373: ,HR_ORGANIZATION_UNITS HOU
1374: ,PA_WORK_TYPES_TL PWT
1375: ,PA_LOOKUPS PL
1376: ,PA_PROJECT_TYPES_ALL PPT
1377: WHERE PPA.PROJECT_ID = p_project_id
1378: AND PPA.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID
1379: AND PPA.WORK_TYPE_ID = PWT.WORK_TYPE_ID(+)
1380: AND userenv('lang') = PWT.language(+)