DBA Data[Home] [Help]

APPS.GMS_BUDGET_BALANCE dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 523: from pa_cost_distribution_lines_all cdl

519:
520: /* Commented out for bug 3661740. pa_addition_flag check should preclude items
521: that are interfaced to PA.
522: and not exists (select 'X'
523: from pa_cost_distribution_lines_all cdl
524: where cdl.system_reference2 = to_char(aid.invoice_id)
525: and cdl.system_reference3 = to_char(aid.distribution_line_number))
526: */
527:

Line 635: PA_COST_DISTRIBUTION_LINES_ALL PC,

631: removed join with tables
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

Line 660: pa_cost_distribution_lines_all pc,

656: AND PET.EXPENDITURE_TYPE = PE.EXPENDITURE_TYPE;
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