APPS.GMS_FC_SYS dependencies on GMS_ENCUMBRANCES_ALL

Line 78: gms_encumbrances_all ge,

74: adl.capitalizable_flag,
75: adl.bill_hold_flag,
76: adl.billable_flag
77: from gms_encumbrance_items_all gei,
78: gms_encumbrances_all ge,
79: gms_award_distributions adl
80: where gei.encumbrance_id = ge.encumbrance_id
81: and gei.encumbrance_item_id = adl.expenditure_item_id
82: and adl.adl_status = 'A'

Line 254: gms_encumbrances_all ge,

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
258: and ge.encumbrance_id = gei.encumbrance_id

Line 495: gms_encumbrances_all ge,

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
499: and ge.encumbrance_id = gei.encumbrance_id

Line 575: gms_encumbrances_all ge,

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
579: and ge.encumbrance_group = geg.encumbrance_group

Line 603: gms_encumbrances_all ge,

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
607: and ge.encumbrance_group = geg.encumbrance_group

Line 720: gms_encumbrances_all ge,

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
724: and ge.encumbrance_id = gei.encumbrance_id