APPS.PA_PPR_CONCURRENT_PROGRAM dependencies on PA_RBS_VERSIONS_B

Line 669: from PA_RBS_PRJ_ASSIGNMENTS ASSIGN, pa_rbs_versions_b rbsv, pa_pjt_events log

665: and b1.worker_id = c_worker_id ;
666:
667: cursor c_rbs ( p_project_id number ) is
668: select distinct assign.rbs_version_id , nvl(log.event_type,'AAA') event_type
669: from PA_RBS_PRJ_ASSIGNMENTS ASSIGN, pa_rbs_versions_b rbsv, pa_pjt_events log
670: where ASSIGN.project_id = p_project_id
671: and ASSIGN.reporting_usage_flag = 'Y'
672: AND ASSIGN.rbs_version_id = rbsv.rbs_version_id
673: AND rbsv.current_reporting_flag = 'Y'

Line 680: from PA_RBS_PRJ_ASSIGNMENTS prj, pa_pjt_events log, pa_rbs_versions_b rbsv

676: AND log.event_object (+) = assign.rbs_version_id;
677: /*
678: union all
679: select prj.rbs_version_id , log.event_type event_type
680: from PA_RBS_PRJ_ASSIGNMENTS prj, pa_pjt_events log, pa_rbs_versions_b rbsv
681: where prj.project_id = p_project_id
682: and log.event_type = 'RBS_ASSOC'
683: and log.attribute1 = prj.project_id
684: and reporting_usage_flag = 'Y'

Line 1481: PA_RBS_VERSIONS_B ver

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
1485: -- 'WBS_PUBLISH', -- of WBS events