DBA Data[Home] [Help]

APPS.GMS_RES_MAP dependencies on GMS_ENCUMBRANCE_ITEMS_ALL

Line 407: gms_encumbrance_items_all geia,

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

Line 454: gms_encumbrance_items_all geia

450:
451: select substrb(pj.name,1,100)
452: into l_job_title
453: from per_jobs pj,
454: gms_encumbrance_items_all geia
455: where geia.encumbrance_item_id = x_document_header_id
456: and pj.job_id = geia.job_id;
457: EXCEPTION
458: WHEN NO_DATA_FOUND THEN