APPS.PA_PROJECT_VERIFY_PKG dependencies on PA_PROJECT_CLASSES

Line 133: FROM PA_PROJECT_CLASSES PC

129: AND PPA.PROJECT_TYPE = PPTA.PROJECT_TYPE
130: AND nvl(PPA.ORG_ID, -99) = nvl(PPTA.ORG_ID, -99)
131: AND VC.OBJECT_TYPE_ID = PPTA.PROJECT_TYPE_ID
132: AND NOT EXISTS (SELECT NULL
133: FROM PA_PROJECT_CLASSES PC
134: WHERE PC.PROJECT_ID = x_project_id
135: AND PC.CLASS_CATEGORY = VC.CLASS_CATEGORY);
136: */
137:

Line 160: FROM PA_PROJECT_CLASSES PC

156: AND PPA.PROJECT_ID = x_project_id
157: AND PPA.PROJECT_TYPE = PPTA.PROJECT_TYPE
158: AND PPA.ORG_ID = PPTA.ORG_ID --MOAC Changes: Bug 4363092: removed nvl usage with org_id
159: AND NOT EXISTS (SELECT NULL
160: FROM PA_PROJECT_CLASSES PC
161: WHERE PC.PROJECT_ID = x_project_id
162: AND PC.CLASS_CATEGORY = VC.CLASS_CATEGORY)
163: );
164:

Line 177: FROM PA_PROJECT_CLASSES PC

173: AND CC.ALL_TYPES_VALID_FLAG = 'Y'
174: AND TRUNC(SYSDATE) BETWEEN TRUNC(CC.START_DATE_ACTIVE)
175: AND TRUNC(NVL(CC.END_DATE_ACTIVE, SYSDATE))
176: AND NOT EXISTS(SELECT NULL
177: FROM PA_PROJECT_CLASSES PC
178: WHERE PC.PROJECT_ID = x_project_id
179: AND PC.CLASS_CATEGORY = CC.CLASS_CATEGORY)
180: );
181:

Line 201: FROM PA_PROJECT_CLASSES

197: /* Start of new code for Performance Bug # 3691123 */
198: CURSOR C2
199: IS
200: SELECT NULL
201: FROM PA_PROJECT_CLASSES
202: WHERE project_id = x_project_id
203: AND OBJECT_TYPE = 'PA_PROJECTS'
204: AND decode(PA_PROJECTS_MAINT_UTILS.GET_CLASS_EXCEPTIONS(object_id,object_type, class_category, 'N'), NULL, 'C', 'A') = 'A'
205: ;