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

Line 576: cursor p1 is select 1 from pa_project_types

572: x_proj_type_class_code varchar2(30);
573: dummy_null varchar2(30) default NULL;
574: l_OTL_timecard_exists boolean; -- Added for bug 3870364
575: /* Commented the cursor for bug#3512486
576: cursor p1 is select 1 from pa_project_types
577: where burden_sum_dest_task_id = x_task_id;*/
578: /* Added the below cursor for bug#3512486*/
579: cursor p1 is select 1 from pa_project_types_all
580: where burden_sum_dest_task_id = x_task_id

Line 579: cursor p1 is select 1 from pa_project_types_all

575: /* Commented the cursor for bug#3512486
576: cursor p1 is select 1 from pa_project_types
577: where burden_sum_dest_task_id = x_task_id;*/
578: /* Added the below cursor for bug#3512486*/
579: cursor p1 is select 1 from pa_project_types_all
580: where burden_sum_dest_task_id = x_task_id
581: and org_id = (SELECT org_id --MOAC Changes: Bug 4363092: removed nvl usage with org_id
582: FROM pa_projects_all
583: where project_id = (select project_id from pa_tasks where task_id=x_task_id));

Line 1823: cursor p1 is select 1 from pa_project_types

1819: l_msg_count NUMBER;
1820: l_msg_data VARCHAR2(4000);
1821: ----Bug 2947492
1822:
1823: cursor p1 is select 1 from pa_project_types
1824: where burden_sum_dest_task_id = x_task_id;
1825: temp number;
1826: --Ansari
1827: x_used_in_OTL BOOLEAN; --To pass to OTL API.