DBA Data[Home] [Help]

APPS.HXT_TIM_COL_UTIL dependencies on HXT_PER_AEI_DDF_V

Line 118: hxt_per_aei_ddf_v pafv

114: /* No Earning Policy override, get EP for current assignment. */
115: SELECT ep.id
116: INTO o_earn_pol_id
117: FROM hxt_earning_policies ep,
118: hxt_per_aei_ddf_v pafv
119: WHERE pafv.assignment_id = i_assignment_id
120: AND i_date_worked BETWEEN pafv.effective_start_date
121: AND pafv.effective_end_date
122: AND pafv.hxt_earning_policy = ep.id