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 1995: from ff_globals_f

1991: and pai.action_information_category = 'MILEAGE ALLOWANCE AND PPAYMENT';
1992:
1993: cursor get_threshold_val (c_rep_run in varchar2) is
1994: select to_number(global_value)
1995: from ff_globals_f
1996: where global_name = 'P11D_LOW_INT_LOAN_THRESHOLD'
1997: and to_date('05-04-' || c_rep_run,'DD-MM-YYYY') between effective_start_date and effective_end_date;
1998:
1999: cursor get_emp_ref is

Line 3281: from ff_globals_f

3277: p_token_value => l_rep_run);
3278:
3279: select to_number(global_value)
3280: into l_car_max_price
3281: from ff_globals_f
3282: where global_name = 'NI_CAR_MAX_PRICE'
3283: and to_date('05-04-' || l_rep_run,'DD-MM-YYYY') between effective_start_date and effective_end_date;
3284:
3285: l_loop_count := 0;

Line 4803: from ff_globals_f

4799: else
4800: -- Fetch the minimum outstanding
4801: select to_number(global_value)
4802: into l_loan_threshold
4803: from ff_globals_f
4804: where global_name = 'P11D_LOW_INT_LOAN_THRESHOLD'
4805: and to_date('05-04-' || l_rep_run,'DD-MM-YYYY') between effective_start_date and effective_end_date;
4806: end if;
4807: