APPS.PA_PPR_CONCURRENT_PROGRAM dependencies on PA_RBS_PRJ_ASSIGNMENTS

Line 505: PA_RBS_PRJ_ASSIGNMENTS rbs_asg,

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
509: rbs_asg.RBS_VERSION_ID in (log.EVENT_OBJECT, log.ATTRIBUTE2) and

Line 551: PA_RBS_PRJ_ASSIGNMENTS rbs_asg,

547: -1 CREATED_BY,
548: -1 LAST_UPDATE_LOGIN
549: from
550: pa_pjt_events_02 log ,
551: PA_RBS_PRJ_ASSIGNMENTS rbs_asg,
552: PA_PROJECTS_ALL prj
553: where
554: log.EVENT_TYPE in ('RBS_PUSH', 'RBS_DELETE') and
555: rbs_asg.RBS_VERSION_ID in (log.EVENT_OBJECT, log.ATTRIBUTE2) and

Line 568: PA_RBS_PRJ_ASSIGNMENTS rbs_asg,

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,
569: PA_PROJECTS_ALL prj
570: where
571: rbs_asg.RBS_VERSION_ID in (log.EVENT_OBJECT, log.ATTRIBUTE2) and
572: rbs_asg.RBS_HEADER_ID = p_rbs_header_id and

Line 604: index(rbs_asg, PA_RBS_PRJ_ASSIGNMENTS_N1) */

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,
608: null PJI_PROJECT_STATUS,

Line 622: PA_RBS_PRJ_ASSIGNMENTS rbs_asg,

618: prj.PROJECT_CURRENCY_CODE,
619: 'Y' PROJECT_ACTIVE_FLAG
620: from
621: pa_pjt_events_02 log,
622: PA_RBS_PRJ_ASSIGNMENTS rbs_asg,
623: PA_PROJECTS_ALL prj,
624: PA_PROJECT_TYPES_ALL pt
625: where
626: log.EVENT_TYPE in ('RBS_PUSH', 'RBS_DELETE') and

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 1246: PA_RBS_PRJ_ASSIGNMENTS asg

1242: distinct
1243: asg.RBS_VERSION_ID
1244: from
1245: pa_pjt_proj_batch map,
1246: PA_RBS_PRJ_ASSIGNMENTS asg
1247: where
1248: map.WORKER_ID = p_worker_id and
1249: asg.PROJECT_ID = map.PROJECT_ID and
1250: asg.REPORTING_USAGE_FLAG = 'Y'

Line 1574: PA_RBS_PRJ_ASSIGNMENTS asg

1570: asg.RBS_HEADER_ID,
1571: asg.RBS_VERSION_ID
1572: from
1573: -- pa_pjt_proj_batch map,
1574: PA_RBS_PRJ_ASSIGNMENTS asg
1575: where
1576: -- map.WORKER_ID = p_worker_id and
1577: asg.PROJECT_ID = p_project_id
1578: ) ver