APPS.PAY_CALC_HOURS_WORKED dependencies on PER_ALL_ASSIGNMENTS_F

Line 160: FROM per_all_assignments_f ASSIGN

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