[Home] [Help]
3208: rbs.RBS_HEADER_ID,
3209: rbs.RBS_VERSION_ID
3210: from
3211: PJI_PJP_PROJ_BATCH_MAP map,
3212: PA_PROJECTS_ALL prj,
3213: PA_RBS_VERSIONS_B rbs,
3214: PA_PJI_PROJ_EVENTS_LOG log
3215: where
3216: map.WORKER_ID = p_worker_id and
3791: dual
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
4234: prj.PROJECT_ID ATTRIBUTE19,
4235: log.ATTRIBUTE20
4236: from
4237: PJI_PA_PROJ_EVENTS_LOG log,
4238: PA_PROJECTS_ALL prj
4239: where
4240: log.WORKER_ID = p_worker_id and
4241: log.EVENT_TYPE = 'RBS_PUSH' and
4242: prj.cbs_version_id = log.ATTRIBUTE2 and
8202: sum(src.G2_AR_AMOUNT_OVERDUE) G2_AR_AMOUNT_OVERDUE
8203: from
8204: PJI_PJP_RMAP_ACR src_r,
8205: PJI_FM_AGGR_ACT4 src,
8206: PA_PROJECTS_ALL prj,
8207: PJI_ORG_EXTR_INFO info
8208: where
8209: src_r.WORKER_ID = p_worker_id and
8210: src.ROWID = src_r.STG_ROWID and
8310: l_last_update_date := sysdate;
8311: l_last_updated_by := FND_GLOBAL.USER_ID;
8312: l_last_update_login := FND_GLOBAL.LOGIN_ID;
8313:
8314: update PA_PROJECTS_ALL
8315: set PJI_SOURCE_FLAG = 'Y',
8316: LAST_UPDATE_DATE = l_last_update_date,
8317: LAST_UPDATED_BY = l_last_updated_by,
8318: LAST_UPDATE_LOGIN = l_last_update_login
8357: PROJECT_ID
8358: from pji_fm_aggr_fin8
8359: ) and
8360: PROJECT_ID in (select PROJECT_ID
8361: from PA_PROJECTS_ALL
8362: where STRUCTURE_SHARING_CODE = 'SHARE_FULL');
8363:
8364: end if;
8365:
13072: 'LF', 'N') WP_FLAG,
13073: 'Y' PUSHUP_FLAG
13074: from
13075: PJI_XBS_DENORM prg,
13076: PA_PROJECTS_ALL prj,
13077: (
13078: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
13079: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
13080: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15411: prg.RELATIONSHIP_TYPE RELATIONSHIP_TYPE,
15412: 'Y' PUSHUP_FLAG
15413: from
15414: PJI_XBS_DENORM prg,
15415: PA_PROJECTS_ALL map
15416: where
15417: l_level > 1 and
15418: prg.STRUCT_TYPE = 'PRG' and
15419: prg.RELATIONSHIP_TYPE = 'LF' and