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 14903: insert into PJI_AC_AGGR_PJP1_T

14899: while (l_level > 0) loop
14900:
14901: -- rollup project hiearchy
14902:
14903: insert into PJI_AC_AGGR_PJP1_T
14904: (
14905: WORKER_ID,
14906: RECORD_TYPE,
14907: PRG_LEVEL,

Line 15166: PJI_AC_AGGR_PJP1_T pjp1,

15162: pjp1.CUSTOM13,
15163: pjp1.CUSTOM14,
15164: pjp1.CUSTOM15
15165: from
15166: PJI_AC_AGGR_PJP1_T pjp1,
15167: PJI_PJP_WBS_HEADER wbs_hdr,
15168: PA_XBS_DENORM wbs,
15169: PJI_XBS_DENORM prg,
15170: (

Line 15262: PJI_AC_AGGR_PJP1_T pjp1,

15258: pjp1.CUSTOM13,
15259: pjp1.CUSTOM14,
15260: pjp1.CUSTOM15
15261: from
15262: PJI_AC_AGGR_PJP1_T pjp1,
15263: PJI_PJP_WBS_HEADER wbs_hdr,
15264: PJI_XBS_DENORM prg
15265: where
15266: prg.STRUCT_TYPE = 'PRG' and

Line 20463: delete from PJI_AC_AGGR_PJP1_T;

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;
20466:
20467: end CLEANUP;