APPS.PA_TASK_ASSIGNMENTS_PUB dependencies on V$PARAMETER

Line 2489: FROM v$parameter

2485: l_num_of_tasks := l_task_elem_version_id_tbl.COUNT;
2486:
2487: SELECT to_number(value)
2488: INTO l_db_block_size
2489: FROM v$parameter
2490: WHERE name = 'db_block_size';
2491:
2492: l_num_blocks := 1.25 * (l_num_of_tasks * 75) / l_db_block_size;
2493:

Line 5477: FROM v$parameter

5473: l_num_of_tasks := l_task_elem_version_id_tbl.COUNT;
5474:
5475: SELECT to_number(value)
5476: INTO l_db_block_size
5477: FROM v$parameter
5478: WHERE name = 'db_block_size';
5479:
5480: l_num_blocks := 1.25 * (l_num_of_tasks * 75) / l_db_block_size;
5481: