APPS.PAY_IE_PAYE_PKG dependencies on FF_GLOBALS_F

Line 770: FROM ff_globals_f,fnd_sessions ses

766: RETURN number
767: is
768: CURSOR get_global_val(l_name IN VARCHAR2) IS
769: SELECT global_value
770: FROM ff_globals_f,fnd_sessions ses
771: WHERE global_name = l_name
772: AND ses.session_id = userenv('SESSIONID')
773: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
774: --

Line 832: FROM ff_globals_f,fnd_sessions ses

828: RETURN number
829: is
830: CURSOR get_global_val(l_name IN VARCHAR2) IS
831: SELECT global_value
832: FROM ff_globals_f,fnd_sessions ses
833: WHERE global_name = l_name
834: AND ses.session_id = userenv('SESSIONID')
835: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
836: --

Line 899: FROM ff_globals_f,fnd_sessions ses

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

Line 962: FROM ff_globals_f,fnd_sessions ses

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

Line 1110: FROM ff_globals_f

1106: and paa.effective_end_date;
1107:
1108: CURSOR get_global_val(l_name IN VARCHAR2,p_effective_date date) IS
1109: SELECT global_value
1110: FROM ff_globals_f
1111: WHERE global_name = l_name
1112: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1113:
1114: Cursor csr_freq(p_payroll_id number,p_effective_date date) IS