APPS.PSP_TEMPLATE_SELECTION dependencies on FND_STATS

Line 326: FND_STATS.GATHER_TABLE_STATS(ownname=>'PSP', tabname=>'PSP_SELECTED_PERSONS_T');

322: ---select count(*) into l_count_x from psp_selected_persons_t where request_id
323: ---= p_request_id;
324: ---fnd_file.put_line(fnd_file.log,' after initial person list ');
325:
326: FND_STATS.GATHER_TABLE_STATS(ownname=>'PSP', tabname=>'PSP_SELECTED_PERSONS_T');
327:
328: hr_utility.trace( 'get_template_selection-> After prepare_initial_person_list ' );
329: If g_lookup_code <> 'ALL' then
330:

Line 358: FND_STATS.GATHER_TABLE_STATS(ownname=>'PSP', tabname=>'PSP_SELECTED_PERSONS_T');

354: p_business_group_id => l_business_group_id,
355: p_set_of_books_id => l_set_of_books_id);
356: hr_utility.trace('get_template_selection-> After prepare_initial_asg_list');
357:
358: FND_STATS.GATHER_TABLE_STATS(ownname=>'PSP', tabname=>'PSP_SELECTED_PERSONS_T');
359:
360: IF g_lookup_code <> 'ALL' THEN
361: prune_initial_asg_list (p_request_id => p_request_id,
362: p_effort_start => l_effort_start,

Line 393: FND_STATS.GATHER_TABLE_STATS(ownname=>'PSP', tabname=>'PSP_SELECTED_PERSONS_T');

389:
390: If l_count > 0 then
391:
392:
393: FND_STATS.GATHER_TABLE_STATS(ownname=>'PSP', tabname=>'PSP_SELECTED_PERSONS_T');
394: -- fnd_file.put_line(fnd_file.log,' after gather stats ');
395:
396: end if;
397: EXCEPTION