DBA Data[Home] [Help]

APPS.GMS_FC_SYS dependencies on GMS_ENCUMBRANCE_GROUPS_ALL

Line 253: -- gms_encumbrance_groups_all geg, -- Bug 9191719

249: -- pa_projects p, -- Bug 9191719
250: -- gms_project_types gpt, -- Bug 9191719
251: pa_expenditure_types pet,
252: gms_award_distributions adl,
253: -- gms_encumbrance_groups_all geg, -- Bug 9191719
254: gms_encumbrances_all ge,
255: gms_encumbrance_items_all gei
256: where gei.request_id = p_request_id
257: -- and ge.encumbrance_group = geg.encumbrance_group -- Bug 9191719

Line 494: -- gms_encumbrance_groups_all geg, -- Bug 9191719

490: -- pa_projects p, -- Bug 9191719
491: -- gms_project_types gpt, -- Bug 9191719
492: pa_expenditure_types pet,
493: gms_award_distributions adl,
494: -- gms_encumbrance_groups_all geg, -- Bug 9191719
495: gms_encumbrances_all ge,
496: gms_encumbrance_items_all gei
497: where gei.request_id = p_request_id
498: -- and ge.encumbrance_group = geg.encumbrance_group -- Bug 9191719

Line 574: gms_encumbrance_groups_all geg,

570: from
571: -- pa_projects p, -- Bug 9191719
572: -- gms_project_types gpt, -- Bug 9191719
573: gms_award_distributions adl,
574: gms_encumbrance_groups_all geg,
575: gms_encumbrances_all ge,
576: gms_encumbrance_items_all gei
577: where /*geg.encumbrance_group = nvl(p_enc_group,geg.encumbrance_group) -- Bug:8232859
578: and */geg.encumbrance_group_status_code = 'RELEASED' -- Bug Fix 1364085

Line 602: gms_encumbrance_groups_all geg,

598: from
599: -- pa_projects p, -- Bug 9191719
600: -- gms_project_types gpt, -- Bug 9191719
601: gms_award_distributions adl,
602: gms_encumbrance_groups_all geg,
603: gms_encumbrances_all ge,
604: gms_encumbrance_items_all gei
605: where geg.encumbrance_group = p_enc_group -- Bug:8232859
606: and geg.encumbrance_group_status_code = 'RELEASED' -- Bug Fix 1364085

Line 719: -- gms_encumbrance_groups_all geg, -- Bug 9191719

715: -- pa_projects p, -- Bug 9191719
716: -- gms_project_types gpt, -- Bug 9191719
717: pa_expenditure_types pet,
718: gms_award_distributions adl,
719: -- gms_encumbrance_groups_all geg, -- Bug 9191719
720: gms_encumbrances_all ge,
721: gms_encumbrance_items_all gei
722: where gei.request_id=l_request_id
723: -- and ge.encumbrance_group = geg.encumbrance_group