APPS.PJI_PJP_EXTRACTION_UTILS dependencies on PJI_PROJ_EXTR_STATUS

Line 119: PJI_PROJ_EXTR_STATUS fm_status Added for bug 8661279 */

115: l_last_update_login
116: from
117: PA_PROJECTS_ALL prj,
118: PJI_PJP_PROJ_EXTR_STATUS pjp_status/*, Commented for bug 8916168
119: PJI_PROJ_EXTR_STATUS fm_status Added for bug 8661279 */
120: where
121: prj.TEMPLATE_FLAG = 'N' and
122: prj.PROJECT_ID = pjp_status.PROJECT_ID (+) and
123: PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED

Line 136: is always in sync with data in PJI_PROJ_EXTR_STATUS.

132: from PA_PROJECTS_ALL prj
133: where prj.PROJECT_ID = pjp.PROJECT_ID);
134:
135: /* This delete statement is added so that data in PJI_PJP_PROJ_EXTR_STATUS
136: is always in sync with data in PJI_PROJ_EXTR_STATUS.
137: Code added for bug 6748705 starts **** Commented for bug 9034593 ****
138: delete
139: from PJI_PJP_PROJ_EXTR_STATUS pjp
140: where not exists (select 1

Line 141: from PJI_PROJ_EXTR_STATUS prj

137: Code added for bug 6748705 starts **** Commented for bug 9034593 ****
138: delete
139: from PJI_PJP_PROJ_EXTR_STATUS pjp
140: where not exists (select 1
141: from PJI_PROJ_EXTR_STATUS prj
142: where prj.PROJECT_ID = pjp.PROJECT_ID);
143: /* Code added for bug 6748705 ends */
144:
145: /* Below delete added for Bug# 9749751 */

Line 208: PJI_PROJ_EXTR_STATUS fm_status Added for bug 6748705 */

204: from
205: PA_PROJECTS_ALL prj,
206: PA_PROJECT_TYPES_ALL pt,
207: PJI_PJP_PROJ_EXTR_STATUs pjp_status/*, Commented for bug 8916168
208: PJI_PROJ_EXTR_STATUS fm_status Added for bug 6748705 */
209: where
210: prj.TEMPLATE_FLAG = 'N' and
211: prj.ORG_ID = pt.ORG_ID and /*5377131*/
212: prj.PROJECT_TYPE = pt.PROJECT_TYPE and

Line 261: PJI_PROJ_EXTR_STATUS fm_status /* Added for bug 8661279 */

257: l_created_by,
258: l_last_update_login
259: from
260: PA_PROJECTS_ALL prj,
261: PJI_PROJ_EXTR_STATUS fm_status /* Added for bug 8661279 */
262: where
263: prj.TEMPLATE_FLAG = 'N' and
264: not exists (select 1
265: from PA_XBS_DENORM den

Line 306: PJI_PROJ_EXTR_STATUS fm_status /* Added for bug 6748705 */

302: l_last_update_login
303: from
304: PA_PROJECTS_ALL prj,
305: PA_PROJECT_TYPES_ALL pt,
306: PJI_PROJ_EXTR_STATUS fm_status /* Added for bug 6748705 */
307: where
308: prj.TEMPLATE_FLAG = 'N' and
309: prj.ORG_ID = pt.ORG_ID and /*5377131*/
310: prj.PROJECT_ID = fm_status.project_id and /* Added for bug 6748705 */