DBA Data[Home] [Help]

APPS.PAY_FR_SICKNESS_CALC dependencies on FF_GLOBALS_F

Line 232: FROM ff_globals_f

228:
229: -- Cursor for fetching global value
230: Cursor csr_global_value(c_global_name VARCHAR2,c_date_earned DATE) IS
231: SELECT global_value
232: FROM ff_globals_f
233: WHERE global_name = c_global_name
234: AND legislation_code = 'FR'
235: AND c_date_earned BETWEEN effective_start_date AND effective_end_date;
236: --

Line 890: FROM ff_globals_f

886:
887: -- Cursor for fetching global value
888: Cursor csr_global_value(c_global_name VARCHAR2,c_date_earned DATE) IS
889: SELECT global_value
890: FROM ff_globals_f
891: WHERE global_name = c_global_name
892: AND legislation_code = 'FR'
893: AND c_date_earned BETWEEN effective_start_date AND effective_end_date;
894:

Line 1398: FROM ff_globals_f

1394:
1395: -- Cursor for fetching global value
1396: Cursor csr_global_value(c_global_name VARCHAR2,c_date_earned DATE) IS
1397: SELECT global_value
1398: FROM ff_globals_f
1399: WHERE global_name = c_global_name
1400: AND legislation_code = 'FR'
1401: AND c_date_earned BETWEEN effective_start_date AND effective_end_date;
1402: --

Line 1954: FROM ff_globals_f

1950: TYPE t_ijss_gross IS TABLE OF t_ijss_gross_rec INDEX BY BINARY_INTEGER;
1951:
1952: Cursor csr_global_value(c_global_name VARCHAR2,c_date_earned DATE) IS
1953: SELECT global_value
1954: FROM ff_globals_f
1955: WHERE global_name = c_global_name
1956: AND legislation_code = 'FR'
1957: AND c_date_earned BETWEEN effective_start_date AND effective_end_date;
1958: