DBA Data[Home] [Help]

APPS.PA_BIS_SUMMARY dependencies on PA_BUDGET_BY_PA_PERIOD_V

Line 96: , pa_budget_by_pa_period_v bpa

92: , BPA.BASE_BURDENED_COST BUD_COST
93: , BPA.BASE_REVENUE BUD_REVENUE
94: FROM pa_projects p
95: , pa_project_types pt
96: , pa_budget_by_pa_period_v bpa
97: , pa_implementations I
98: , gl_period_statuses per
99: WHERE i.accumulation_period_type = 'GL'
100: AND p.project_type = pt.project_type

Line 125: , pa_budget_by_pa_period_v bpa

121: , BPA.BASE_BURDENED_COST BUD_COST
122: , BPA.BASE_REVENUE BUD_REVENUE
123: FROM pa_projects p
124: , pa_project_types pt
125: , pa_budget_by_pa_period_v bpa
126: , pa_implementations i
127: WHERE i.accumulation_period_type = 'PA'
128: AND p.project_type = pt.project_type
129: AND pt.project_type_class_code = 'CONTRACT'

Line 279: pa_budget_by_pa_period_v bpa ,

275: BPA.BASE_BURDENED_COST BUD_COST,
276: BPA.BASE_REVENUE BUD_REVENUE
277: FROM pa_projects p ,
278: pa_project_types pt ,
279: pa_budget_by_pa_period_v bpa ,
280: pa_implementations i ,
281: pa_class_categories cc ,
282: pa_project_classes pc
283: WHERE i.accumulation_period_type = 'PA'

Line 400: , pa_budget_by_pa_period_v bpa

396: , BPA.BASE_BURDENED_COST BUD_COST
397: , BPA.BASE_REVENUE BUD_REVENUE
398: FROM pa_projects p
399: , pa_project_types pt
400: , pa_budget_by_pa_period_v bpa
401: , pa_implementations I
402: , gl_period_statuses per
403: , pa_class_categories cc
404: , pa_project_classes pc

Line 492: , pa_budget_by_pa_period_v bpa

488: , BPA.BASE_BURDENED_COST BUD_COST
489: , BPA.BASE_REVENUE BUD_REVENUE
490: FROM pa_projects p
491: , pa_project_types pt
492: , pa_budget_by_pa_period_v bpa
493: , pa_implementations i
494: WHERE i.accumulation_period_type = 'PA'
495: AND p.project_type = pt.project_type
496: AND pt.project_type_class_code = 'CONTRACT'

Line 558: , pa_budget_by_pa_period_v bpa

554: , BPA.BASE_BURDENED_COST BUD_COST
555: , BPA.BASE_REVENUE BUD_REVENUE
556: FROM pa_projects p
557: , pa_project_types pt
558: , pa_budget_by_pa_period_v bpa
559: , pa_implementations i
560: , gl_period_statuses per
561: WHERE i.accumulation_period_type = 'GL'
562: AND p.project_type = pt.project_type