[Home] [Help]
3195: asg.RBS_HEADER_ID,
3196: asg.RBS_VERSION_ID
3197: from
3198: PJI_PJP_PROJ_BATCH_MAP map,
3199: PA_RBS_PRJ_ASSIGNMENTS asg
3200: where
3201: map.WORKER_ID = p_worker_id and
3202: asg.PROJECT_ID = map.PROJECT_ID and
3203: asg.RBS_HEADER_ID = nvl(p_rbs_header_id,
3255: log.ATTRIBUTE19,
3256: log.ATTRIBUTE20
3257: from
3258: PJI_PJP_PROJ_BATCH_MAP map,
3259: PA_RBS_PRJ_ASSIGNMENTS asg,
3260: PA_PJI_PROJ_EVENTS_LOG log
3261: where
3262: map.WORKER_ID = p_worker_id and
3263: asg.PROJECT_ID = map.PROJECT_ID and
3792: where c.pjt_rollup_flag = 'N'
3793: and exists
3794: ( select 'x' from
3795: pa_projects_all p1,
3796: PA_RBS_PRJ_ASSIGNMENTS asg
3797: where
3798: asg.PROJECT_ID = p1.PROJECT_ID and
3799: asg.RBS_VERSION_ID = c.ATTRIBUTE2 and
3800: p1.pjt_rollup_enabled_flag = 'Y'
4163: rbs_prj.PROJECT_ID ATTRIBUTE19,
4164: log.ATTRIBUTE20
4165: from
4166: PJI_PA_PROJ_EVENTS_LOG log,
4167: PA_RBS_PRJ_ASSIGNMENTS rbs_prj,
4168: PA_RBS_VERSIONS_B rbs
4169: where
4170: log.WORKER_ID = p_worker_id and
4171: log.EVENT_TYPE = 'RBS_PUSH' and
4339: select
4340: distinct asg.RBS_VERSION_ID -- bug 6892644
4341: from
4342: PJI_PJP_PROJ_BATCH_MAP map,
4343: PA_RBS_PRJ_ASSIGNMENTS asg
4344: where
4345: map.WORKER_ID = p_worker_id and
4346: asg.PROJECT_ID = map.PROJECT_ID and
4347: asg.REPORTING_USAGE_FLAG = 'Y';
5043: 'Y' REPORTING_USAGE_FLAG,
5044: 'N' FP_USAGE_FLAG
5045: from
5046: PJI_PJP_PROJ_BATCH_MAP map,
5047: PA_RBS_PRJ_ASSIGNMENTS asg,
5048: PA_XBS_DENORM den1,
5049: PA_XBS_DENORM den2
5050: where
5051: map.WORKER_ID = p_worker_id and
5278: l_last_update_login,
5279: 'A'
5280: from
5281: PJI_PJP_PROJ_BATCH_MAP map,
5282: PA_RBS_PRJ_ASSIGNMENTS asg,
5283: PJI_PJP_RBS_HEADER rbs_hdr
5284: where
5285: map.WORKER_ID = p_worker_id and
5286: asg.PROJECT_ID = map.PROJECT_ID and