APPS.GMS_RES_MAP dependencies on PA_EXPENDITURES_ALL

Line 386: pa_expenditures_all pea

382: select substrb(papf.full_name,1,100)
383: into l_person_name
384: from per_all_people_f papf,
385: pa_expenditure_items_all peia,
386: pa_expenditures_all pea
387: where peia.expenditure_item_id = x_document_header_id
388: and pea.expenditure_id = peia.expenditure_id
389: and papf.person_id = pea.incurred_by_person_id
390: and trunc(peia.expenditure_item_date) between trunc(papf.effective_start_date) and trunc(nvl(effective_end_Date,sysdate));