DBA Data[Home] [Help]

APPS.INV_PROJECT dependencies on PJM_TASKS_V

Line 177: FROM pjm_tasks_v m

173: if ( source_task_id IS NOT NULL ) then
174: BEGIN
175: SELECT m.task_number
176: INTO source_task_number
177: FROM pjm_tasks_v m
178: WHERE m.task_id = source_task_id
179: AND m.project_id = source_project_id;
180:
181: EXCEPTION

Line 194: FROM pjm_tasks_v m

190: if ( t_task_id IS NOT NULL ) then
191: BEGIN
192: SELECT m.task_number
193: INTO t_task_number
194: FROM pjm_tasks_v m
195: WHERE m.task_id = t_task_id
196: AND m.project_id = p_project_id;
197:
198: EXCEPTION

Line 210: FROM pjm_tasks_v m

206: if ( to_task_id IS NOT NULL ) then
207: BEGIN
208: SELECT m.task_number
209: INTO to_task_number
210: FROM pjm_tasks_v m
211: WHERE m.task_id = to_task_id
212: AND m.project_id = to_project_id;
213:
214: EXCEPTION

Line 2061: FROM pjm_tasks_v m

2057: BEGIN
2058: l_task_id := to_number(l_buf);
2059: SELECT m.task_number
2060: INTO l_pt_buf
2061: FROM pjm_tasks_v m
2062: WHERE m.task_id = l_task_id
2063: AND m.project_id = l_project_id
2064: AND ROWNUM = 1;
2065: EXCEPTION