APPS.PJI_PJP_SUM_ROLLUP dependencies on PA_RBS_PRJ_ASSIGNMENTS

Line 242: PA_RBS_PRJ_ASSIGNMENTS asg

238: asg.RBS_HEADER_ID,
239: asg.RBS_VERSION_ID
240: from
241: PJI_PJP_PROJ_BATCH_MAP map,
242: PA_RBS_PRJ_ASSIGNMENTS asg
243: where
244: map.WORKER_ID = p_worker_id and
245: asg.PROJECT_ID = map.PROJECT_ID and
246: asg.RBS_HEADER_ID = nvl(p_rbs_header_id,

Line 286: PA_RBS_PRJ_ASSIGNMENTS asg,

282: log.ATTRIBUTE19,
283: log.ATTRIBUTE20
284: from
285: PJI_PJP_PROJ_BATCH_MAP map,
286: PA_RBS_PRJ_ASSIGNMENTS asg,
287: PA_PJI_PROJ_EVENTS_LOG log
288: where
289: map.WORKER_ID = p_worker_id and
290: asg.PROJECT_ID = map.PROJECT_ID and

Line 1088: PA_RBS_PRJ_ASSIGNMENTS rbs_prj,

1084: rbs_prj.PROJECT_ID ATTRIBUTE19,
1085: log.ATTRIBUTE20
1086: from
1087: PJI_PA_PROJ_EVENTS_LOG log,
1088: PA_RBS_PRJ_ASSIGNMENTS rbs_prj,
1089: PA_RBS_VERSIONS_B rbs
1090: where
1091: log.WORKER_ID = p_worker_id and
1092: log.EVENT_TYPE = 'RBS_PUSH' and

Line 1193: PA_RBS_PRJ_ASSIGNMENTS asg

1189: select
1190: asg.RBS_VERSION_ID
1191: from
1192: PJI_PJP_PROJ_BATCH_MAP map,
1193: PA_RBS_PRJ_ASSIGNMENTS asg
1194: where
1195: map.WORKER_ID = p_worker_id and
1196: asg.PROJECT_ID = map.PROJECT_ID and
1197: asg.REPORTING_USAGE_FLAG = 'Y';

Line 1853: PA_RBS_PRJ_ASSIGNMENTS asg,

1849: 'Y' REPORTING_USAGE_FLAG,
1850: 'N' FP_USAGE_FLAG
1851: from
1852: PJI_PJP_PROJ_BATCH_MAP map,
1853: PA_RBS_PRJ_ASSIGNMENTS asg,
1854: PA_XBS_DENORM den1,
1855: PA_XBS_DENORM den2
1856: where
1857: map.WORKER_ID = p_worker_id and

Line 2088: PA_RBS_PRJ_ASSIGNMENTS asg,

2084: l_last_update_login,
2085: 'A'
2086: from
2087: PJI_PJP_PROJ_BATCH_MAP map,
2088: PA_RBS_PRJ_ASSIGNMENTS asg,
2089: PJI_PJP_RBS_HEADER rbs_hdr
2090: where
2091: map.WORKER_ID = p_worker_id and
2092: asg.PROJECT_ID = map.PROJECT_ID and