APPS.PSP_WF_EFF_PKG dependencies on PER_PEOPLE_F

Line 331: l_certifier_display_name VARCHAR2(240); --column FULL_NAME in PER_PEOPLE_F is VARCHAR2(240)

327: l_employee_id NUMBER;
328: l_supervisor_id NUMBER;
329:
330: l_certifier_username VARCHAR2(100); --column USER_NAME in FND_USER is VARCHAR2(100)
331: l_certifier_display_name VARCHAR2(240); --column FULL_NAME in PER_PEOPLE_F is VARCHAR2(240)
332:
333: CURSOR get_supervisor_id_csr IS
334: SELECT assignment.supervisor_id
335: FROM per_assignments_f assignment,

Line 336: per_people_f people

332:
333: CURSOR get_supervisor_id_csr IS
334: SELECT assignment.supervisor_id
335: FROM per_assignments_f assignment,
336: per_people_f people
337: WHERE assignment.person_id = l_employee_id
338: AND assignment.supervisor_id = people.person_id
339: AND assignment.assignment_type ='E' --Added for bug 2624259.
340: AND trunc(SYSDATE) BETWEEN people.effective_start_date AND people.effective_end_date

Line 730: FROM per_people_f ppf

726: l_person_id NUMBER(9);
727:
728: CURSOR get_term_employee_csr IS
729: SELECT ppf.current_employee_flag
730: FROM per_people_f ppf
731: WHERE ppf.person_id = l_person_id
732: AND trunc(SYSDATE) BETWEEN trunc(ppf.effective_start_date) AND trunc(ppf.effective_end_date);
733:
734: