DBA Data[Home] [Help]

APPS.HXT_TIM_COL_UTIL dependencies on PER_ALL_ASSIGNMENTS_F

Line 155: per_all_assignments_f asm,

151:
152: SELECT MAX('Y') --5574629
153: INTO l_exists
154: FROM pay_element_links_f ell,
155: per_all_assignments_f asm,
156: hxt_pay_element_types_f_ddf_v eltv
157: WHERE asm.assignment_id = p_asg_id
158: AND p_date_worked BETWEEN asm.effective_start_date
159: AND asm.effective_end_date