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 =
227: 'CONTRACT' AND p.project_id = pc.project_id AND pc.class_category =
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
255: AND
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
286: AND pt.project_type_class_code = 'CONTRACT'
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'
342: AND per.application_id = PA_Period_Process_Pkg.Application_ID
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'
374: AND ta.project_id = p.project_id
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'
408: AND p.project_id = bpa.project_id
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'
888: AND pah.task_id = 0
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'
922: AND pah.task_id = 0
958: AND pah.project_accum_id = pab.project_accum_id(+)
959: AND pab.budget_type_code(+) = 'AR'
960: AND cc.pick_one_code_only_flag = 'Y'
961: AND NOT EXISTS (select 'x'
962: from pa_project_classes pc2
963: where pc2.project_id = p.project_id
964: and pc2.class_category = cc.class_category)
965: GROUP BY CC.CLASS_CATEGORY, P.PROJECT_ID, P.SEGMENT1, P.NAME, P.org_id
966: UNION
993: AND pah.project_accum_id = pab.project_accum_id(+)
994: AND pab.budget_type_code(+) = 'AC'
995: AND cc.pick_one_code_only_flag = 'Y'
996: AND NOT EXISTS (select 'x'
997: from pa_project_classes pc2
998: where pc2.project_id = p.project_id
999: and pc2.class_category = cc.class_category)
1000: GROUP BY CC.CLASS_CATEGORY, P.PROJECT_ID, P.SEGMENT1, P.NAME, P.org_id
1001: ;
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'
1187: AND pah.task_id = 0
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'
1218: AND pah.task_id = 0
1251: AND pah.project_accum_id = pab.project_accum_id(+)
1252: AND pab.budget_type_code(+) = 'AR'
1253: AND cc.pick_one_code_only_flag = 'Y'
1254: AND NOT EXISTS (select 'x'
1255: from pa_project_classes pc2
1256: where pc2.project_id = p.project_id
1257: and pc2.class_category = cc.class_category)
1258: GROUP BY CC.CLASS_CATEGORY, P.org_id
1259: UNION
1283: AND pah.project_accum_id = pab.project_accum_id(+)
1284: AND pab.budget_type_code(+) = 'AC'
1285: AND cc.pick_one_code_only_flag = 'Y'
1286: AND NOT EXISTS (select 'x'
1287: from pa_project_classes pc2
1288: where pc2.project_id = p.project_id
1289: and pc2.class_category = cc.class_category)
1290: GROUP BY CC.CLASS_CATEGORY, P.org_id
1291: ;