APPS.PA_TASK_ASSIGNMENT_UTILS dependencies on V$PARAMETER

Line 588: FROM v$parameter

584:
585: -- Bug 4153366: Manually seed the statistics for the temporary table.
586: SELECT to_number(value)
587: INTO l_db_block_size
588: FROM v$parameter
589: WHERE name = 'db_block_size';
590:
591: l_num_blocks := 1.25 * (l_num_of_tasks * 75) / l_db_block_size;
592:

Line 3526: FROM v$parameter

3522: l_num_of_tasks := p_src_elem_ver_id_tbl.COUNT;
3523:
3524: SELECT to_number(value)
3525: INTO l_db_block_size
3526: FROM v$parameter
3527: WHERE name = 'db_block_size';
3528:
3529: l_num_blocks := 1.25 * (l_num_of_tasks * 75) / l_db_block_size;
3530: