DBA Data[Home] [Help]

APPS.PA_PROJECT_VERIFY_PKG dependencies on PA_VALID_CATEGORIES

Line 132: FROM PA_VALID_CATEGORIES_V VC,

128:
129: CURSOR C1
130: IS
131: SELECT NULL
132: FROM PA_VALID_CATEGORIES_V VC,
133: PA_PROJECTS_ALL PPA,
134: PA_PROJECT_TYPES_ALL PPTA
135: WHERE VC.MANDATORY_FLAG = 'Y'
136: AND PPA.PROJECT_ID = x_project_id

Line 154: PA_VALID_CATEGORIES vc,

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
158: AND TRUNC(SYSDATE) BETWEEN TRUNC(CC.START_DATE_ACTIVE)