APPS.JL_BR_AR_CANCEL_BORDERO dependencies on JL_BR_AR_SELECT_CONTROLS

Line 61: FROM jl_br_ar_select_controls

57: FOR UPDATE NOWAIT;
58:
59: CURSOR check2 IS
60: SELECT selection_control_id
61: FROM jl_br_ar_select_controls
62: WHERE selection_control_id = param_select_control
63: FOR UPDATE NOWAIT;
64:
65: CURSOR c1 IS

Line 265: UPDATE jl_br_ar_select_controls SET

261: cancellation_date = var_cancel_date
262: WHERE selection_control_id = param_select_control
263: AND select_account_id = param_select_account_id;
264:
265: UPDATE jl_br_ar_select_controls SET
266: selection_status = var_selection_status,
267: cancellation_date = var_cancel_date
268: WHERE selection_control_id = param_select_control;
269: --commit;