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

Line 275: select 'Y' from dual

271: --HSIU
272: --fixed status code error
273: -- Bug 2827063 Tuned the following cursor to use exists
274: CURSOR cur_pub_versions is
275: select 'Y' from dual
276: where EXISTS
277: ( select 'xyz'
278: from pa_proj_elem_ver_structure
279: where proj_element_id = p_structure_id

Line 1786: select 'Y' from dual

1782: AND pst.structure_type_class_code IN( 'FINANCIAL' );
1783:
1784: -- Bug 2827063 Tuned the following cursor to use exists
1785: CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
1786: select 'Y' from dual
1787: where exists
1788: (select 'xyz'
1789: from pa_proj_elem_ver_structure
1790: where proj_element_id = c_structure_id

Line 10907: SELECT -1 * ( PA_PROJ_ELEMENT_VERSIONS_S.nextval ) INTO t_seq FROM dual;

10903: END IF;
10904:
10905: IF p_event_type IN ( 'ADD', 'IDENT','MOVE_SUB' ) THEN
10906: IF ( p_event_type IN ('IDENT','MOVE_SUB' ) ) THEN
10907: SELECT -1 * ( PA_PROJ_ELEMENT_VERSIONS_S.nextval ) INTO t_seq FROM dual;
10908: ELSE
10909: t_seq := -1 * p_elem_ver_id;
10910: END IF;
10911: UPDATE pa_proj_element_versions a