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_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 5032: SELECT 1 FROM DUAL WHERE EXISTS (

5028:
5029: -- Checks whether the published workplan structure version is part of a program
5030:
5031: CURSOR link_exists_cur IS
5032: SELECT 1 FROM DUAL WHERE EXISTS (
5033: SELECT por.object_relationship_id
5034: FROM pa_object_relationships por,
5035: pa_proj_element_versions ppev
5036: WHERE por.object_id_from1 = ppev.element_version_id

Line 5127: from dual

5123: return VARCHAR2
5124: IS
5125: CURSOR c1 IS
5126: select 1
5127: from dual
5128: where exists (select log.event_id
5129: from pji_pa_proj_events_log log,pa_proj_element_versions ver
5130: where log.event_type='PRG_CHANGE'
5131: and log.event_object =to_char(ver.prg_group)

Line 5223: from dual

5219: return VARCHAR2
5220: IS
5221: CURSOR c1 IS
5222: select 1
5223: from dual
5224: where exists (select log.event_id
5225: from pji_pa_proj_events_log log
5226: where log.event_type='PRG_CHANGE'
5227: union all