DBA Data[Home] [Help]

APPS.HXC_FF_DICT dependencies on PAY_ACCRUAL_PLANS

Line 301: , pay_accrual_plans pap

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