APPS.HXT_TIME_GEN dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 90: per_assignment_status_types ast,

86: hxt_timecards tim,
87: per_people_f ppl,
88: hxt_earning_policies egp,
89: hxt_per_aei_ddf_v aeiv,
90: per_assignment_status_types ast,
91: per_assignments_f asm
92: WHERE ptp.payroll_id = asm.payroll_id
93: AND ast.assignment_status_type_id = asm.assignment_status_type_id
94: AND ast.pay_system_status = 'P' -- Check payroll status

Line 179: per_assignment_status_types ast,

175: hxt_timecards_f tim,
176: per_people_f ppl,
177: hxt_earning_policies egp,
178: hxt_per_aei_ddf_v aeiv,
179: per_assignment_status_types ast,
180: per_assignments_f asm
181: WHERE ptp.payroll_id = asm.payroll_id
182: AND session_date BETWEEN tim.effective_start_date(+)
183: AND tim.effective_end_date(+)