DBA Data[Home] [Help]

APPS.EAM_WO_VALIDATE_PVT dependencies on PJM_TASKS_V

Line 2175: FROM pjm_tasks_v

2171: begin
2172: IF (p_eam_wo_rec.task_id IS NOT NULL) THEN
2173: SELECT 1
2174: INTO g_dummy
2175: FROM pjm_tasks_v
2176: WHERE project_id = p_eam_wo_rec.project_id
2177: AND task_id = p_eam_wo_rec.task_id;
2178:
2179: IF p_eam_wo_rec.scheduled_start_date >= sysdate THEN

Line 2191: FROM pjm_tasks_v

2187: 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
2188: /* Added for bug#5346213 End */
2189: SELECT 1
2190: INTO g_dummy
2191: FROM pjm_tasks_v
2192: WHERE project_id = p_eam_wo_rec.project_id
2193: AND task_id = p_eam_wo_rec.task_id
2194: /* AND (completion_date IS NULL OR completion_date >= l_min_date); Commented for bug#5346213 */
2195: AND (completion_date IS NULL OR trunc(completion_date) >= trunc(l_min_date)); /* Added for bug#5346213 */