DBA Data[Home] [Help]

APPS.PA_PROJECT_VERIFY_PKG dependencies on PA_CLASS_CATEGORIES

Line 145: FROM PA_CLASS_CATEGORIES cc,

141: FROM DUAL
142: WHERE EXISTS
143: (
144: SELECT 1
145: FROM PA_CLASS_CATEGORIES cc,
146: PA_VALID_CATEGORIES vc,
147: PA_PROJECT_TYPES_ALL PPTA,
148: PA_PROJECTS_ALL PPA
149: WHERE VC.CLASS_CATEGORY = CC.CLASS_CATEGORY

Line 170: from PA_CLASS_CATEGORIES CC

166: IS
167: SELECT NULL
168: FROM DUAL
169: WHERE EXISTS (SELECT 1
170: from PA_CLASS_CATEGORIES CC
171: WHERE CC.MANDATORY_FLAG = 'Y'
172: AND CC.OBJECT_TYPE = 'PA_PROJECTS'
173: AND CC.ALL_TYPES_VALID_FLAG = 'Y'
174: AND TRUNC(SYSDATE) BETWEEN TRUNC(CC.START_DATE_ACTIVE)