APPS.PAY_SA_GOSI_REPORTS dependencies on FF_GLOBALS_F

Line 440: FROM ff_globals_f

436: select actual_termination_date,leaving_reason from per_periods_of_service where person_id = p_person_id;
437: /* Cursor to fetch lower limit of gosi base*/
438: CURSOR get_lower_base(l_effective_date DATE) IS
439: SELECT global_value
440: FROM ff_globals_f
441: WHERE global_name = 'SA_GOSI_BASE_LOWER_LIMIT'
442: AND legislation_code = 'SA'
443: AND business_group_id IS NULL
444: AND l_effective_date BETWEEN effective_start_date

Line 449: FROM ff_globals_f

445: AND effective_end_date;
446: /* Cursor to fetch upper limit of gosi base*/
447: CURSOR get_upper_base(l_effective_date DATE) IS
448: SELECT global_value
449: FROM ff_globals_f
450: WHERE global_name = 'SA_GOSI_BASE_UPPER_LIMIT'
451: AND legislation_code = 'SA'
452: AND business_group_id IS NULL
453: AND l_effective_date BETWEEN effective_start_date

Line 2197: FROM ff_globals_f

2193: --For determining the GOSI reference salary use hazards value and apply the hazards percent
2194: BEGIN
2195: SELECT global_value
2196: INTO l_hazards_pct
2197: FROM ff_globals_f
2198: WHERE legislation_code='SA'
2199: AND business_group_id IS NULL
2200: AND global_name = 'SA_ER_HAZARDS_PCT';
2201: EXCEPTION

Line 2209: FROM ff_globals_f

2205: --Annuities percent is used for determining reference salaries of employees who have only annuities flag enabled
2206: BEGIN
2207: SELECT global_value
2208: INTO l_ee_annuities_pct
2209: FROM ff_globals_f
2210: WHERE legislation_code='SA'
2211: AND business_group_id IS NULL
2212: AND global_name = 'SA_EE_ANNUITIES_PCT';
2213: EXCEPTION

Line 2220: FROM ff_globals_f

2216: END;
2217: BEGIN
2218: SELECT global_value
2219: INTO l_er_annuities_pct
2220: FROM ff_globals_f
2221: WHERE legislation_code='SA'
2222: AND business_group_id IS NULL
2223: AND global_name = 'SA_ER_ANNUITIES_PCT';
2224: EXCEPTION

Line 2869: FROM ff_globals_f

2865: rec_org_id csr_org_hierarchy%rowtype;
2866: /* Cursor to fetch lower limit of gosi base*/
2867: CURSOR get_lower_base(l_effective_date DATE) IS
2868: SELECT global_value
2869: FROM ff_globals_f
2870: WHERE global_name = 'SA_GOSI_BASE_LOWER_LIMIT'
2871: AND legislation_code = 'SA'
2872: AND business_group_id IS NULL
2873: AND l_effective_date BETWEEN effective_start_date

Line 2878: FROM ff_globals_f

2874: AND effective_end_date;
2875: /* Cursor to fetch upper limit of gosi base*/
2876: CURSOR get_upper_base(l_effective_date DATE) IS
2877: SELECT global_value
2878: FROM ff_globals_f
2879: WHERE global_name = 'SA_GOSI_BASE_UPPER_LIMIT'
2880: AND legislation_code = 'SA'
2881: AND business_group_id IS NULL
2882: AND l_effective_date BETWEEN effective_start_date