[Home] [Help]
1868: FROM pji_pa_proj_events_log
1869: WHERE event_type = 'RBS_ASSOC' )
1870: OR EXISTS (
1871: SELECT event_type
1872: FROM pa_pji_proj_events_log
1873: WHERE event_type = 'RBS_ASSOC' ) ;
1874:
1875:
1876: EXCEPTION
1894: FROM pji_pa_proj_events_log
1895: WHERE event_type = 'RBS_PRG' )
1896: OR EXISTS (
1897: SELECT event_type
1898: FROM pa_pji_proj_events_log
1899: WHERE event_type = 'RBS_PRG' ) ;
1900:
1901: EXCEPTION
1902:
1968: UNION ALL
1969: SELECT p_worker_id
1970: , event_type
1971: , attribute1
1972: FROM pa_pji_proj_events_log
1973: )LOG
1974: WHERE
1975: l_rbs_assoc_flag = 'Y' and --AECOM Change bug 6739719
1976: map.worker_id = p_worker_id and
1998: UNION ALL
1999: SELECT p_worker_id
2000: , event_type
2001: , attribute1
2002: FROM pa_pji_proj_events_log
2003: )LOG,
2004: pji_xbs_denorm den
2005: WHERE
2006: l_rbs_prg_flag = 'Y' and --AECOM Change bug 6739719