DBA Data[Home] [Help]

APPS.PA_ACTION_SETS_DYN dependencies on PA_TASK_PROGRESS_REMINDER_V

Line 248: FROM PA_TASK_PROGRESS_REMINDER_V conc_view,

244: conc_view.project_number
245: BULK COLLECT INTO x_action_set_line_id_tbl,
246: x_object_name_tbl,
247: x_project_number_tbl
248: FROM PA_TASK_PROGRESS_REMINDER_V conc_view,
249: pa_action_sets asets,
250: pa_action_set_lines alines
251: WHERE project_number BETWEEN p_project_number_from AND p_project_number_to
252: AND conc_view.object_type = asets.object_type

Line 266: FROM PA_TASK_PROGRESS_REMINDER_V conc_view,

262: conc_view.project_number
263: BULK COLLECT INTO x_action_set_line_id_tbl,
264: x_object_name_tbl,
265: x_project_number_tbl
266: FROM PA_TASK_PROGRESS_REMINDER_V conc_view,
267: pa_action_sets asets,
268: pa_action_set_lines alines
269: WHERE project_number >= p_project_number_from
270: AND conc_view.object_type = asets.object_type

Line 284: FROM PA_TASK_PROGRESS_REMINDER_V conc_view,

280: conc_view.project_number
281: BULK COLLECT INTO x_action_set_line_id_tbl,
282: x_object_name_tbl,
283: x_project_number_tbl
284: FROM PA_TASK_PROGRESS_REMINDER_V conc_view,
285: pa_action_sets asets,
286: pa_action_set_lines alines
287: WHERE project_number <= p_project_number_to
288: AND conc_view.object_type = asets.object_type

Line 302: FROM PA_TASK_PROGRESS_REMINDER_V conc_view,

298: conc_view.project_number
299: BULK COLLECT INTO x_action_set_line_id_tbl,
300: x_object_name_tbl,
301: x_project_number_tbl
302: FROM PA_TASK_PROGRESS_REMINDER_V conc_view,
303: pa_action_sets asets,
304: pa_action_set_lines alines
305: WHERE
306: conc_view.object_type = asets.object_type