APPS.HRI_BPL_PERF_RATING dependencies on PER_ALL_PEOPLE_F

Line 928: l_person_name per_all_people_f.full_name%TYPE;

924: l_message fnd_new_messages.message_text%TYPE;
925: --
926: -- Variable to store the message
927: --
928: l_person_name per_all_people_f.full_name%TYPE;
929: --
930: -- Stores the name of the formula
931: --
932: l_ff_name VARCHAR2(100);

Line 945: FROM per_all_people_f per

941: AND b.bucket_id = bb.bucket_id;
942: --
943: CURSOR c_person_name IS
944: SELECT full_name
945: FROM per_all_people_f per
946: WHERE per.person_id = p_person_id
947: AND trunc(sysdate) between per.effective_start_date and effective_end_date;
948: --
949: BEGIN