APPS.EAM_RES_INST_VALIDATE_PVT dependencies on PER_ALL_PEOPLE_F

Line 83: from per_all_people_f papf,bom_resource_employees bre

79: if p_eam_res_inst_rec.SERIAL_NUMBER is null then
80:
81: select full_name
82: into l_token_tbl(1).token_value
83: from per_all_people_f papf,bom_resource_employees bre
84: where bre.instance_id = p_eam_res_inst_rec.instance_id
85: and papf.person_id = bre.person_id
86: and( trunc(sysdate) between papf.effective_start_date
87: and papf.effective_end_date);

Line 115: from per_all_people_f papf,bom_resource_employees bre

111: if p_eam_res_inst_rec.SERIAL_NUMBER is null then
112:
113: select full_name
114: into l_token_tbl(1).token_value
115: from per_all_people_f papf,bom_resource_employees bre
116: where bre.instance_id = p_eam_res_inst_rec.instance_id
117: and papf.person_id = bre.person_id
118: and( trunc(sysdate) between papf.effective_start_date
119: and papf.effective_end_date);

Line 319: from per_all_people_f papf,bom_resource_employees bre

315:
316: if p_eam_res_inst_rec.SERIAL_NUMBER is null then
317: select full_name
318: into l_token_tbl(1).token_value
319: from per_all_people_f papf,bom_resource_employees bre
320: where bre.instance_id = p_eam_res_inst_rec.instance_id
321: and papf.person_id = bre.person_id
322: and( trunc(sysdate) between papf.effective_start_date
323: and papf.effective_end_date);