APPS.PA_TASK_ASSIGNMENTS_PUB dependencies on V$PARAMETER

Line 2692: FROM v$parameter

2688: l_num_of_tasks := l_task_elem_version_id_tbl.COUNT;
2689:
2690: SELECT to_number(value)
2691: INTO l_db_block_size
2692: FROM v$parameter
2693: WHERE name = 'db_block_size';
2694:
2695: l_num_blocks := 1.25 * (l_num_of_tasks * 75) / l_db_block_size;
2696:

Line 6125: FROM v$parameter

6121: l_num_of_tasks := l_task_elem_version_id_tbl.COUNT;
6122:
6123: SELECT to_number(value)
6124: INTO l_db_block_size
6125: FROM v$parameter
6126: WHERE name = 'db_block_size';
6127:
6128: l_num_blocks := 1.25 * (l_num_of_tasks * 75) / l_db_block_size;
6129: