DBA Data[Home] [Help]

APPS.CAC_NOTES_PVT dependencies on PER_ALL_PEOPLE_F

Line 1526: FROM per_all_people_f

1522: ****************************************************************************/
1523: (b_employee_id IN NUMBER
1524: )IS SELECT full_name
1525: , employee_number
1526: FROM per_all_people_f
1527: WHERE person_id = b_employee_id
1528: AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
1529:
1530: CURSOR c_party