eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BIS_SUMMARY dependencies on PA_PROJECT_CLASSES

Line 223: pa_project_classes pc

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 =

Line 251: pa_project_classes pc

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

Line 282: pa_project_classes pc

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'

Line 338: , pa_project_classes pc

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

Line 370: , pa_project_classes pc

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

Line 404: , pa_project_classes pc

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

Line 884: , pa_project_classes pc

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

Line 918: , pa_project_classes pc

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

Line 962: from pa_project_classes pc2

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

Line 997: from pa_project_classes pc2

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: ;

Line 1183: , pa_project_classes pc

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

Line 1214: , pa_project_classes pc

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

Line 1255: from pa_project_classes pc2

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

Line 1287: from pa_project_classes pc2

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: ;