APPS.PA_TASK_UTILS dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 2644: function is_flex_field_defined(p_project_id IN PA_PROJ_ELEM_VER_SCHEDULE.PROJECT_ID%TYPE

2640: --
2641: -- HISTORY
2642: --
2643: -- 23-Jul-12 Amit Sharma Created for bug Usability Enhancement
2644: function is_flex_field_defined(p_project_id IN PA_PROJ_ELEM_VER_SCHEDULE.PROJECT_ID%TYPE
2645: ,p_element_version_id IN PA_PROJ_ELEM_VER_SCHEDULE.ELEMENT_VERSION_ID%TYPE
2646: ,p_proj_element_id IN PA_PROJ_ELEM_VER_SCHEDULE.PROJ_ELEMENT_ID%TYPE) RETURN VARCHAR2
2647: is
2648: CURSOR c1

Line 2645: ,p_element_version_id IN PA_PROJ_ELEM_VER_SCHEDULE.ELEMENT_VERSION_ID%TYPE

2641: -- HISTORY
2642: --
2643: -- 23-Jul-12 Amit Sharma Created for bug Usability Enhancement
2644: function is_flex_field_defined(p_project_id IN PA_PROJ_ELEM_VER_SCHEDULE.PROJECT_ID%TYPE
2645: ,p_element_version_id IN PA_PROJ_ELEM_VER_SCHEDULE.ELEMENT_VERSION_ID%TYPE
2646: ,p_proj_element_id IN PA_PROJ_ELEM_VER_SCHEDULE.PROJ_ELEMENT_ID%TYPE) RETURN VARCHAR2
2647: is
2648: CURSOR c1
2649: IS

Line 2646: ,p_proj_element_id IN PA_PROJ_ELEM_VER_SCHEDULE.PROJ_ELEMENT_ID%TYPE) RETURN VARCHAR2

2642: --
2643: -- 23-Jul-12 Amit Sharma Created for bug Usability Enhancement
2644: function is_flex_field_defined(p_project_id IN PA_PROJ_ELEM_VER_SCHEDULE.PROJECT_ID%TYPE
2645: ,p_element_version_id IN PA_PROJ_ELEM_VER_SCHEDULE.ELEMENT_VERSION_ID%TYPE
2646: ,p_proj_element_id IN PA_PROJ_ELEM_VER_SCHEDULE.PROJ_ELEMENT_ID%TYPE) RETURN VARCHAR2
2647: is
2648: CURSOR c1
2649: IS
2650: SELECT 1

Line 2654: FROM PA_PROJ_ELEM_VER_SCHEDULE

2650: SELECT 1
2651: FROM dual
2652: WHERE EXISTS
2653: (SELECT NULL
2654: FROM PA_PROJ_ELEM_VER_SCHEDULE
2655: WHERE PROJECT_ID = p_project_id
2656: AND ELEMENT_VERSION_ID = p_element_version_id
2657: AND PROJ_ELEMENT_ID = p_proj_element_id
2658: AND (attribute_category IS NOT NULL