APPS.GMS_FC_SYS dependencies on GMS_ENCUMBRANCE_ITEMS_ALL

Line 77: from gms_encumbrance_items_all gei,

73: gei.acct_raw_cost,
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

Line 209: gms_encumbrance_items_all gei

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
213: and p.project_id = nvl(p_project_id, p.project_id)

Line 440: gms_encumbrance_items_all gei

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
444: and p.project_id = nvl(p_project_id, p.project_id)

Line 502: /* ---------------- Update of Requset Id on gms_encumbrance_items_all --------------------- */ --1472753

498: where packet_id = x_packet_id;
499:
500: BEGIN
501:
502: /* ---------------- Update of Requset Id on gms_encumbrance_items_all --------------------- */ --1472753
503: update gms_encumbrance_items_all
504: set request_id = l_request_id
505: where encumbrance_item_id in (
506: select gei.encumbrance_item_id

Line 503: update gms_encumbrance_items_all

499:
500: BEGIN
501:
502: /* ---------------- Update of Requset Id on gms_encumbrance_items_all --------------------- */ --1472753
503: update gms_encumbrance_items_all
504: set request_id = l_request_id
505: where encumbrance_item_id in (
506: select gei.encumbrance_item_id
507: from pa_projects p,

Line 512: gms_encumbrance_items_all gei

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

Line 529: /* ---------------- Update of Requset Id on gms_encumbrance_items_all --------------------- */ --1472753

525: and p.project_type = gpt.project_type
526: and gpt.sponsored_flag = 'Y'
527: and nvl(adl.adl_status,'A')= 'A');
528:
529: /* ---------------- Update of Requset Id on gms_encumbrance_items_all --------------------- */ --1472753
530:
531: select gl_bc_packets_s.nextval into x_packet_id from dual;
532:
533: insert into gms_bc_packets (

Line 628: gms_encumbrance_items_all gei

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
632: and p.project_id = nvl(p_project_id, p.project_id)