APPS.PA_RESOURCES_PKG dependencies on PA_RESOURCE_TXN_ATTRIBUTES

Line 204: ,pa_resource_txn_attributes prta

200: if P_Resource_Type_Code = 'ORGANIZATION' then
201: select substrb(org.name,1,60) -- Bug#7832726
202: into P_organization_name
203: from hr_all_organization_units org --For 1807084 hr_all_organization_units
204: ,pa_resource_txn_attributes prta
205: where prta.organization_id = org.organization_id
206: and prta.resource_id = P_resource_id;
207:
208: RETURN P_organization_name;

Line 215: ,pa_resource_txn_attributes prta

211: P_Resource_Type_Code = 'JOB' then
212: select SUBSTR(pj.name,1,60)
213: into P_job_name
214: from per_jobs pj -- For 1807084, per_jobs replaces pa_jobs_res_v
215: ,pa_resource_txn_attributes prta
216: where prta.job_id = pj.job_id
217: and prta.resource_id = P_resource_id;
218:
219: RETURN P_job_name;

Line 226: ,pa_resource_txn_attributes prta

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
230: and P_start_date_active between pe.effective_start_date and pe.effective_end_date */

Line 242: ,pa_resource_txn_attributes prta

238: P_Resource_Type_Code = 'VENDOR' then
239: select pv.vendor_name -- Bug#2178043
240: into P_vendor_name
241: from po_vendors pv --For 1807084, po_vendors replaces pa_vendors_res_v
242: ,pa_resource_txn_attributes prta
243: where prta.vendor_id = pv.vendor_id
244: and prta.resource_id = P_resource_id;
245:
246: return P_vendor_name;