APPS.PA_PROJECT_STRUCTURE_UTILS dependencies on DUAL

Line 2432: from dual

2428: */
2429:
2430: CURSOR c1 is
2431: select 1
2432: from dual
2433: where exists
2434: ( select 1
2435: from pa_tasks a,
2436: pa_percent_completes b

Line 3326: FROM dual

3322: -- Begin Bug # 4611527.
3323: CURSOR cur_del_lnk_event
3324: IS
3325: SELECT 1
3326: FROM dual
3327: WHERE EXISTS (SELECT LOG.event_id
3328: FROM pji_pa_proj_events_log LOG,
3329: pa_proj_element_versions ver
3330: WHERE LOG.event_type='PRG_CHANGE'

Line 4995: SELECT 1 FROM DUAL WHERE EXISTS (

4991:
4992: -- Checks whether the published workplan structure version is part of a program
4993:
4994: CURSOR link_exists_cur IS
4995: SELECT 1 FROM DUAL WHERE EXISTS (
4996: SELECT por.object_relationship_id
4997: FROM pa_object_relationships por,
4998: pa_proj_element_versions ppev
4999: WHERE por.object_id_from1 = ppev.element_version_id

Line 5089: from dual

5085: return VARCHAR2
5086: IS
5087: CURSOR c1 IS
5088: select 1
5089: from dual
5090: where exists (select log.event_id
5091: from pji_pa_proj_events_log log,pa_proj_element_versions ver
5092: where log.event_type='PRG_CHANGE'
5093: and log.event_object =to_char(ver.prg_group)