DBA Data[Home] [Help]

APPS.EAM_WO_VALIDATE_PVT dependencies on PJM_TASKS_V

Line 2095: FROM pjm_tasks_v

2091: begin
2092: IF (p_eam_wo_rec.task_id IS NOT NULL) THEN
2093: SELECT 1
2094: INTO g_dummy
2095: FROM pjm_tasks_v
2096: WHERE project_id = p_eam_wo_rec.project_id
2097: AND task_id = p_eam_wo_rec.task_id;
2098:
2099: IF p_eam_wo_rec.scheduled_start_date >= sysdate THEN

Line 2111: FROM pjm_tasks_v

2107: IF p_eam_wo_rec.status_type = 3 and ( p_old_eam_wo_rec.status_type in (17,1,6) OR p_old_eam_wo_rec.status_type IS NULL ) THEN
2108: /* Added for bug#5346213 End */
2109: SELECT 1
2110: INTO g_dummy
2111: FROM pjm_tasks_v
2112: WHERE project_id = p_eam_wo_rec.project_id
2113: AND task_id = p_eam_wo_rec.task_id
2114: /* AND (completion_date IS NULL OR completion_date >= l_min_date); Commented for bug#5346213 */
2115: AND (completion_date IS NULL OR trunc(completion_date) >= trunc(l_min_date)); /* Added for bug#5346213 */