APPS.PAY_MGB_SHD SQL Statements

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

Line: 68

    select
        magnetic_block_id,
        block_name,
        main_block_flag,
        report_format,
        cursor_name,
        no_column_returned
    from        pay_magnetic_blocks
    where       magnetic_block_id = p_magnetic_block_id;

Line: 138

    select      magnetic_block_id,
        block_name,
        main_block_flag,
        report_format,
        cursor_name,
        no_column_returned
    from        pay_magnetic_blocks
    where       magnetic_block_id = p_magnetic_block_id
    for update nowait;

Line: 235

       select distinct magnetic_block_id
         from pay_magnetic_blocks
        where block_name = p_block_name
          and report_format = p_report_format;