DBA Data[Home] [Help]

APPS.PAY_KR_WG_PKG dependencies on FF_GLOBALS_F

Line 163: --select global_value from ff_globals_f where global_name = p_global_name;

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;

Line 165: from ff_globals_f glb

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