[Home] [Help]
413: NULL,
414: prj.PROJECT_CURRENCY_CODE,
415: 'Y' PROJECT_ACTIVE_FLAG
416: from
417: PA_PROJECTS_ALL prj
418: where
419: prj.ORG_ID = nvl(p_operating_unit, prj.ORG_ID ) and
420: prj.SEGMENT1 between nvl(p_from_project, prj.SEGMENT1) and
421: nvl(p_to_project, prj.SEGMENT1) AND
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
510: rbs_asg.RBS_HEADER_ID = p_rbs_header_id and
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
556: rbs_asg.RBS_HEADER_ID = p_rbs_header_id and
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
573: rbs_asg.PROJECT_ID = prj.PROJECT_ID and
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
627: rbs_asg.RBS_VERSION_ID in (log.EVENT_OBJECT, log.ATTRIBUTE2) and
1072: update pa_pjt_proj_batch
1073: set PJI_PROJECT_STATUS = 'Y'
1074: where WORKER_ID = p_worker_id and
1075: PROJECT_ID in (select PROJECT_ID
1076: from PA_PROJECTS_ALL
1077: where STRUCTURE_SHARING_CODE = 'SHARE_FULL');
1078:
1079:
1080: IF ( p_calling_mode='INCREMENTAL' ) THEN