DBA Data[Home] [Help]

APPS.PAY_SA_SOE dependencies on FF_GLOBALS_F

Line 13: FROM ff_globals_f

9: l_upper_base VARCHAR2(10);
10: /* Cursor to fetch lower limit of gosi base*/
11: CURSOR get_lower_base(l_effective_date DATE) IS
12: SELECT global_value
13: FROM ff_globals_f
14: WHERE global_name = 'SA_GOSI_BASE_LOWER_LIMIT'
15: AND legislation_code = 'SA'
16: AND business_group_id IS NULL
17: AND l_effective_date BETWEEN effective_start_date

Line 22: FROM ff_globals_f

18: AND effective_end_date;
19: /* Cursor to fetch upper limit of gosi base*/
20: CURSOR get_upper_base(l_effective_date DATE) IS
21: SELECT global_value
22: FROM ff_globals_f
23: WHERE global_name = 'SA_GOSI_BASE_UPPER_LIMIT'
24: AND legislation_code = 'SA'
25: AND business_group_id IS NULL
26: AND l_effective_date BETWEEN effective_start_date