DBA Data[Home] [Help]

APPS.PA_RBS_MAPPING dependencies on PJI_PA_PROJ_EVENTS_LOG

Line 1868: FROM pji_pa_proj_events_log

1864: FROM dual
1865: WHERE
1866: EXISTS (
1867: SELECT event_type
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

Line 1894: FROM pji_pa_proj_events_log

1890: FROM dual
1891: WHERE
1892: EXISTS (
1893: SELECT event_type
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

Line 1967: FROM pji_pa_proj_events_log

1963: pa_resource_assignments ra ,
1964: ( SELECT worker_id
1965: , event_type
1966: , attribute1
1967: FROM pji_pa_proj_events_log
1968: UNION ALL
1969: SELECT p_worker_id
1970: , event_type
1971: , attribute1

Line 1997: FROM pji_pa_proj_events_log

1993: pa_resource_assignments ra,
1994: ( SELECT worker_id
1995: , event_type
1996: , attribute1
1997: FROM pji_pa_proj_events_log
1998: UNION ALL
1999: SELECT p_worker_id
2000: , event_type
2001: , attribute1

Line 2044: FROM pji_pa_proj_events_log LOG

2040: , struct_version_id)
2041: SELECT DISTINCT
2042: ra.txn_accum_header_id
2043: , rbv2.rbs_version_id
2044: FROM pji_pa_proj_events_log LOG
2045: , pa_rbs_prj_assignments asg
2046: , pa_rbs_versions_b rbv1
2047: , pa_rbs_versions_b rbv2
2048: , pa_budget_versions bv

Line 2171: insert into pji_pa_proj_events_log (

2167:
2168: IF g_denorm_refresh = 'Y' THEN
2169: --Bug: 3952330
2170: --Log event to populate RBS denorm again for this RBS version
2171: insert into pji_pa_proj_events_log (
2172: EVENT_OBJECT,
2173: EVENT_TYPE,
2174: WORKER_ID
2175: )