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 6443: from sys.dual

6439:
6440: CURSOR check_options_exists_cur
6441: IS
6442: select 1
6443: from sys.dual
6444: where exists
6445: (select 1 from pa_proj_fp_options
6446: where project_id = p_project_id);
6447:

Line 7049: from sys.dual

7045:
7046: DECLARE
7047: cursor c1 is
7048: select 'N'
7049: from sys.dual
7050: where exists (SELECT null
7051: FROM pa_tasks
7052: where parent_task_id = p_impacted_tasks_tbl(i).old_parent_task_id
7053: and task_id <> p_impacted_tasks_tbl(i).impacted_task_id);