DBA Data[Home] [Help]

APPS.PAY_ZA_UIF_REFUND_MARCH_2008 dependencies on FF_GLOBALS_F

Line 58: l_glb_value ff_globals_f.global_value%type;

54: -----------------------------------------------------------------------------------------
55: ----------------- function to set global values --------------------------------------
56: -----------------------------------------------------------------------------------------
57: function get_global_value (p_global_name varchar2, p_effective_date date) return varchar2 is
58: l_glb_value ff_globals_f.global_value%type;
59: begin
60: select global_value
61: into l_glb_value
62: from ff_globals_f

Line 62: from ff_globals_f

58: l_glb_value ff_globals_f.global_value%type;
59: begin
60: select global_value
61: into l_glb_value
62: from ff_globals_f
63: where global_name = p_global_name
64: and p_effective_date between effective_start_date
65: and effective_end_date
66: and legislation_code = 'ZA';