DBA Data[Home] [Help]

APPS.PAY_IP_STARTUP_UTIL dependencies on HR_S_REPORT_FORMAT_MAPPINGS_F

Line 626: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_REPORT_FORMAT_MAPPINGS_F',NULL);

622: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_MAGNETIC_BLOCKS',NULL);
623: DELETE HR_S_MAGNETIC_BLOCKS;
624: COMMIT;
625:
626: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_REPORT_FORMAT_MAPPINGS_F',NULL);
627: DELETE HR_S_REPORT_FORMAT_MAPPINGS_F;
628: COMMIT;
629:
630: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_US_CITY_TAX_INFO_F',NULL);

Line 627: DELETE HR_S_REPORT_FORMAT_MAPPINGS_F;

623: DELETE HR_S_MAGNETIC_BLOCKS;
624: COMMIT;
625:
626: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_REPORT_FORMAT_MAPPINGS_F',NULL);
627: DELETE HR_S_REPORT_FORMAT_MAPPINGS_F;
628: COMMIT;
629:
630: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_US_CITY_TAX_INFO_F',NULL);
631: DELETE HR_S_US_CITY_TAX_INFO_F;

Line 1467: INSERT INTO hr_s_report_format_mappings_f

1463: FOR rec IN c_get_report_format_mappings LOOP
1464: fnd_file.put_line(fnd_file.LOG,'Moving report_format_mappings to shadow table');
1465: fnd_file.put_line(fnd_file.OUTPUT,'Moving report_format_mappings to shadow table');
1466:
1467: INSERT INTO hr_s_report_format_mappings_f
1468: ( report_type ,
1469: report_qualifier ,
1470: report_format ,
1471: effective_start_date ,

Line 1862: UPDATE hr_s_report_format_mappings_f

1858: WHERE legislation_code = 'ZZ';
1859:
1860: --Updating Report Format Mapping
1861:
1862: UPDATE hr_s_report_format_mappings_f
1863: SET report_qualifier = p_legislation_code
1864: WHERE report_qualifier = 'ZZ';
1865:
1866: --Updating Balance Categories