APPS.PA_RBS_MAPPING dependencies on PJI_PA_PROJ_EVENTS_LOG

Line 1885: FROM pji_pa_proj_events_log

1881: FROM dual
1882: WHERE
1883: EXISTS (
1884: SELECT event_type
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

Line 1911: FROM pji_pa_proj_events_log

1907: FROM dual
1908: WHERE
1909: EXISTS (
1910: SELECT event_type
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

Line 1963: FROM PJI_PA_PROJ_EVENTS_LOG

1959: DISTINCT RA.PROJECT_ID, RA.TXN_ACCUM_HEADER_ID
1960: FROM gmap MAP, /* changed the order */
1961: (
1962: SELECT WORKER_ID , EVENT_TYPE , ATTRIBUTE1
1963: FROM PJI_PA_PROJ_EVENTS_LOG
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

Line 1989: FROM PJI_PA_PROJ_EVENTS_LOG

1985: DISTINCT RA.PROJECT_ID, RA.TXN_ACCUM_HEADER_ID
1986: FROM gmap MAP,
1987: (
1988: SELECT WORKER_ID , EVENT_TYPE , ATTRIBUTE1
1989: FROM PJI_PA_PROJ_EVENTS_LOG
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

Line 2064: FROM pji_pa_proj_events_log LOG

2060: , struct_version_id)
2061: SELECT DISTINCT
2062: ra.txn_accum_header_id
2063: , rbv2.rbs_version_id
2064: FROM pji_pa_proj_events_log LOG
2065: , pa_rbs_prj_assignments asg
2066: , pa_rbs_versions_b rbv1
2067: , pa_rbs_versions_b rbv2
2068: , pa_budget_versions bv

Line 2200: insert into pji_pa_proj_events_log (

2196:
2197: IF g_denorm_refresh = 'Y' THEN
2198: --Bug: 3952330
2199: --Log event to populate RBS denorm again for this RBS version
2200: insert into pji_pa_proj_events_log (
2201: EVENT_OBJECT,
2202: EVENT_TYPE,
2203: WORKER_ID
2204: )