DBA Data[Home] [Help]

APPS.PA_TASK_PVT1 dependencies on DUAL

Line 269: select 'Y' from dual

265: --HSIU
266: --fixed status code error
267: -- Bug 2827063 Tuned the following cursor to use exists
268: CURSOR cur_pub_versions is
269: select 'Y' from dual
270: where EXISTS
271: ( select 'xyz'
272: from pa_proj_elem_ver_structure
273: where proj_element_id = p_structure_id

Line 1672: select 'Y' from dual

1668: AND pst.structure_type_class_code IN( 'FINANCIAL' );
1669:
1670: -- Bug 2827063 Tuned the following cursor to use exists
1671: CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
1672: select 'Y' from dual
1673: where exists
1674: (select 'xyz'
1675: from pa_proj_elem_ver_structure
1676: where proj_element_id = c_structure_id