APPS.PQP_BUDGET_MAINTENANCE dependencies on PER_ALL_PEOPLE_F

Line 12: ,employee_number per_all_people_f.employee_number%TYPE

8: TYPE g_output_file_rec_type IS RECORD(
9: assignment_id per_all_assignments_f.assignment_id%TYPE
10: ,status VARCHAR2(80)
11: ,uom VARCHAR2(80)
12: ,employee_number per_all_people_f.employee_number%TYPE
13: ,assignment_number per_all_assignments_f.assignment_number%TYPE
14: ,effective_date per_all_assignments_f.effective_start_date%TYPE
15: ,old_budget_value per_assignment_budget_values_f.VALUE%TYPE
16: ,change_type VARCHAR2(80)

Line 2116: FROM per_all_people_f a

2112: p_uom;
2113:
2114: SELECT employee_number
2115: INTO g_output_file_records(g_output_file_records.FIRST).employee_number
2116: FROM per_all_people_f a
2117: WHERE a.person_id =
2118: (SELECT asg.person_id
2119: FROM per_all_assignments_f asg
2120: WHERE asg.assignment_id = p_assignment_id AND ROWNUM < 2)

Line 2122: FROM per_all_people_f b

2118: (SELECT asg.person_id
2119: FROM per_all_assignments_f asg
2120: WHERE asg.assignment_id = p_assignment_id AND ROWNUM < 2)
2121: AND effective_start_date = (SELECT MAX(b.effective_start_date)
2122: FROM per_all_people_f b
2123: WHERE b.person_id = a.person_id);
2124:
2125: l_proc_step := 80;
2126: