APPS.PA_PROJECT_PVT dependencies on PA_CLASS_CATEGORIES

Line 602: FROM PA_CLASS_CATEGORIES cc,

598: FROM DUAL
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

Line 626: FROM PA_CLASS_CATEGORIES cc

622: FROM DUAL
623: WHERE EXISTS
624: (
625: SELECT 'Y'
626: FROM PA_CLASS_CATEGORIES cc
627: WHERE CC.OBJECT_TYPE = 'PA_PROJECTS'
628: AND CC.ALL_TYPES_VALID_FLAG = 'Y'
629: AND TRUNC(SYSDATE) BETWEEN TRUNC(CC.START_DATE_ACTIVE)
630: AND TRUNC(NVL(CC.END_DATE_ACTIVE, SYSDATE))

Line 639: FROM PA_CLASS_CATEGORIES

635:
636: CURSOR l_check_percentage_csr (c_class_category VARCHAR2)
637: IS
638: SELECT 'Y'
639: FROM PA_CLASS_CATEGORIES
640: WHERE class_category = c_class_category
641: AND allow_percent_flag = 'Y';
642:
643: CURSOR l_get_percent_flag_csr (c_class_category VARCHAR2)

Line 646: FROM PA_CLASS_CATEGORIES

642:
643: CURSOR l_get_percent_flag_csr (c_class_category VARCHAR2)
644: IS
645: SELECT allow_percent_flag
646: FROM PA_CLASS_CATEGORIES
647: WHERE class_category = c_class_category;
648:
649: /* code addition for bug 2448159 starts*/
650: CURSOR l_pick_one_code_only_flag (c_class_category VARCHAR2)

Line 653: FROM PA_CLASS_CATEGORIES

649: /* code addition for bug 2448159 starts*/
650: CURSOR l_pick_one_code_only_flag (c_class_category VARCHAR2)
651: IS
652: SELECT PICK_ONE_CODE_ONLY_FLAG
653: FROM PA_CLASS_CATEGORIES
654: WHERE class_category = c_class_category;
655:
656: CURSOR l_get_code_count (c_project_id NUMBER, c_class_category VARCHAR2)
657: IS