APPS.PSP_SUM_TRANS dependencies on PER_PEOPLE_F

Line 3698: FROM per_people_f

3694: -- get the employee number
3695: BEGIN
3696: SELECT employee_number
3697: INTO l_employee_number
3698: FROM per_people_f
3699: WHERE person_id = gms_interface_rec.person_id
3700: AND gms_interface_rec.effective_date BETWEEN effective_start_date AND effective_end_date;
3701: EXCEPTION
3702: WHEN NO_DATA_FOUND THEN

Line 3704: l_table := 'PER_PEOPLE_F';

3700: AND gms_interface_rec.effective_date BETWEEN effective_start_date AND effective_end_date;
3701: EXCEPTION
3702: WHEN NO_DATA_FOUND THEN
3703: l_value := 'Person Id = '||to_char(gms_interface_rec.person_id);
3704: l_table := 'PER_PEOPLE_F';
3705: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3706: fnd_message.set_token('VALUE',l_value);
3707: fnd_message.set_token('TABLE',l_table);
3708: fnd_msg_pub.add;