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 838: from pa_project_types_all -- Modified pa_project_types to pa_project_types_all for bug#3512486

834:
835: -- MOAC Changes: Bug 4363092: removed nvl with org_id
836: CURSOR c2 IS
837: select nvl(cc_prvdr_flag, 'N')
838: from pa_project_types_all -- Modified pa_project_types to pa_project_types_all for bug#3512486
839: where project_type = p_project_type
840: and org_id = (select org_id from pa_projects_all where project_id = p_project_id); -- Added the and condition for bug#3512486
841:
842: l_c1_flag VARCHAR2(1);

Line 1427: ,PA_PROJECT_TYPES_ALL PPT

1423: FROM PA_PROJECTS_ALL PPA
1424: ,HR_ORGANIZATION_UNITS HOU
1425: ,PA_WORK_TYPES_TL PWT
1426: ,PA_LOOKUPS PL
1427: ,PA_PROJECT_TYPES_ALL PPT
1428: WHERE PPA.PROJECT_ID = p_project_id
1429: AND PPA.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID
1430: AND PPA.WORK_TYPE_ID = PWT.WORK_TYPE_ID(+)
1431: AND userenv('lang') = PWT.language(+)