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 9052: insert into PJI_FP_AGGR_PJP1_T

9048: while (l_level > 0) loop
9049:
9050: -- rollup project hiearchy
9051:
9052: insert into PJI_FP_AGGR_PJP1_T
9053: (
9054: WORKER_ID,
9055: RECORD_TYPE,
9056: PRG_LEVEL,

Line 9777: PJI_FP_AGGR_PJP1_T pjp1,

9773: pjp1.CUSTOM13,
9774: pjp1.CUSTOM14,
9775: pjp1.CUSTOM15
9776: from
9777: PJI_FP_AGGR_PJP1_T pjp1,
9778: PJI_PJP_WBS_HEADER wbs_hdr,
9779: PA_XBS_DENORM wbs,
9780: PJI_XBS_DENORM prg,
9781: (

Line 9931: PJI_FP_AGGR_PJP1_T pjp1,

9927: pjp1.CUSTOM13,
9928: pjp1.CUSTOM14,
9929: pjp1.CUSTOM15
9930: from
9931: PJI_FP_AGGR_PJP1_T pjp1,
9932: PJI_PJP_WBS_HEADER wbs_hdr,
9933: PJI_XBS_DENORM prg,
9934: (
9935: select 'Y' CB_FLAG,

Line 11573: insert into PJI_FP_AGGR_PJP1_T pjp1_i

11569: commit;
11570:
11571: else -- online mode
11572:
11573: insert into PJI_FP_AGGR_PJP1_T pjp1_i
11574: (
11575: WORKER_ID,
11576: RECORD_TYPE,
11577: PRG_LEVEL,

Line 11895: PJI_FP_AGGR_PJP1_T pjp1,

11891: sum(pjp1.CUSTOM13) CUSTOM13,
11892: sum(pjp1.CUSTOM14) CUSTOM14,
11893: sum(pjp1.CUSTOM15) CUSTOM15
11894: from
11895: PJI_FP_AGGR_PJP1_T pjp1,
11896: PJI_ROLLUP_LEVEL_STATUS ss,
11897: PJI_PJP_RBS_HEADER rbs_hdr,
11898: PJI_PJP_WBS_HEADER wbs_hdr,
11899: PA_RBS_DENORM rbs

Line 18071: delete from PJI_FP_AGGR_PJP1_T;

18067: else -- online mode
18068:
18069: delete from PJI_XBS_DENORM_DELTA_T;
18070:
18071: delete from PJI_FP_AGGR_PJP1_T;
18072:
18073: delete from PJI_AC_AGGR_PJP1_T;
18074:
18075: end if;