DBA Data[Home] [Help]

APPS.GMS_RES_MAP dependencies on PER_JOBS

Line 434: from per_jobs pj,

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

Line 453: from per_jobs pj,

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

Line 1419: from per_jobs pj

1415: BEGIN
1416:
1417: select substrb(pj.name,1,100)
1418: into l_job_title
1419: from per_jobs pj
1420: where pj.job_id = x_job_id;
1421: EXCEPTION
1422: WHEN NO_DATA_FOUND THEN
1423: NULL;