[Home] [Help]
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'
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
212: and ge.encumbrance_id = gei.encumbrance_id
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
443: and ge.encumbrance_id = gei.encumbrance_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
515: and ge.encumbrance_group = geg.encumbrance_group
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
631: and ge.encumbrance_id = gei.encumbrance_id