APPS.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on FF_GLOBALS_F

Line 348: l_global_value ff_globals_f.global_value%type;

344:
345: function get_global_value(p_global_name in VARCHAR2,
346: p_benefit_end_date in VARCHAR2 default '0001/01/01 00:00:00') return VARCHAR2
347: is
348: l_global_value ff_globals_f.global_value%type;
349: cursor csr_get_value
350: is
351: select global_value
352: from ff_globals_f

Line 352: from ff_globals_f

348: l_global_value ff_globals_f.global_value%type;
349: cursor csr_get_value
350: is
351: select global_value
352: from ff_globals_f
353: where legislation_code = 'GB'
354: and GLOBAL_NAME = p_global_name
355: and fnd_date.canonical_to_date(p_benefit_end_date)
356: between effective_start_date and effective_end_date;

Line 2784: from ff_globals_f

2780: p_token_value => l_rep_run);
2781:
2782: select to_number(global_value)
2783: into l_car_max_price
2784: from ff_globals_f
2785: where global_name = 'NI_CAR_MAX_PRICE'
2786: and to_date('05-04-' || l_rep_run,'DD-MM-YYYY') between effective_start_date and effective_end_date;
2787:
2788: l_loop_count := 0;

Line 4126: from ff_globals_f

4122: else
4123: -- Fetch the minimum outstanding
4124: select to_number(global_value)
4125: into l_loan_threshold
4126: from ff_globals_f
4127: where global_name = 'P11D_LOW_INT_LOAN_THRESHOLD'
4128: and to_date('05-04-' || l_rep_run,'DD-MM-YYYY') between effective_start_date and effective_end_date;
4129: end if;
4130: