APPS.HXT_TIME_GEN dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 84: per_assignment_status_types ast,

80: hxt_timecards tim,
81: per_people_f ppl,
82: hxt_earning_policies egp,
83: hxt_per_aei_ddf_v aeiv,
84: per_assignment_status_types ast,
85: per_assignments_f asm
86: WHERE ptp.payroll_id = asm.payroll_id
87: AND ast.assignment_status_type_id = asm.assignment_status_type_id
88: AND ast.pay_system_status = 'P' -- Check payroll status