DBA Data[Home] [Help]

APPS.PA_RESOURCES_PKG dependencies on PER_ALL_PEOPLE_F

Line 225: from per_all_people_f pe --For 1807084, per_all_people_f replaces pa_employees_res_v

221: elsif
222: P_Resource_Type_Code = 'EMPLOYEE' then
223: select substrb(pe.full_name,1,60) -- Bug#7832726
224: into P_employee_name
225: from per_all_people_f pe --For 1807084, per_all_people_f replaces pa_employees_res_v
226: ,pa_resource_txn_attributes prta
227: where prta.person_id = pe.person_id
228: and prta.resource_id = P_resource_id
229: /* Commented the below condition and added new and condition for bug# 4143659