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
119: where
120: prj.TEMPLATE_FLAG = 'N' and
121: prj.PROJECT_ID = pjp_status.PROJECT_ID (+) and

Line 127: from PA_PROJECTS_ALL prj

123:
124: delete
125: from PJI_PJP_PROJ_EXTR_STATUS pjp
126: where not exists (select 1
127: from PA_PROJECTS_ALL prj
128: where prj.PROJECT_ID = pjp.PROJECT_ID);
129:
130: update PJI_PJP_PROJ_EXTR_STATUS sts
131: set sts.PROJECT_ORGANIZATION_ID =

Line 134: from PA_PROJECTS_ALL prj

130: update PJI_PJP_PROJ_EXTR_STATUS sts
131: set sts.PROJECT_ORGANIZATION_ID =
132: (
133: select prj.CARRYING_OUT_ORGANIZATION_ID
134: from PA_PROJECTS_ALL prj
135: where prj.PROJECT_ID = sts.PROJECT_ID
136: )
137: where exists
138: (

Line 140: from PA_PROJECTS_ALL prj

136: )
137: where exists
138: (
139: select 1
140: from PA_PROJECTS_ALL prj
141: where prj.PROJECT_ID = sts.PROJECT_ID and
142: prj.CARRYING_OUT_ORGANIZATION_ID <>
143: sts.PROJECT_ORGANIZATION_ID
144: );

Line 174: PA_PROJECTS_ALL prj,

170: l_creation_date,
171: l_created_by,
172: l_last_update_login
173: from
174: PA_PROJECTS_ALL prj,
175: PA_PROJECT_TYPES_ALL pt,
176: PJI_PJP_PROJ_EXTR_STATUs pjp_status
177: where
178: prj.TEMPLATE_FLAG = 'N' and

Line 224: PA_PROJECTS_ALL prj

220: l_creation_date,
221: l_created_by,
222: l_last_update_login
223: from
224: PA_PROJECTS_ALL prj
225: where
226: prj.TEMPLATE_FLAG = 'N' and
227: not exists (select 1
228: from PA_XBS_DENORM den

Line 265: PA_PROJECTS_ALL prj,

261: l_creation_date,
262: l_created_by,
263: l_last_update_login
264: from
265: PA_PROJECTS_ALL prj,
266: PA_PROJECT_TYPES_ALL pt
267: where
268: prj.TEMPLATE_FLAG = 'N' and
269: prj.ORG_ID = pt.ORG_ID and /*5377131*/