APPS.PAY_DK_ABSR_PKG dependencies on FF_GLOBALS_F

Line 136: RETURN ff_globals_f.global_value%TYPE IS

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

Line 140: FROM ff_globals_f

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

Line 145: l_global_value ff_globals_f.global_value%TYPE;

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

Line 703: from ff_globals_f

699:
700: cursor cur_global(p_effective_date DATE)
701: IS
702: select global_value
703: from ff_globals_f
704: where
705: global_name = 'DK_HOURS_IN_DAY'
706: AND p_effective_date between effective_start_date AND effective_end_date;
707:

Line 708: l_global_value ff_globals_f.global_value%type;

704: where
705: global_name = 'DK_HOURS_IN_DAY'
706: AND p_effective_date between effective_start_date AND effective_end_date;
707:
708: l_global_value ff_globals_f.global_value%type;
709:
710: -- Variable Declarations
711:
712: l_count NUMBER := 0;