APPS.PAY_1099R_DATA dependencies on PAY_MAGNETIC_BLOCKS

Line 1267: FROM pay_magnetic_blocks pmb,

1263: hr_utility.trace(' Deleting magnetic records...');
1264: DELETE FROM pay_magnetic_records
1265: WHERE magnetic_block_id IN
1266: (SELECT pmb.magnetic_block_id
1267: FROM pay_magnetic_blocks pmb,
1268: pay_report_format_mappings_f pfm
1269: WHERE pmb.report_format = pfm.report_format
1270: AND pmb.report_format = lt_report_format(l_ccount)
1271: AND pfm.report_category = 'RT');

Line 1274: DELETE FROM pay_magnetic_blocks pmb

1270: AND pmb.report_format = lt_report_format(l_ccount)
1271: AND pfm.report_category = 'RT');
1272: --
1273: hr_utility.trace(' Deleting blocks...');
1274: DELETE FROM pay_magnetic_blocks pmb
1275: WHERE pmb.report_format in
1276: (SELECT pfm.report_format
1277: FROM pay_report_format_mappings_f pfm
1278: WHERE pfm.report_format = lt_report_format(l_ccount)