DBA Data[Home] [Help]

APPS.HXT_GEN_AAI dependencies on HXT_HOUR_DEDUCT_POLICIES

Line 195: FROM hxt_hour_deduct_policies hdp

191:
192: /* Cursor to check that Hour Deduction policy and Assignment are compatible */
193: CURSOR chk_hour_deduct_policy IS
194: SELECT 'compatible'
195: FROM hxt_hour_deduct_policies hdp
196: WHERE p_effective_start_date between hdp.date_from
197: and nvl(hdp.date_to,p_effective_start_date)
198: AND nvl(hdp.business_group_id, nvl(asg_bus_grp_id, -99))
199: = nvl(asg_bus_grp_id, -98)