DBA Data[Home] [Help]

APPS.ENG_VAL_TO_ID dependencies on PA_TASKS

Line 173: USING p_lifecycle_name, l_item_lifecycle_id, 'PA_TASKS';

169: || 'and object_type = :3 ';
170:
171: EXECUTE IMMEDIATE l_sql_stmt
172: INTO l_id
173: USING p_lifecycle_name, l_item_lifecycle_id, 'PA_TASKS';
174:
175: -- End Changes
176:
177: RETURN l_id;

Line 436: FROM pa_tasks

432: BEGIN
433:
434: SELECT task_id
435: INTO l_id
436: FROM pa_tasks
437: WHERE task_number = p_task_number
438: AND project_id = p_project_id;
439:
440: RETURN l_id;