DBA Data[Home] [Help]

APPS.HXC_FF_DICT dependencies on PAY_ACCRUAL_PLANS

Line 302: , pay_accrual_plans pap

298: CURSOR csr_get_time_category_id IS
299: SELECT htc.time_category_id
300: , htc.time_category_name
301: FROM hxc_time_categories htc
302: , pay_accrual_plans pap
303: WHERE
304: pap.accrual_plan_id = p_accrual_plan_id
305: AND (
306: ( htc.time_category_name = SUBSTR('OTL_DEC_'||pap.accrual_plan_name,1,90))