DBA Data[Home] [Help]

APPS.PY_SE_TAX_CARD dependencies on FF_GLOBALS_F

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

706: -- p_legislation_code Yes VARCHAR2 Legislation Code
707: -- p_effective_date Yes DATE Effective date
708: --
709: -- Post Success:
710: -- The value of the global of type FF_GLOBALS_F.GLOBAL_VALUE is returned
711: --
712: -- Post Failure:
713: -- An error is raised
714: --

Line 724: RETURN ff_globals_f.global_value%TYPE IS

720: FUNCTION get_global_value(
721: p_global_name VARCHAR2,
722: p_legislation_code VARCHAR2,
723: p_effective_date DATE)
724: RETURN ff_globals_f.global_value%TYPE IS
725:
726: CURSOR csr_globals IS
727: SELECT global_value
728: FROM ff_globals_f

Line 728: FROM ff_globals_f

724: RETURN ff_globals_f.global_value%TYPE IS
725:
726: CURSOR csr_globals IS
727: SELECT global_value
728: FROM ff_globals_f
729: WHERE global_name = p_global_name
730: AND legislation_code = p_legislation_code
731: AND business_group_id IS NULL
732: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line 734: l_global_value ff_globals_f.global_value%TYPE;

730: AND legislation_code = p_legislation_code
731: AND business_group_id IS NULL
732: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
733:
734: l_global_value ff_globals_f.global_value%TYPE;
735: l_proc varchar2(72) := g_package||'get_global_value';
736:
737: BEGIN
738: if g_debug then