DBA Data[Home] [Help]

APPS.PAY_CAL_BUS dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 248: from pay_cost_allocation_keyflex ckf

244: -- Cursor to check that the flexfield combination exists.
245: --
246: cursor csr_combination_exists is
247: select 'Y'
248: from pay_cost_allocation_keyflex ckf
249: where ckf.cost_allocation_keyflex_id = p_cost_allocation_keyflex_id
250: and p_effective_date between nvl(ckf.start_date_active,p_effective_date)
251: and nvl(ckf.end_date_active,p_effective_date)
252: and ckf.enabled_flag = 'Y';