APPS.PAY_IE_PAYE_PKG dependencies on FF_GLOBALS_F

Line 902: FROM ff_globals_f,fnd_sessions ses

898: RETURN number
899: is
900: CURSOR get_global_val(l_name IN VARCHAR2) IS
901: SELECT global_value
902: FROM ff_globals_f,fnd_sessions ses
903: WHERE global_name = l_name
904: AND ses.session_id = userenv('SESSIONID')
905: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
906: --

Line 964: FROM ff_globals_f,fnd_sessions ses

960: RETURN number
961: is
962: CURSOR get_global_val(l_name IN VARCHAR2) IS
963: SELECT global_value
964: FROM ff_globals_f,fnd_sessions ses
965: WHERE global_name = l_name
966: AND ses.session_id = userenv('SESSIONID')
967: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
968: --

Line 1031: FROM ff_globals_f,fnd_sessions ses

1027: RETURN number
1028: is
1029: CURSOR get_global_val(l_name IN VARCHAR2) IS
1030: SELECT global_value
1031: FROM ff_globals_f,fnd_sessions ses
1032: WHERE global_name = l_name
1033: AND ses.session_id = userenv('SESSIONID')
1034: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
1035: --

Line 1094: FROM ff_globals_f,fnd_sessions ses

1090: RETURN number
1091: is
1092: CURSOR get_global_val(l_name IN VARCHAR2) IS
1093: SELECT global_value
1094: FROM ff_globals_f,fnd_sessions ses
1095: WHERE global_name = l_name
1096: AND ses.session_id = userenv('SESSIONID')
1097: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
1098: --

Line 1281: FROM ff_globals_f

1277: and paa.effective_end_date;
1278:
1279: CURSOR get_global_val(l_name IN VARCHAR2,p_effective_date date) IS
1280: SELECT global_value
1281: FROM ff_globals_f
1282: WHERE global_name = l_name
1283: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1284:
1285: Cursor csr_freq(p_payroll_id number,p_effective_date date) IS