DBA Data[Home] [Help]

APPS.PAY_DK_STATSR_PKG dependencies on FF_GLOBALS_F

Line 137: RETURN ff_globals_f.global_value%TYPE IS

133:
134: FUNCTION GET_GLOBAL_VALUE(
135: p_global_name VARCHAR2,
136: p_effective_date DATE)
137: RETURN ff_globals_f.global_value%TYPE IS
138:
139: CURSOR csr_globals IS
140: SELECT global_value
141: FROM ff_globals_f

Line 141: FROM ff_globals_f

137: RETURN ff_globals_f.global_value%TYPE IS
138:
139: CURSOR csr_globals IS
140: SELECT global_value
141: FROM ff_globals_f
142: WHERE global_name = p_global_name
143: AND legislation_code = 'DK'
144: AND p_effective_date BETWEEN effective_start_date AND effective_END_date;
145:

Line 146: l_global_value ff_globals_f.global_value%TYPE;

142: WHERE global_name = p_global_name
143: AND legislation_code = 'DK'
144: AND p_effective_date BETWEEN effective_start_date AND effective_END_date;
145:
146: l_global_value ff_globals_f.global_value%TYPE;
147: l_proc varchar2(72) := g_package||'get_global_value';
148:
149: BEGIN
150: IF g_debug THEN