APPS.PA_PROJECT_VERIFY_PKG dependencies on PA_PROJECT_CLASSES

Line 141: FROM PA_PROJECT_CLASSES PC

137: AND PPA.PROJECT_TYPE = PPTA.PROJECT_TYPE
138: AND nvl(PPA.ORG_ID, -99) = nvl(PPTA.ORG_ID, -99)
139: AND VC.OBJECT_TYPE_ID = PPTA.PROJECT_TYPE_ID
140: AND NOT EXISTS (SELECT NULL
141: FROM PA_PROJECT_CLASSES PC
142: WHERE PC.PROJECT_ID = x_project_id
143: AND PC.CLASS_CATEGORY = VC.CLASS_CATEGORY);
144: */
145:

Line 168: FROM PA_PROJECT_CLASSES PC

164: AND PPA.PROJECT_ID = x_project_id
165: AND PPA.PROJECT_TYPE = PPTA.PROJECT_TYPE
166: AND PPA.ORG_ID = PPTA.ORG_ID --MOAC Changes: Bug 4363092: removed nvl usage with org_id
167: AND NOT EXISTS (SELECT NULL
168: FROM PA_PROJECT_CLASSES PC
169: WHERE PC.PROJECT_ID = x_project_id
170: AND PC.CLASS_CATEGORY = VC.CLASS_CATEGORY)
171: );
172:

Line 185: FROM PA_PROJECT_CLASSES PC

181: AND CC.ALL_TYPES_VALID_FLAG = 'Y'
182: AND TRUNC(SYSDATE) BETWEEN TRUNC(CC.START_DATE_ACTIVE)
183: AND TRUNC(NVL(CC.END_DATE_ACTIVE, SYSDATE))
184: AND NOT EXISTS(SELECT NULL
185: FROM PA_PROJECT_CLASSES PC
186: WHERE PC.PROJECT_ID = x_project_id
187: AND PC.CLASS_CATEGORY = CC.CLASS_CATEGORY)
188: );
189:

Line 209: FROM PA_PROJECT_CLASSES

205: /* Start of new code for Performance Bug # 3691123 */
206: CURSOR C2
207: IS
208: SELECT NULL
209: FROM PA_PROJECT_CLASSES
210: WHERE project_id = x_project_id
211: AND OBJECT_TYPE = 'PA_PROJECTS'
212: AND decode(PA_PROJECTS_MAINT_UTILS.GET_CLASS_EXCEPTIONS(object_id,object_type, class_category, 'N'), NULL, 'C', 'A') = 'A'
213: ;