APPS.GMS_RES_MAP dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 385: pa_expenditure_items_all peia,

381:
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

Line 435: pa_expenditure_items_all peia

431:
432: select substrb(pj.name,1,100)
433: into l_job_title
434: from per_jobs pj,
435: pa_expenditure_items_all peia
436: where peia.expenditure_item_id = x_document_header_id
437: and pj.job_id = peia.job_id;
438: EXCEPTION
439: WHEN NO_DATA_FOUND THEN