APPS.PJI_PROCESS_UTIL dependencies on PJI_XBS_DENORM_T

Line 45158: insert into PJI_XBS_DENORM_T

45154: and a.struct_type||'' = 'WBS'||'';
45155: -- Bug 13097931 - Forward port bugfix 12879208
45156:
45157:
45158: insert into PJI_XBS_DENORM_T
45159: (STRUCT_TYPE,
45160: PRG_GROUP,
45161: STRUCT_VERSION_ID,
45162: SUP_PROJECT_ID,

Line 45207: insert into PJI_XBS_DENORM_T

45203: where c.worker_id = p_worker_id
45204: and b.sup_project_id = c.project_id);
45205:
45206:
45207: insert into PJI_XBS_DENORM_T
45208: (STRUCT_TYPE,
45209: PRG_GROUP,
45210: STRUCT_VERSION_ID,
45211: SUP_PROJECT_ID,

Line 46047: PJI_XBS_DENORM_T prg,

46043: PJI_FP_AGGR_PJP1 pjp1,
46044: PJI_HELPER_420 helper,
46045: PJI_PJP_WBS_HEADER_T wbs_hdr,
46046: PA_XBS_DENORM wbs,
46047: PJI_XBS_DENORM_T prg,
46048: (
46049: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
46050: from DUAL union all
46051: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 46203: PJI_XBS_DENORM_T prg,

46199: from
46200: PJI_FP_AGGR_PJP1 pjp1,
46201: PJI_HELPER_420 helper, -- order in the From clause should not be changed unless recommended by perf team
46202: PJI_PJP_WBS_HEADER_T wbs_hdr,
46203: PJI_XBS_DENORM_T prg,
46204: (
46205: select 'Y' CB_FLAG,
46206: 'N' CO_FLAG,
46207: -3 PLAN_VERSION_ID

Line 46358: PJI_XBS_DENORM_T prg,

46354: PJI_PA_PROJ_EVENTS_LOG log,
46355: PJI_HELPER_420 helper,
46356: PJI_PJP_WBS_HEADER_T wbs_hdr,
46357: PJI_XBS_DENORM_DELTA wbs,
46358: PJI_XBS_DENORM_T prg,
46359: PJI_FP_XBS_ACCUM_F fpr,
46360: (
46361: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
46362: from DUAL union all

Line 46448: PJI_XBS_DENORM_T prg,

46444: 'LF', 'N') WP_FLAG,
46445: 'Y' PUSHUP_FLAG
46446: from
46447: PJI_PJP_PROJ_BATCH_MAP map,
46448: PJI_XBS_DENORM_T prg,
46449: (
46450: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
46451: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
46452: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all