APPS.PSP_ENC_CREATE_LINES dependencies on FND_STATS

Line 7540: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_CONTROLS');

7536: AND pesl.payroll_id = pepa.payroll_id
7537: AND pesl.status_code = 'N'
7538: AND pesl.superceded_line_id IS NOT NULL);
7539:
7540: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_CONTROLS');
7541: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_LINES');
7542: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');
7543: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed Gather Statistics');
7544:

Line 7541: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_LINES');

7537: AND pesl.status_code = 'N'
7538: AND pesl.superceded_line_id IS NOT NULL);
7539:
7540: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_CONTROLS');
7541: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_LINES');
7542: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');
7543: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed Gather Statistics');
7544:
7545: DELETE FROM psp_enc_controls pec

Line 7542: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');

7538: AND pesl.superceded_line_id IS NOT NULL);
7539:
7540: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_CONTROLS');
7541: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_LINES');
7542: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');
7543: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed Gather Statistics');
7544:
7545: DELETE FROM psp_enc_controls pec
7546: WHERE pec.payroll_action_id = p_payroll_action_id