APPS.PAY_IE_PENSIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 13: FROM per_all_people_f p, per_all_assignments_f a

9: l_age number;
10: l_percent number;
11: BEGIN
12: SELECT DISTINCT floor(months_between(p_date_earned,p.date_of_birth)/12) into l_age
13: FROM per_all_people_f p, per_all_assignments_f a
14: WHERE a.person_id=p.person_id AND a.assignment_id=p_assgt_id;
15: IF prsa2 = 0 THEN
16: SELECT i.value INTO l_percent
17: FROM pay_user_tables t, pay_user_columns c, pay_user_rows_f r, pay_user_column_instances_f i