DBA Data[Home] [Help]

APPS.HXT_TIME_COLLECTION dependencies on PER_ALL_ASSIGNMENTS_F

Line 43: per_all_assignments_f asm

39: asm.effective_end_date, asmv.hxt_rotation_plan, egp.hcl_id
40: FROM hxt_earning_policies egp,
41: hxt_per_aei_ddf_v asmv,
42: per_assignment_status_types ast,
43: per_all_assignments_f asm
44: WHERE c_person_id = asm.person_id
45: AND asm.primary_flag = 'Y'
46: AND TRUNC (c_date_worked) BETWEEN TRUNC (asm.effective_start_date)
47: AND TRUNC (asm.effective_end_date)