APPS.PAY_MGR_SHD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 84

    select
		formula_id,
	magnetic_block_id,
	next_block_id,
	last_run_executed_mode,
	overflow_mode,
	sequence,
	frequency	,
        action_level,block_label,block_row_label,xml_proc_name
    from	pay_magnetic_records
    where	magnetic_block_id = p_magnetic_block_id
  and   sequence = p_sequence;

Line: 160

    select 	formula_id,
	magnetic_block_id,
	next_block_id,
	last_run_executed_mode,
	overflow_mode,
	sequence,
	frequency	,
        action_level,block_label,block_row_label,xml_proc_name
    from	pay_magnetic_records
    where	magnetic_block_id = p_magnetic_block_id
  and   sequence = p_sequence
    for	update nowait;