APPS.PAY_CALC_HOURS_WORKED dependencies on PER_ALL_ASSIGNMENTS_F

Line 157: FROM per_all_assignments_f ASSIGN

153: CURSOR get_asg_hours_freq(p_date_earned date,
154: p_assignment_id number)IS
155: SELECT hr_general.decode_lookup('FREQUENCY', ASSIGN.frequency)
156: ,ASSIGN.normal_hours
157: FROM per_all_assignments_f ASSIGN
158: where date_earned
159: BETWEEN ASSIGN.effective_start_date
160: AND ASSIGN.effective_end_date
161: and ASSIGN.assignment_id = p_assignment_id;