DBA Data[Home] [Help]

APPS.PA_TASK_ASSIGNMENT_UTILS dependencies on PA_MAP_WP_TO_FIN_TASKS_V

Line 295: FROM pa_resource_assignments ra, pa_map_wp_to_fin_tasks_v map

291:
292: --CURSOR C1_Check_Exists(p_wp_task_id IN NUMBER, p_ei_date IN DATE) IS
293: CURSOR C1_Check_Exists(p_ei_date IN DATE, p_project_id IN NUMBER) IS
294: SELECT 'Y'
295: FROM pa_resource_assignments ra, pa_map_wp_to_fin_tasks_v map
296: WHERE p_ei_date BETWEEN ra.planning_start_date AND ra.planning_end_Date
297: AND ra.person_id = p_person_id
298: AND ra.ta_display_flag = 'Y'
299: AND ra.wbs_element_version_id = map.element_version_id