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_FP_ELEMENTS_PUB dependencies on DUAL

Line 1768: FROM dual

1764: l_resource_exists_flag := 'N';
1765: BEGIN
1766: SELECT 'Y'
1767: INTO l_resource_exists_flag
1768: FROM dual
1769: WHERE exists (select 1
1770: from pa_fp_elements fp
1771: where proj_fp_options_id = l_proj_fp_options_id
1772: and fp.task_id = p_task_id

Line 2118: FROM DUAL

2114: SELECT 0 --task_id
2115: ,l_uncat_rlmid --resource_list_member_id
2116: ,l_track_as_labor_flag
2117: ,l_unit_of_measure /* Modified for bug #2586307. */
2118: FROM DUAL
2119: WHERE NOT EXISTS ( SELECT 'x'
2120: FROM pa_resource_assignments ra
2121: WHERE ra.budget_version_id = p_plan_version_id
2122: AND ra.task_id = 0

Line 6452: from sys.dual

6448:
6449: CURSOR check_options_exists_cur
6450: IS
6451: select 1
6452: from sys.dual
6453: where exists
6454: (select 1 from pa_proj_fp_options
6455: where project_id = p_project_id);
6456:

Line 7058: from sys.dual

7054:
7055: DECLARE
7056: cursor c1 is
7057: select 'N'
7058: from sys.dual
7059: where exists (SELECT null
7060: FROM pa_tasks
7061: where parent_task_id = p_impacted_tasks_tbl(i).old_parent_task_id
7062: and task_id <> p_impacted_tasks_tbl(i).impacted_task_id);