FF_GLOBALS_F table BG condition.
I am using the below query to get value for Normal OTL hours.
SELECT global_value
FROM ff_globals_f
WHERE GLOBAL_NAME = 'XXTAD_REGULAR_HOURS'
AND :QUERY_FIND.TIME_DATE BETWEEN effective_start_date
AND effective_end_date
Previously there was only one Business Group. Now a new BG is setup. So do I need to modify this query to include BG condition ?
Thanks,
Bhagath