DBA Data[Home] [Help]

APPS.GMS_RES_MAP dependencies on PER_ALL_PEOPLE_F

Line 384: from per_all_people_f papf,

380: BEGIN
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

Line 406: from per_all_people_f papf,

402: BEGIN
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

Line 1393: from per_all_people_f papf,

1389: BEGIN
1390:
1391: select substrb(papf.full_name,1,100)
1392: into l_person_name
1393: from per_all_people_f papf,
1394: pa_resources pr,
1395: pa_resource_types prt
1396: where papf.person_id = x_person_id
1397: and papf.full_name = pr.name