APPS.PA_TASK_ASSIGNMENT_UTILS dependencies on V$PARAMETER

Line 523: FROM v$parameter

519:
520: -- Bug 4153366: Manually seed the statistics for the temporary table.
521: SELECT to_number(value)
522: INTO l_db_block_size
523: FROM v$parameter
524: WHERE name = 'db_block_size';
525:
526: l_num_blocks := 1.25 * (l_num_of_tasks * 75) / l_db_block_size;
527:

Line 3411: FROM v$parameter

3407: l_num_of_tasks := p_src_elem_ver_id_tbl.COUNT;
3408:
3409: SELECT to_number(value)
3410: INTO l_db_block_size
3411: FROM v$parameter
3412: WHERE name = 'db_block_size';
3413:
3414: l_num_blocks := 1.25 * (l_num_of_tasks * 75) / l_db_block_size;
3415: