DBA Data[Home] [Help]

APPS.GMS_FC_SYS dependencies on GMS_ENCUMBRANCE_GROUPS_ALL

Line 207: gms_encumbrance_groups_all geg,

203: pa_projects p,
204: gms_project_types gpt,
205: pa_expenditure_types pet,
206: gms_award_distributions adl,
207: gms_encumbrance_groups_all geg,
208: gms_encumbrances_all ge,
209: gms_encumbrance_items_all gei
210: where gei.request_id = p_request_id
211: and ge.encumbrance_group = geg.encumbrance_group

Line 438: gms_encumbrance_groups_all geg,

434: pa_projects p,
435: gms_project_types gpt,
436: pa_expenditure_types pet,
437: gms_award_distributions adl,
438: gms_encumbrance_groups_all geg,
439: gms_encumbrances_all ge,
440: gms_encumbrance_items_all gei
441: where gei.request_id = p_request_id
442: and ge.encumbrance_group = geg.encumbrance_group

Line 510: gms_encumbrance_groups_all geg,

506: select gei.encumbrance_item_id
507: from pa_projects p,
508: gms_project_types gpt,
509: gms_award_distributions adl,
510: gms_encumbrance_groups_all geg,
511: gms_encumbrances_all ge,
512: gms_encumbrance_items_all gei
513: where geg.encumbrance_group = nvl(p_enc_group,geg.encumbrance_group)
514: and geg.encumbrance_group_status_code = 'RELEASED' -- Bug Fix 1364085

Line 626: gms_encumbrance_groups_all geg,

622: pa_projects p,
623: gms_project_types gpt,
624: pa_expenditure_types pet,
625: gms_award_distributions adl,
626: gms_encumbrance_groups_all geg,
627: gms_encumbrances_all ge,
628: gms_encumbrance_items_all gei
629: where gei.request_id=l_request_id
630: and ge.encumbrance_group = geg.encumbrance_group