APPS.PJI_PJP_EXTRACTION_UTILS dependencies on PA_PROJECTS_ALL

Line 117: PA_PROJECTS_ALL prj,

113: l_creation_date,
114: l_created_by,
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

Line 132: from PA_PROJECTS_ALL prj

128:
129: delete
130: from PJI_PJP_PROJ_EXTR_STATUS pjp
131: where not exists (select 1
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.

Line 156: from PA_PROJECTS_ALL prj

152: -- will select only those projects which are eligible for status reporting.
153: /*delete
154: from PJI_PJP_PROJ_EXTR_STATUS pjp
155: where exists (select 1
156: from PA_PROJECTS_ALL prj
157: where prj.PROJECT_ID = pjp.PROJECT_ID
158: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(prj.PROJECT_STATUS_CODE, 'STATUS_REPORTING') = 'N'); */
159: /* End for Bug# 9749751 */
160:

Line 165: from PA_PROJECTS_ALL prj

161: update PJI_PJP_PROJ_EXTR_STATUS sts
162: set sts.PROJECT_ORGANIZATION_ID =
163: (
164: select prj.CARRYING_OUT_ORGANIZATION_ID
165: from PA_PROJECTS_ALL prj
166: where prj.PROJECT_ID = sts.PROJECT_ID
167: )
168: where exists
169: (

Line 171: from PA_PROJECTS_ALL prj

167: )
168: where exists
169: (
170: select 1
171: from PA_PROJECTS_ALL prj
172: where prj.PROJECT_ID = sts.PROJECT_ID and
173: prj.CARRYING_OUT_ORGANIZATION_ID <>
174: sts.PROJECT_ORGANIZATION_ID
175: );

Line 205: PA_PROJECTS_ALL prj,

201: l_creation_date,
202: l_created_by,
203: l_last_update_login
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

Line 260: PA_PROJECTS_ALL prj,

256: l_creation_date,
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

Line 304: PA_PROJECTS_ALL prj,

300: l_creation_date,
301: l_created_by,
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