DBA Data[Home] [Help]

APPS.PQH_FR_SPEED dependencies on PQH_FR_GLOBAL_INDICES_F

Line 17: FROM pqh_fr_global_indices_f

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: --

Line 23: l_increased_index PQH_FR_GLOBAL_INDICES_F.increased_index%TYPE;

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: --