APPS.GMS_BUDGET_BALANCE dependencies on GL_PERIOD_STATUSES

Line 236: gl_period_statuses gps,

232: from po_req_distributions_all rd,
233: gms_award_distributions adl,
234: po_requisition_lines_all rl,
235: po_requisition_headers_all rh,
236: gl_period_statuses gps,
237: pa_expenditure_types pet
238: WHERE RH.REQUISITION_HEADER_ID = RL.REQUISITION_HEADER_ID
239: AND RH.TYPE_LOOKUP_CODE = 'PURCHASE'
240: AND NVL(RL.MODIFIED_BY_AGENT_FLAG,'N') = 'N'

Line 364: gl_period_statuses gps,

360: po_line_locations_all pll,
361: po_releases_all por,
362: po_distributions_all pod,
363: gms_award_distributions adl,
364: gl_period_statuses gps,
365: pa_expenditure_types pet
366: WHERE POH.TYPE_LOOKUP_CODE IN ('STANDARD','BLANKET','PLANNED')
367: AND POL.PO_HEADER_ID = POH.PO_HEADER_ID
368: AND POL.PO_LINE_ID = PLL.PO_LINE_ID

Line 494: gl_period_statuses gps,

490: adl.ind_compiled_set_id -- Bug 2387678 (Performance Tuning)
491: from ap_invoices_all ap,
492: gms_award_distributions adl,
493: ap_invoice_distributions aid,
494: gl_period_statuses gps,
495: pa_expenditure_types pet,
496: gl_ledgers g
497: where ap.invoice_id = aid.invoice_id
498: and aid.invoice_distribution_id = adl.invoice_distribution_id -- AP Lines change

Line 636: GL_PERIOD_STATUSES GL,

632: gl_date_period_map map,
633: gl_sets_of_books glsob and pa_implementations imp for bug# 6043224 */
634: FROM GMS_AWARD_DISTRIBUTIONS ADL,
635: PA_COST_DISTRIBUTION_LINES_ALL PC,
636: GL_PERIOD_STATUSES GL,
637: PA_EXPENDITURE_ITEMS_ALL PE,
638: PA_EXPENDITURES_ALL PA,
639: PA_EXPENDITURE_TYPES PET
640: WHERE ADL.PROJECT_ID = x_project_id

Line 661: gl_period_STATUSES gl,

657: /* Commented for Bug 6043224
658: from pa_expenditure_items_all pe,
659: pa_expenditures_all pa,
660: pa_cost_distribution_lines_all pc,
661: gl_period_STATUSES gl,
662: -- pa_tasks task, -- commented for Bug:1703510
663: gms_award_distributions adl,
664: --pa_periods pp, -- Bug 2887849, EPP changes
665: pa_expenditure_types pet, -- Bug 2069132 (RLMI Change)

Line 802: gl_period_STATUSES gl,

798: pet.revenue_category_code, -- Bug 2069132 ( RLMI Change)
799: adl.ind_compiled_set_id -- Bug 2387678 (Performance Tuning)
800: from gms_encumbrance_items_all gei,
801: gms_encumbrances_all ge,
802: gl_period_STATUSES gl,
803: --pa_tasks task, -- commented out NOCOPY for porting bug:1703510
804: gms_award_distributions adl,
805: pa_expenditure_types pet -- Bug 2069132 (RLMI Change)
806: -- where task.project_id = x_project_id -- commented out NOCOPY for porting bug:1703510