APPS.GMS_RES_MAP dependencies on GMS_ENCUMBRANCES_ALL

Line 408: gms_encumbrances_all gea

404: select substrb(papf.full_name,1,100)
405: into l_person_name
406: from per_all_people_f papf,
407: gms_encumbrance_items_all geia,
408: gms_encumbrances_all gea
409: where geia.encumbrance_item_id = x_document_header_id
410: and gea.encumbrance_id = geia.encumbrance_id
411: and papf.person_id = gea.incurred_by_person_id
412: and trunc(geia.encumbrance_item_date) between trunc(papf.effective_start_date) and trunc(nvl(effective_end_Date,sysdate));