APPS.PAY_MULTIASG dependencies on PER_ALL_ASSIGNMENTS_F

Line 268: per_all_assignments_f ASSIGN,

264:
265: CURSOR asg_hours (p_assign_id NUMBER) IS
266: SELECT ASSIGN.normal_hours
267: FROM
268: per_all_assignments_f ASSIGN,
269: hr_lookups HR3
270: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
271: AND ASSIGN.effective_end_date
272: AND ASSIGN.assignment_id = p_assign_id

Line 308: per_all_assignments_f ASSIGN,

304:
305: CURSOR freq_code (p_assign_id NUMBER) IS
306: SELECT HR3.lookup_code
307: FROM
308: per_all_assignments_f ASSIGN,
309: hr_lookups HR3
310: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
311: AND ASSIGN.effective_end_date
312: AND ASSIGN.assignment_id = p_assign_id