DBA Data[Home] [Help]

APPS.PA_ACTION_SETS_DYN dependencies on PA_PROJ_STATUS_REMINDER_V

Line 169: FROM PA_PROJ_STATUS_REMINDER_V conc_view,

165: conc_view.project_number
166: BULK COLLECT INTO x_action_set_line_id_tbl,
167: x_object_name_tbl,
168: x_project_number_tbl
169: FROM PA_PROJ_STATUS_REMINDER_V conc_view,
170: pa_action_sets asets,
171: pa_action_set_lines alines
172: WHERE project_number BETWEEN p_project_number_from AND p_project_number_to
173: AND conc_view.object_type = asets.object_type

Line 187: FROM PA_PROJ_STATUS_REMINDER_V conc_view,

183: conc_view.project_number
184: BULK COLLECT INTO x_action_set_line_id_tbl,
185: x_object_name_tbl,
186: x_project_number_tbl
187: FROM PA_PROJ_STATUS_REMINDER_V conc_view,
188: pa_action_sets asets,
189: pa_action_set_lines alines
190: WHERE project_number >= p_project_number_from
191: AND conc_view.object_type = asets.object_type

Line 205: FROM PA_PROJ_STATUS_REMINDER_V conc_view,

201: conc_view.project_number
202: BULK COLLECT INTO x_action_set_line_id_tbl,
203: x_object_name_tbl,
204: x_project_number_tbl
205: FROM PA_PROJ_STATUS_REMINDER_V conc_view,
206: pa_action_sets asets,
207: pa_action_set_lines alines
208: WHERE project_number <= p_project_number_to
209: AND conc_view.object_type = asets.object_type

Line 223: FROM PA_PROJ_STATUS_REMINDER_V conc_view,

219: conc_view.project_number
220: BULK COLLECT INTO x_action_set_line_id_tbl,
221: x_object_name_tbl,
222: x_project_number_tbl
223: FROM PA_PROJ_STATUS_REMINDER_V conc_view,
224: pa_action_sets asets,
225: pa_action_set_lines alines
226: WHERE
227: conc_view.object_type = asets.object_type