APPS.PSP_ENC_CREATE_LINES dependencies on FND_STATS

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

7848: AND pesl.payroll_id = pepa.payroll_id
7849: AND pesl.status_code = 'N'
7850: AND pesl.superceded_line_id IS NOT NULL);
7851:
7852: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_CONTROLS');
7853: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_LINES');
7854: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');
7855: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed Gather Statistics');
7856:

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

7849: AND pesl.status_code = 'N'
7850: AND pesl.superceded_line_id IS NOT NULL);
7851:
7852: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_CONTROLS');
7853: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_LINES');
7854: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');
7855: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed Gather Statistics');
7856:
7857: DELETE FROM psp_enc_controls pec

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

7850: AND pesl.superceded_line_id IS NOT NULL);
7851:
7852: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_CONTROLS');
7853: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_LINES');
7854: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');
7855: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed Gather Statistics');
7856:
7857: DELETE FROM psp_enc_controls pec
7858: WHERE pec.payroll_action_id = p_payroll_action_id