DBA Data[Home] [Help]

APPS.PAY_SA_ARCHIVE dependencies on FF_GLOBALS_F

Line 978: FROM ff_globals_f

974:
975: /* Cursor to fetch lower limit of gosi base*/
976: CURSOR get_lower_base IS
977: SELECT global_value
978: FROM ff_globals_f
979: WHERE global_name = 'SA_GOSI_BASE_LOWER_LIMIT'
980: AND legislation_code = 'SA'
981: AND business_group_id IS NULL
982: AND p_pay_date_earned BETWEEN effective_start_date

Line 988: FROM ff_globals_f

984:
985: /* Cursor to fetch upper limit of gosi base*/
986: CURSOR get_upper_base IS
987: SELECT global_value
988: FROM ff_globals_f
989: WHERE global_name = 'SA_GOSI_BASE_UPPER_LIMIT'
990: AND legislation_code = 'SA'
991: AND business_group_id IS NULL
992: AND p_pay_date_earned BETWEEN effective_start_date