DBA Data[Home] [Help]

APPS.JTF_COMMON_PVT dependencies on PER_ALL_PEOPLE_F

Line 34: FROM per_all_people_f

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

Line 46: FROM per_all_people_f

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: /****************************************************************************