APPS.PSP_SUM_TRANS dependencies on PER_PEOPLE_F

Line 3898: FROM per_people_f

3894: -- get the employee number
3895: BEGIN
3896: SELECT employee_number
3897: INTO l_employee_number
3898: FROM per_people_f
3899: WHERE person_id = gms_interface_rec.person_id
3900: AND gms_interface_rec.effective_date BETWEEN effective_start_date AND effective_end_date;
3901: EXCEPTION
3902: WHEN NO_DATA_FOUND THEN

Line 3904: l_table := 'PER_PEOPLE_F';

3900: AND gms_interface_rec.effective_date BETWEEN effective_start_date AND effective_end_date;
3901: EXCEPTION
3902: WHEN NO_DATA_FOUND THEN
3903: l_value := 'Person Id = '||to_char(gms_interface_rec.person_id);
3904: l_table := 'PER_PEOPLE_F';
3905: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3906: fnd_message.set_token('VALUE',l_value);
3907: fnd_message.set_token('TABLE',l_table);
3908: fnd_msg_pub.add;