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 125: gms_award_distributions adl

121: adl.capitalizable_flag,
122: adl.bill_hold_flag,
123: adl.billable_flag
124: from gms_encumbrance_items_all gei,
125: gms_award_distributions adl
126: where gei.encumbrance_item_id = adl.expenditure_item_id
127: and adl.adl_status = 'A'
128: and adl.document_type = 'ENC'
129: and gei.enc_distributed_flag = 'N'

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

136: and adl.fc_status = 'A';
137:
138: type l_brdn_impacted_enc_tab is table of brdn_impacted_enc1%rowtype index by binary_integer;
139:
140: type adl_tbl is table of gms_award_distributions%rowtype index by binary_integer;
141: l_negative_ln_adl_tbl adl_tbl;
142: l_positive_ln_adl_tbl adl_tbl;
143: l_brdn_impacted_enc l_brdn_impacted_enc_tab;
144: begin

Line 252: gms_award_distributions adl,

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

Line 318: from gms_award_distributions

314:
315: --Create -ive ADL
316: select max(adl_line_num)
317: into l_max_adl_line_num
318: from gms_award_distributions
319: where award_set_id = l_brdn_impacted_enc(i).award_set_id;
320:
321: l_negative_ln_adl_tbl(i).award_set_id := l_brdn_impacted_enc(i).award_set_id;
322: l_negative_ln_adl_tbl(i).adl_line_num := l_max_adl_line_num + 1;

Line 386: update gms_award_distributions

382: gms_error_pkg.gms_debug('Updating reversed flag.', 'C');
383: end if;
384:
385: --Update reversed_flag on original line.
386: update gms_award_distributions
387: set reversed_flag = 'Y',
388: request_id = p_request_id
389: where award_set_id = l_brdn_impacted_enc(i).award_set_id
390: and adl_line_num = l_brdn_impacted_enc(i).adl_line_num

Line 493: gms_award_distributions adl,

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

Line 573: gms_award_distributions adl,

569: select gei.encumbrance_item_id
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

Line 601: gms_award_distributions adl,

597: select gei.encumbrance_item_id
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

Line 718: gms_award_distributions adl,

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