DBA Data[Home] [Help]

APPS.PY_NO_TAX_CARD dependencies on FF_GLOBALS_F

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

584: -- p_legislation_code Yes VARCHAR2 Legislation Code
585: -- p_effective_date Yes DATE Effective date
586: --
587: -- Post Success:
588: -- The value of the global of type FF_GLOBALS_F.GLOBAL_VALUE is returned
589: --
590: -- Post Failure:
591: -- An error is raised
592: --

Line 602: RETURN ff_globals_f.global_value%TYPE IS

598: FUNCTION get_global_value(
599: p_global_name VARCHAR2,
600: p_legislation_code VARCHAR2,
601: p_effective_date DATE)
602: RETURN ff_globals_f.global_value%TYPE IS
603:
604: CURSOR csr_globals IS
605: SELECT global_value
606: FROM ff_globals_f

Line 606: FROM ff_globals_f

602: RETURN ff_globals_f.global_value%TYPE IS
603:
604: CURSOR csr_globals IS
605: SELECT global_value
606: FROM ff_globals_f
607: WHERE global_name = p_global_name
608: AND legislation_code = p_legislation_code
609: AND business_group_id IS NULL
610: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line 612: l_global_value ff_globals_f.global_value%TYPE;

608: AND legislation_code = p_legislation_code
609: AND business_group_id IS NULL
610: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
611:
612: l_global_value ff_globals_f.global_value%TYPE;
613: l_proc varchar2(72) := g_package||'get_global_value';
614:
615: BEGIN
616: if g_debug then