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_AC_AGGR_PJP1_T

Line 12783: insert into PJI_AC_AGGR_PJP1_T

12779: while (l_level > 0) loop
12780:
12781: -- rollup project hiearchy
12782:
12783: insert into PJI_AC_AGGR_PJP1_T
12784: (
12785: WORKER_ID,
12786: RECORD_TYPE,
12787: PRG_LEVEL,

Line 13046: PJI_AC_AGGR_PJP1_T pjp1,

13042: pjp1.CUSTOM13,
13043: pjp1.CUSTOM14,
13044: pjp1.CUSTOM15
13045: from
13046: PJI_AC_AGGR_PJP1_T pjp1,
13047: PJI_PJP_WBS_HEADER wbs_hdr,
13048: PA_XBS_DENORM wbs,
13049: PJI_XBS_DENORM prg,
13050: (

Line 13142: PJI_AC_AGGR_PJP1_T pjp1,

13138: pjp1.CUSTOM13,
13139: pjp1.CUSTOM14,
13140: pjp1.CUSTOM15
13141: from
13142: PJI_AC_AGGR_PJP1_T pjp1,
13143: PJI_PJP_WBS_HEADER wbs_hdr,
13144: PJI_XBS_DENORM prg
13145: where
13146: prg.STRUCT_TYPE = 'PRG' and

Line 18073: delete from PJI_AC_AGGR_PJP1_T;

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;
18076:
18077: end CLEANUP;