APPS.PQP_FTE_UTILITIES dependencies on PER_ALL_PEOPLE_F

Line 11: ,employee_number per_all_people_f.employee_number%TYPE

7: --
8: TYPE g_output_file_rec_type IS RECORD
9: (assignment_id per_all_assignments_f.assignment_id%TYPE
10: ,status VARCHAR2(80)
11: ,employee_number per_all_people_f.employee_number%TYPE
12: ,assignment_number per_all_assignments_f.assignment_number%TYPE
13: ,effective_date per_all_assignments_f.effective_start_date%TYPE
14: ,change_in VARCHAR2(80)
15: ,FTE_old_value per_assignment_budget_values_f.value%TYPE

Line 2102: FROM per_all_people_f per,

2098: CURSOR csr_person_details
2099: (p_assignment_id NUMBER)
2100: IS
2101: SELECT per.full_name
2102: FROM per_all_people_f per,
2103: per_all_assignments_f asg
2104: WHERE asg.person_id = per.person_id
2105: AND asg.assignment_id = p_assignment_id
2106: AND l_calculation_date

Line 2397: FROM per_all_people_f a

2393: g_output_file_records(i).effective_date:= l_FTE_processing_start_date;
2394:
2395: SELECT employee_number
2396: INTO g_output_file_records(i).employee_number
2397: FROM per_all_people_f a
2398: WHERE a.person_id =
2399: (SELECT asg.person_id
2400: FROM per_all_assignments_f asg
2401: WHERE asg.assignment_id = l_assignment(i)

Line 2406: FROM per_all_people_f b

2402: AND ROWNUM < 2
2403: )
2404: AND effective_start_date =
2405: (SELECT MAX(b.effective_start_date)
2406: FROM per_all_people_f b
2407: WHERE b.person_id = a.person_id
2408: );
2409:
2410: l_proc_step := 70+(i/100000);