DBA Data[Home] [Help]

APPS.PA_PROJECT_VERIFY_PKG dependencies on PA_VALID_CATEGORIES

Line 124: FROM PA_VALID_CATEGORIES_V VC,

120:
121: CURSOR C1
122: IS
123: SELECT NULL
124: FROM PA_VALID_CATEGORIES_V VC,
125: PA_PROJECTS_ALL PPA,
126: PA_PROJECT_TYPES_ALL PPTA
127: WHERE VC.MANDATORY_FLAG = 'Y'
128: AND PPA.PROJECT_ID = x_project_id

Line 146: PA_VALID_CATEGORIES vc,

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