APPS.PJI_PJP_SUM_ROLLUP dependencies on PA_PROJECTS_ALL

Line 4940: PA_PROJECTS_ALL prj,

4936: sum(src.G2_AR_AMOUNT_OVERDUE) G2_AR_AMOUNT_OVERDUE
4937: from
4938: PJI_PJP_RMAP_ACR src_r,
4939: PJI_FM_AGGR_ACT4 src,
4940: PA_PROJECTS_ALL prj,
4941: PJI_ORG_EXTR_INFO info
4942: where
4943: src_r.WORKER_ID = p_worker_id and
4944: src.ROWID = src_r.STG_ROWID and

Line 5047: update PA_PROJECTS_ALL

5043: l_last_update_date := sysdate;
5044: l_last_updated_by := FND_GLOBAL.USER_ID;
5045: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5046:
5047: update PA_PROJECTS_ALL
5048: set PJI_SOURCE_FLAG = 'Y',
5049: LAST_UPDATE_DATE = l_last_update_date,
5050: LAST_UPDATED_BY = l_last_updated_by,
5051: LAST_UPDATE_LOGIN = l_last_update_login

Line 5094: from PA_PROJECTS_ALL

5090: PROJECT_ID
5091: from pji_fm_aggr_fin8
5092: ) and
5093: PROJECT_ID in (select PROJECT_ID
5094: from PA_PROJECTS_ALL
5095: where STRUCTURE_SHARING_CODE = 'SHARE_FULL');
5096:
5097: end if;
5098:

Line 10960: PA_PROJECTS_ALL prj,

10956: 'LF', 'N') WP_FLAG,
10957: 'Y' PUSHUP_FLAG
10958: from
10959: PJI_XBS_DENORM prg,
10960: PA_PROJECTS_ALL prj,
10961: (
10962: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10963: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
10964: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 13295: PA_PROJECTS_ALL map

13291: prg.RELATIONSHIP_TYPE RELATIONSHIP_TYPE,
13292: 'Y' PUSHUP_FLAG
13293: from
13294: PJI_XBS_DENORM prg,
13295: PA_PROJECTS_ALL map
13296: where
13297: l_level > 1 and
13298: prg.STRUCT_TYPE = 'PRG' and
13299: prg.RELATIONSHIP_TYPE = 'LF' and