APPS.JL_BR_AR_CANCEL_BORDERO dependencies on JL_BR_AR_SELECT_CONTROLS

Line 60: FROM jl_br_ar_select_controls

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

Line 252: UPDATE jl_br_ar_select_controls SET

248: cancellation_date = var_cancel_date
249: WHERE selection_control_id = param_select_control
250: AND select_account_id = param_select_account_id;
251:
252: UPDATE jl_br_ar_select_controls SET
253: selection_status = var_selection_status,
254: cancellation_date = var_cancel_date
255: WHERE selection_control_id = param_select_control;
256: commit;