DBA Data[Home] [Help]

APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_PA_XBS_DENORM_T

Line 78: insert into PJI_PA_XBS_DENORM_T

74: from PJI_PJP_WBS_HEADER a
75: where a.project_id in ( select b.project_id from PJI_PJP_PROJ_BATCH_MAP b
76: where b.worker_id = p_worker_id );
77:
78: insert into PJI_PA_XBS_DENORM_T
79: (STRUCT_TYPE,
80: PRG_GROUP,
81: STRUCT_VERSION_ID,
82: SUP_PROJECT_ID,

Line 174: from PJI_PA_XBS_DENORM_T b, PJI_PJP_PROJ_BATCH_MAP c

170: STRUCT_EMT_ID,
171: RELATIONSHIP_TYPE
172: from PJI_XBS_DENORM a
173: where a.SUP_PROJECT_ID in ( select distinct b.SUP_PROJECT_ID
174: from PJI_PA_XBS_DENORM_T b, PJI_PJP_PROJ_BATCH_MAP c
175: where c.worker_id = p_worker_id
176: and b.sup_project_id = c.project_id);
177:
178: insert into PJI_XBS_DENORM_T

Line 1027: PJI_PA_XBS_DENORM_T wbs,

1023: -- Commenting and adding code for testing 0802
1024: --PJI_PJP_WBS_HEADER wbs_hdr,
1025: PJI_PJP_WBS_HEADER_T wbs_hdr,
1026: --PA_XBS_DENORM wbs,
1027: PJI_PA_XBS_DENORM_T wbs,
1028: --PJI_XBS_DENORM prg,
1029: PJI_XBS_DENORM_T prg,
1030: -- End of Commenting and adding code for testing 0802
1031: (