[Home] [Help]
218: FROM pa_projects p ,
219: pa_project_types pt ,
220: pa_implementations i ,
221: pa_periods per ,
222: pa_class_categories cc ,
223: pa_project_classes pc
224: WHERE
225: i.accumulation_period_type = 'PA' AND
226: p.project_type = pt.project_type AND pt.project_type_class_code =
246: , pa_project_types pt
247: , pa_txn_accum ta
248: , pa_implementations i ,
249: pa_periods per ,
250: pa_class_categories cc ,
251: pa_project_classes pc
252: WHERE
253: i.accumulation_period_type = 'PA'
254: AND p.project_type = pt.project_type
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'
284: AND p.project_type =
285: pt.project_type
333: FROM pa_projects p
334: , pa_project_types pt
335: , pa_implementations i
336: , gl_period_statuses per
337: , pa_class_categories cc
338: , pa_project_classes pc
339: WHERE i.accumulation_period_type = 'GL'
340: AND p.project_type = pt.project_type
341: AND pt.project_type_class_code = 'CONTRACT'
365: , pa_project_types pt
366: , pa_txn_accum ta
367: , pa_implementations i
368: , gl_period_statuses per
369: , pa_class_categories cc
370: , pa_project_classes pc
371: WHERE i.accumulation_period_type = 'GL'
372: AND p.project_type = pt.project_type
373: AND pt.project_type_class_code = 'CONTRACT'
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
405: WHERE i.accumulation_period_type = 'GL'
406: AND p.project_type = pt.project_type
407: AND pt.project_type_class_code = 'CONTRACT'
879: , pa_project_types pt
880: , pa_project_accum_headers pah
881: , pa_project_accum_actuals paa
882: , pa_project_accum_budgets pab
883: , pa_class_categories cc
884: , pa_project_classes pc
885: WHERE p.project_id = pah.project_id
886: AND p.project_type = pt.project_type
887: AND pt.project_type_class_code = 'CONTRACT'
913: , pa_project_types pt
914: , pa_project_accum_headers pah
915: , pa_project_accum_actuals paa
916: , pa_project_accum_budgets pab
917: , pa_class_categories cc
918: , pa_project_classes pc
919: WHERE p.project_id = pah.project_id
920: AND p.project_type = pt.project_type
921: AND pt.project_type_class_code = 'CONTRACT'
947: , pa_project_types pt
948: , pa_project_accum_headers pah
949: , pa_project_accum_actuals paa
950: , pa_project_accum_budgets pab
951: , pa_class_categories cc
952: WHERE p.project_id = pah.project_id
953: AND p.project_type = pt.project_type
954: AND pt.project_type_class_code = 'CONTRACT'
955: AND pah.task_id = 0
982: , pa_project_types pt
983: , pa_project_accum_headers pah
984: , pa_project_accum_actuals paa
985: , pa_project_accum_budgets pab
986: , pa_class_categories cc
987: WHERE p.project_id = pah.project_id
988: AND p.project_type = pt.project_type
989: AND pt.project_type_class_code = 'CONTRACT'
990: AND pah.task_id = 0
1178: , pa_project_types pt
1179: , pa_project_accum_headers pah
1180: , pa_project_accum_actuals paa
1181: , pa_project_accum_budgets pab
1182: , pa_class_categories cc
1183: , pa_project_classes pc
1184: WHERE p.project_id = pah.project_id
1185: AND p.project_type = pt.project_type
1186: AND pt.project_type_class_code = 'CONTRACT'
1209: , pa_project_types pt
1210: , pa_project_accum_headers pah
1211: , pa_project_accum_actuals paa
1212: , pa_project_accum_budgets pab
1213: , pa_class_categories cc
1214: , pa_project_classes pc
1215: WHERE p.project_id = pah.project_id
1216: AND p.project_type = pt.project_type
1217: AND pt.project_type_class_code = 'CONTRACT'
1240: , pa_project_types pt
1241: , pa_project_accum_headers pah
1242: , pa_project_accum_actuals paa
1243: , pa_project_accum_budgets pab
1244: , pa_class_categories cc
1245: WHERE p.project_id = pah.project_id
1246: AND p.project_type = pt.project_type
1247: AND pt.project_type_class_code = 'CONTRACT'
1248: AND pah.task_id = 0
1272: , pa_project_types pt
1273: , pa_project_accum_headers pah
1274: , pa_project_accum_actuals paa
1275: , pa_project_accum_budgets pab
1276: , pa_class_categories cc
1277: WHERE p.project_id = pah.project_id
1278: AND p.project_type = pt.project_type
1279: AND pt.project_type_class_code = 'CONTRACT'
1280: AND pah.task_id = 0