DBA Data[Home] [Help]

APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_FP_AGGR_XBS_T

Line 18872: from PJI_FP_AGGR_XBS_T prg

18868: delete /*+ index(den PJI_XBS_DENORM_N4) */ /* modified the hint to use PJI_XBS_DENORM_N4 instead of PJI_XBS_DENORM_N3 */
18869: from PJI_XBS_DENORM den
18870: where den.STRUCT_TYPE = 'PRG' and
18871: den.SUP_PROJECT_ID in (select prg.SUP_PROJECT_ID
18872: from PJI_FP_AGGR_XBS_T prg
18873: where prg.STRUCT_TYPE = 'PRG');
18874:
18875: l_count := l_count + sql%rowcount;
18876:

Line 18952: from PJI_FP_AGGR_XBS_T prg

18948: PA_XBS_DENORM den
18949: where
18950: den.STRUCT_TYPE = 'PRG' and
18951: den.SUP_PROJECT_ID in (select prg.SUP_PROJECT_ID
18952: from PJI_FP_AGGR_XBS_T prg
18953: where prg.STRUCT_TYPE = 'PRG');
18954:
18955: --Commented below portion of code for bug 7197275
18956: if (l_count > 0) then --Uncommented for bug 14571067