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 390: cursor p1 is select 1 from pa_project_types

386: x_proj_type_class_code varchar2(30);
387: dummy_null varchar2(30) default NULL;
388: l_OTL_timecard_exists boolean; -- Added for bug 3870364
389: /* Commented the cursor for bug#3512486
390: cursor p1 is select 1 from pa_project_types
391: where burden_sum_dest_task_id = x_task_id;*/
392: /* Added the below cursor for bug#3512486*/
393: cursor p1 is select 1 from pa_project_types_all
394: where burden_sum_dest_task_id = x_task_id

Line 393: cursor p1 is select 1 from pa_project_types_all

389: /* Commented the cursor for bug#3512486
390: cursor p1 is select 1 from pa_project_types
391: where burden_sum_dest_task_id = x_task_id;*/
392: /* Added the below cursor for bug#3512486*/
393: cursor p1 is select 1 from pa_project_types_all
394: where burden_sum_dest_task_id = x_task_id
395: and org_id = (SELECT org_id --MOAC Changes: Bug 4363092: removed nvl usage with org_id
396: FROM pa_projects_all
397: where project_id = (select project_id from pa_tasks where task_id=x_task_id));

Line 1611: cursor p1 is select 1 from pa_project_types

1607: l_msg_count NUMBER;
1608: l_msg_data VARCHAR2(4000);
1609: ----Bug 2947492
1610:
1611: cursor p1 is select 1 from pa_project_types
1612: where burden_sum_dest_task_id = x_task_id;
1613: temp number;
1614: --Ansari
1615: x_used_in_OTL BOOLEAN; --To pass to OTL API.