DBA Data[Home] [Help]

APPS.PA_PROJECT_VERIFY_PKG dependencies on PA_CLASS_CATEGORIES

Line 153: FROM PA_CLASS_CATEGORIES cc,

149: FROM DUAL
150: WHERE EXISTS
151: (
152: SELECT 1
153: FROM PA_CLASS_CATEGORIES cc,
154: PA_VALID_CATEGORIES vc,
155: PA_PROJECT_TYPES_ALL PPTA,
156: PA_PROJECTS_ALL PPA
157: WHERE VC.CLASS_CATEGORY = CC.CLASS_CATEGORY

Line 178: from PA_CLASS_CATEGORIES CC

174: IS
175: SELECT NULL
176: FROM DUAL
177: WHERE EXISTS (SELECT 1
178: from PA_CLASS_CATEGORIES CC
179: WHERE CC.MANDATORY_FLAG = 'Y'
180: AND CC.OBJECT_TYPE = 'PA_PROJECTS'
181: AND CC.ALL_TYPES_VALID_FLAG = 'Y'
182: AND TRUNC(SYSDATE) BETWEEN TRUNC(CC.START_DATE_ACTIVE)