DBA Data[Home] [Help]

APPS.PA_PROJECT_UTILS dependencies on PA_VALID_CATEGORIES_V

Line 625: FROM PA_VALID_CATEGORIES_V VC,

621: WHERE MANDATORY_FLAG = 'Y'
622: AND TRUNC(SYSDATE) BETWEEN TRUNC(START_DATE_ACTIVE)
623: AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE))
624: */
625: FROM PA_VALID_CATEGORIES_V VC,
626: PA_PROJECTS_ALL PPA,
627: PA_PROJECT_TYPES_ALL PPTA
628: WHERE VC.MANDATORY_FLAG = 'Y'
629: AND PPA.PROJECT_ID = x_project_id