[Home] [Help]
1885: FROM pji_pa_proj_events_log
1886: WHERE event_type = 'RBS_ASSOC' )
1887: OR EXISTS (
1888: SELECT event_type
1889: FROM pa_pji_proj_events_log
1890: WHERE event_type = 'RBS_ASSOC' ) ;
1891:
1892:
1893: EXCEPTION
1911: FROM pji_pa_proj_events_log
1912: WHERE event_type = 'RBS_PRG' )
1913: OR EXISTS (
1914: SELECT event_type
1915: FROM pa_pji_proj_events_log
1916: WHERE event_type = 'RBS_PRG' ) ;
1917:
1918: EXCEPTION
1919:
1964: WHERE event_type = 'RBS_ASSOC' -- Moved the filter conditions to inline view Bug: 12799162
1965: AND worker_id = p_worker_id
1966: UNION ALL
1967: SELECT p_worker_id , EVENT_TYPE , ATTRIBUTE1
1968: FROM PA_PJI_PROJ_EVENTS_LOG
1969: WHERE event_type = 'RBS_ASSOC' -- Moved the filter conditions to inline view Bug: 12799162
1970: )LOG,
1971: PJI_PJP_WBS_HEADER WBS,
1972: PA_RESOURCE_ASSIGNMENTS RA
1990: WHERE event_type = 'RBS_PRG' -- Moved the filter conditions to inline view Bug: 12799162
1991: AND worker_id = p_worker_id
1992: UNION ALL
1993: SELECT p_worker_id , EVENT_TYPE , ATTRIBUTE1
1994: FROM PA_PJI_PROJ_EVENTS_LOG
1995: WHERE event_type = 'RBS_PRG' -- Moved the filter conditions to inline view Bug: 12799162
1996: )LOG,
1997: PJI_XBS_DENORM DEN,
1998: PJI_PJP_WBS_HEADER HD2,