30: ****************************************************************************/
31: (b_employee_id IN NUMBER
32: )IS SELECT full_name
33: , employee_number
34: FROM per_all_people_f
35: WHERE person_id = b_employee_id
36: AND trunc(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
37:
38: CURSOR c_employee
42: ****************************************************************************/
43: (b_employee_id IN NUMBER
44: )IS SELECT full_name
45: , employee_number
46: FROM per_all_people_f
47: WHERE person_id = b_employee_id;
48:
49: CURSOR c_party
50: /****************************************************************************