APPS.PAY_1099R_DATA dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 1268: pay_report_format_mappings_f pfm

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');
1272: --

Line 1277: FROM pay_report_format_mappings_f pfm

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)
1279: AND pfm.report_category = 'RT');
1280: --
1281: hr_utility.trace(' Deleting report format mappings...');

Line 1282: DELETE FROM pay_report_format_mappings_f rfm

1278: WHERE pfm.report_format = lt_report_format(l_ccount)
1279: AND pfm.report_category = 'RT');
1280: --
1281: hr_utility.trace(' Deleting report format mappings...');
1282: DELETE FROM pay_report_format_mappings_f rfm
1283: WHERE rfm.report_format = lt_report_format(l_ccount)
1284: AND report_category = 'RT';
1285:
1286: END LOOP;

Line 1297: INSERT INTO pay_report_format_mappings_f

1293: --
1294: FOR l_st_count IN lt_rptq_first(l_ccount)..lt_rptq_last(l_ccount) LOOP
1295: hr_utility.trace(' --Inserting '|| lt_report_qualifier(l_st_count)
1296: || ' report qualifier...');
1297: INSERT INTO pay_report_format_mappings_f
1298: ( report_type,
1299: report_qualifier,
1300: report_format,
1301: report_category,