eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_FP_AGGR_PJP1_T

Line 11165: insert into PJI_FP_AGGR_PJP1_T

11161: while (l_level > 0) loop
11162:
11163: -- rollup project hiearchy
11164:
11165: insert into PJI_FP_AGGR_PJP1_T
11166: (
11167: WORKER_ID,
11168: RECORD_TYPE,
11169: PRG_LEVEL,

Line 11890: PJI_FP_AGGR_PJP1_T pjp1,

11886: pjp1.CUSTOM13,
11887: pjp1.CUSTOM14,
11888: pjp1.CUSTOM15
11889: from
11890: PJI_FP_AGGR_PJP1_T pjp1,
11891: PJI_PJP_WBS_HEADER wbs_hdr,
11892: PA_XBS_DENORM wbs,
11893: PJI_XBS_DENORM prg,
11894: (

Line 12044: PJI_FP_AGGR_PJP1_T pjp1,

12040: pjp1.CUSTOM13,
12041: pjp1.CUSTOM14,
12042: pjp1.CUSTOM15
12043: from
12044: PJI_FP_AGGR_PJP1_T pjp1,
12045: PJI_PJP_WBS_HEADER wbs_hdr,
12046: PJI_XBS_DENORM prg,
12047: (
12048: select 'Y' CB_FLAG,

Line 13689: insert into PJI_FP_AGGR_PJP1_T pjp1_i

13685: commit;
13686:
13687: else -- online mode
13688:
13689: insert into PJI_FP_AGGR_PJP1_T pjp1_i
13690: (
13691: WORKER_ID,
13692: RECORD_TYPE,
13693: PRG_LEVEL,

Line 14011: PJI_FP_AGGR_PJP1_T pjp1,

14007: sum(pjp1.CUSTOM13) CUSTOM13,
14008: sum(pjp1.CUSTOM14) CUSTOM14,
14009: sum(pjp1.CUSTOM15) CUSTOM15
14010: from
14011: PJI_FP_AGGR_PJP1_T pjp1,
14012: PJI_ROLLUP_LEVEL_STATUS ss,
14013: PJI_PJP_RBS_HEADER rbs_hdr,
14014: PJI_PJP_WBS_HEADER wbs_hdr,
14015: PA_RBS_DENORM rbs

Line 20461: delete from PJI_FP_AGGR_PJP1_T;

20457: else -- online mode
20458:
20459: delete from PJI_XBS_DENORM_DELTA_T;
20460:
20461: delete from PJI_FP_AGGR_PJP1_T;
20462:
20463: delete from PJI_AC_AGGR_PJP1_T;
20464:
20465: end if;