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 2139: FROM per_all_people_f a

2135: p_uom;
2136:
2137: SELECT employee_number
2138: INTO g_output_file_records(g_output_file_records.FIRST).employee_number
2139: FROM per_all_people_f a
2140: WHERE a.person_id =
2141: (SELECT asg.person_id
2142: FROM per_all_assignments_f asg
2143: WHERE asg.assignment_id = p_assignment_id AND ROWNUM < 2)

Line 2145: FROM per_all_people_f b

2141: (SELECT asg.person_id
2142: FROM per_all_assignments_f asg
2143: WHERE asg.assignment_id = p_assignment_id AND ROWNUM < 2)
2144: AND effective_start_date = (SELECT MAX(b.effective_start_date)
2145: FROM per_all_people_f b
2146: WHERE b.person_id = a.person_id);
2147:
2148: l_proc_step := 80;
2149: