DBA Data[Home] [Help]

APPS.PY_DK_TAX_CARD dependencies on FF_GLOBALS_F

Line 602: -- The value of the global of type FF_GLOBALS_F.GLOBAL_VALUE is returned

598: -- p_legislation_code Yes VARCHAR2 Legislation Code
599: -- p_effective_date Yes DATE Effective date
600: --
601: -- Post Success:
602: -- The value of the global of type FF_GLOBALS_F.GLOBAL_VALUE is returned
603: --
604: -- Post Failure:
605: -- An error is raised
606: --

Line 616: RETURN ff_globals_f.global_value%TYPE IS

612: FUNCTION get_global_value(
613: p_global_name VARCHAR2,
614: p_legislation_code VARCHAR2,
615: p_effective_date DATE)
616: RETURN ff_globals_f.global_value%TYPE IS
617:
618: CURSOR csr_globals IS
619: SELECT global_value
620: FROM ff_globals_f

Line 620: FROM ff_globals_f

616: RETURN ff_globals_f.global_value%TYPE IS
617:
618: CURSOR csr_globals IS
619: SELECT global_value
620: FROM ff_globals_f
621: WHERE global_name = p_global_name
622: AND legislation_code = p_legislation_code
623: AND business_group_id IS NULL
624: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line 626: l_global_value ff_globals_f.global_value%TYPE;

622: AND legislation_code = p_legislation_code
623: AND business_group_id IS NULL
624: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
625:
626: l_global_value ff_globals_f.global_value%TYPE;
627: l_proc varchar2(72) := g_package||'get_global_value';
628:
629: BEGIN
630: if g_debug then