DBA Data[Home] [Help]

APPS.PA_PROJECT_PVT dependencies on PA_VALID_CATEGORIES

Line 585: FROM PA_VALID_CATEGORIES_V vc,

581:
582: CURSOR l_valid_category_csr (c_project_id NUMBER, c_class_category VARCHAR2)
583: IS
584: SELECT 'Y'
585: FROM PA_VALID_CATEGORIES_V vc,
586: PA_PROJECTS_ALL ppa,
587: PA_PROJECT_TYPES_ALL ppta
588: WHERE ppa.project_id = c_project_id
589: AND ppa.project_type = ppta.project_type

Line 603: PA_VALID_CATEGORIES vc,

599: WHERE EXISTS
600: (
601: SELECT 'Y'
602: FROM PA_CLASS_CATEGORIES cc,
603: PA_VALID_CATEGORIES vc,
604: PA_PROJECT_TYPES_ALL PPTA,
605: PA_PROJECTS_ALL PPA
606: WHERE PPA.PROJECT_ID = c_project_id
607: AND PPA.PROJECT_TYPE = PPTA.PROJECT_TYPE