APPS.PAY_MAG_TAPE SQL Statements

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

Line: 49

    select blob_file_fragment
    into g_blob_value
    from pay_file_details
    where file_detail_id = pay_mag_tape.g_blob_file_id;

Line: 92

select grp.legislation_code,prg.report_group_id
into leg_code ,rep_grp
from pay_payroll_actions ppa,pay_report_groups prg,per_business_groups_perf grp
where ppa.payroll_action_id=pactid
and grp.business_group_id=ppa.business_group_id
and  pay_core_utils.get_parameter('REP_GROUP', ppa.legislative_parameters)=prg.short_name;

Line: 101

select procedure_name
into proc_name
from pay_report_magnetic_procedures
where  magnetic_block_id=mag_block
and sequence=seq
and rep_grp=report_group_id
and legislation_code=leg_code;