DBA Data[Home] [Help]

APPS.INV_PROJECT dependencies on PJM_TASKS_V

Line 172: FROM pjm_tasks_v m

168: if ( source_task_id IS NOT NULL ) then
169: BEGIN
170: SELECT m.task_number
171: INTO source_task_number
172: FROM pjm_tasks_v m
173: WHERE m.task_id = source_task_id
174: AND m.project_id = source_project_id;
175:
176: EXCEPTION

Line 189: FROM pjm_tasks_v m

185: if ( t_task_id IS NOT NULL ) then
186: BEGIN
187: SELECT m.task_number
188: INTO t_task_number
189: FROM pjm_tasks_v m
190: WHERE m.task_id = t_task_id
191: AND m.project_id = p_project_id;
192:
193: EXCEPTION

Line 205: FROM pjm_tasks_v m

201: if ( to_task_id IS NOT NULL ) then
202: BEGIN
203: SELECT m.task_number
204: INTO to_task_number
205: FROM pjm_tasks_v m
206: WHERE m.task_id = to_task_id
207: AND m.project_id = to_project_id;
208:
209: EXCEPTION

Line 2031: FROM pjm_tasks_v m

2027: BEGIN
2028: l_task_id := to_number(l_buf);
2029: SELECT m.task_number
2030: INTO l_pt_buf
2031: FROM pjm_tasks_v m
2032: WHERE m.task_id = l_task_id
2033: AND m.project_id = l_project_id
2034: AND ROWNUM = 1;
2035: EXCEPTION