APPS.PA_PPR_CONCURRENT_PROGRAM dependencies on PA_PJI_PROJ_EVENTS_LOG

Line 469: select /*+ index(log PA_PJI_PROJ_EVENTS_LOG_N1) */

465: CREATED_BY,
466: LAST_UPDATE_LOGIN
467:
468: )
469: select /*+ index(log PA_PJI_PROJ_EVENTS_LOG_N1) */
470: l_worker_id ,
471: log.rowid LOG_ROWID,
472: log.EVENT_TYPE,
473: log.EVENT_ID,

Line 504: PA_PJI_PROJ_EVENTS_LOG log ,

500: sysdate CREATION_DATE,
501: -1 CREATED_BY,
502: -1 LAST_UPDATE_LOGIN
503: from
504: PA_PJI_PROJ_EVENTS_LOG log ,
505: PA_RBS_PRJ_ASSIGNMENTS rbs_asg,
506: PA_PROJECTS_ALL prj
507: where
508: log.EVENT_TYPE in ('RBS_PUSH', 'RBS_DELETE') and

Line 515: select /*+ index(log PA_PJI_PROJ_EVENTS_LOG_N1) */

511: rbs_asg.PROJECT_ID = prj.PROJECT_ID and
512: prj.pjt_rollup_enabled_flag = 'Y' and
513: log.pjt_rollup_flag = 'N'
514: UNION ALL
515: select /*+ index(log PA_PJI_PROJ_EVENTS_LOG_N1) */
516: l_worker_id ,
517: log.rowid LOG_ROWID,
518: log.EVENT_TYPE,
519: log.EVENT_ID,

Line 564: update PA_PJI_PROJ_EVENTS_LOG log

560:
561: ppr_log('events02 '|| SQL%rowcount);
562: begin
563:
564: update PA_PJI_PROJ_EVENTS_LOG log
565: set pjt_rollup_flag = 'Y'
566: where log.EVENT_TYPE in ('RBS_PUSH', 'RBS_DELETE')
567: and exists ( select 'x' from
568: PA_RBS_PRJ_ASSIGNMENTS rbs_asg,

Line 603: index(log, PA_PJI_PROJ_EVENTS_LOG_N1)

599: PRJ_CURRENCY_CODE,
600: PROJECT_ACTIVE_FLAG
601: )
602: select /*+ ordered
603: index(log, PA_PJI_PROJ_EVENTS_LOG_N1)
604: index(rbs_asg, PA_RBS_PRJ_ASSIGNMENTS_N1) */
605: distinct
606: l_worker_id,
607: rbs_asg.PROJECT_ID,

Line 1447: select /*+ ordered index(log PA_PJI_PROJ_EVENTS_LOG_N1) use_hash(log) */ --Bug 7516507

1443: p_calling_mode varchar2
1444: ) as
1445:
1446: cursor events (p_worker_id in number) is
1447: select /*+ ordered index(log PA_PJI_PROJ_EVENTS_LOG_N1) use_hash(log) */ --Bug 7516507
1448: distinct
1449: log.ROWID LOG_ROWID,
1450: log.EVENT_TYPE,
1451: log.EVENT_ID,

Line 1480: PA_PJI_PROJ_EVENTS_LOG log,

1476: log.ATTRIBUTE18,
1477: log.ATTRIBUTE19,
1478: log.ATTRIBUTE20
1479: from
1480: PA_PJI_PROJ_EVENTS_LOG log,
1481: PA_RBS_VERSIONS_B ver
1482: where
1483: -- map.WORKER_ID = p_worker_id and
1484: log.EVENT_TYPE in (-- 'WBS_CHANGE', -- disable bulk processing

Line 1494: PA_PJI_PROJ_EVENTS_LOG_N1) use_hash(log) */ --Bug 7516507

1490: log.EVENT_OBJECT = ver.RBS_VERSION_ID (+) and
1491: p_calling_mode = 'INCREMENTAL'
1492: union all
1493: select /*+ ordered index(log
1494: PA_PJI_PROJ_EVENTS_LOG_N1) use_hash(log) */ --Bug 7516507
1495: distinct
1496: log.ROWID LOG_ROWID,
1497: log.EVENT_TYPE,
1498: log.EVENT_ID,

Line 1525: PA_PJI_PROJ_EVENTS_LOG log

1521: log.ATTRIBUTE19,
1522: log.ATTRIBUTE20
1523: from
1524: -- pa_pjt_proj_batch map,
1525: PA_PJI_PROJ_EVENTS_LOG log
1526: where
1527: 1 = 2 AND --- OLAP OPEN ITEM : to support programs with new model. Need to resolve this,
1528: -- map.WORKER_ID = p_worker_id and
1529: log.EVENT_TYPE = 'PRG_CHANGE' and

Line 1536: select /*+ index(log PA_PJI_PROJ_EVENTS_LOG_N1) */

1532:
1533:
1534:
1535: cursor pjt_events_02 is
1536: select /*+ index(log PA_PJI_PROJ_EVENTS_LOG_N1) */
1537: distinct
1538: log.ROWID LOG_ROWID,
1539: log.EVENT_TYPE,
1540: log.EVENT_ID,

Line 1667: from PA_PJI_PROJ_EVENTS_LOG a

1663: -1
1664: );
1665:
1666: delete
1667: from PA_PJI_PROJ_EVENTS_LOG a
1668: where ROWID = c.LOG_ROWID;
1669:
1670: end loop;
1671: