13: --
14: --Cursor to fetch Increased Index
15: CURSOR csr_increased_index IS
16: SELECT increased_index
17: FROM pqh_fr_global_indices_f
18: WHERE gross_index = p_gross_index
19: AND type_of_record = 'IND' -- for indices
20: AND p_effective_date BETWEEN effective_start_date and effective_end_date;
21: --
19: AND type_of_record = 'IND' -- for indices
20: AND p_effective_date BETWEEN effective_start_date and effective_end_date;
21: --
22: --Variable Declarations.
23: l_increased_index PQH_FR_GLOBAL_INDICES_F.increased_index%TYPE;
24: l_proc VARCHAR2(72) := g_package||'get_increased_index';
25: --
26: BEGIN
27: --