APPS.GMS_FC_SYS dependencies on GMS_AWARD_DISTRIBUTIONS

Line 79: gms_award_distributions adl

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'
83: and adl.document_type = 'ENC'

Line 94: type adl_tbl is table of gms_award_distributions%rowtype index by binary_integer;

90: and ge.encumbrance_group = nvl(p_enc_group, ge.encumbrance_group) --Bug 5956414
91: and adl.ind_compiled_set_id is not null
92: and adl.fc_status = 'A';
93: type l_brdn_impacted_enc_tab is table of brdn_impacted_enc%rowtype index by binary_integer;
94: type adl_tbl is table of gms_award_distributions%rowtype index by binary_integer;
95: l_negative_ln_adl_tbl adl_tbl;
96: l_positive_ln_adl_tbl adl_tbl;
97: l_brdn_impacted_enc l_brdn_impacted_enc_tab;
98: begin

Line 206: gms_award_distributions adl,

202: gl_sets_of_books sob,
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

Line 262: from gms_award_distributions

258:
259: --Create -ive ADL
260: select max(adl_line_num)
261: into l_max_adl_line_num
262: from gms_award_distributions
263: where award_set_id = l_brdn_impacted_enc(i).award_set_id;
264:
265: l_negative_ln_adl_tbl(i).award_set_id := l_brdn_impacted_enc(i).award_set_id;
266: l_negative_ln_adl_tbl(i).adl_line_num := l_max_adl_line_num + 1;

Line 330: update gms_award_distributions

326: gms_error_pkg.gms_debug('Updating reversed flag.', 'C');
327: end if;
328:
329: --Update reversed_flag on original line.
330: update gms_award_distributions
331: set reversed_flag = 'Y',
332: request_id = p_request_id
333: where award_set_id = l_brdn_impacted_enc(i).award_set_id
334: and adl_line_num = l_brdn_impacted_enc(i).adl_line_num

Line 437: gms_award_distributions adl,

433: gl_sets_of_books sob,
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

Line 509: gms_award_distributions adl,

505: where encumbrance_item_id in (
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)

Line 625: gms_award_distributions adl,

621: gl_sets_of_books sob,
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