159: and TPERIOD.time_period_id = PACTION.time_period_id
160: and TPTYPE.period_type = TPERIOD.period_type;
161:
162: cursor csr_get_global_values(p_global_name IN varchar2, p_process_date in date) is
163: --select global_value from ff_globals_f where global_name = p_global_name;
164: select glb.global_value
165: from ff_globals_f glb
166: where glb.global_name = p_global_name
167: and p_process_date between glb.effective_start_date and glb.effective_end_date;
161:
162: cursor csr_get_global_values(p_global_name IN varchar2, p_process_date in date) is
163: --select global_value from ff_globals_f where global_name = p_global_name;
164: select glb.global_value
165: from ff_globals_f glb
166: where glb.global_name = p_global_name
167: and p_process_date between glb.effective_start_date and glb.effective_end_date;
168: --
169: -- Local Procedures