DBA Data[Home] [Help]

APPS.PAY_SA_ARCHIVE dependencies on FF_GLOBALS_F

Line 966: FROM ff_globals_f

962:
963: /* Cursor to fetch lower limit of gosi base*/
964: CURSOR get_lower_base IS
965: SELECT global_value
966: FROM ff_globals_f
967: WHERE global_name = 'SA_GOSI_BASE_LOWER_LIMIT'
968: AND legislation_code = 'SA'
969: AND business_group_id IS NULL
970: AND p_pay_date_earned BETWEEN effective_start_date

Line 976: FROM ff_globals_f

972:
973: /* Cursor to fetch upper limit of gosi base*/
974: CURSOR get_upper_base IS
975: SELECT global_value
976: FROM ff_globals_f
977: WHERE global_name = 'SA_GOSI_BASE_UPPER_LIMIT'
978: AND legislation_code = 'SA'
979: AND business_group_id IS NULL
980: AND p_pay_date_earned BETWEEN effective_start_date