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_IMPLEMENTATIONS

Line 45: , pa_implementations i

41: , 0 BUD_REVENUE
42: FROM pa_projects p
43: , pa_project_types pt
44: , pa_txn_accum ta
45: , pa_implementations i
46: , gl_period_statuses per
47: WHERE i.accumulation_period_type = 'GL'
48: AND p.project_type = pt.project_type
49: AND pt.project_type_class_code = 'CONTRACT'

Line 73: , pa_implementations i

69: , 0 BUD_REVENUE
70: FROM pa_projects p
71: , pa_project_types pt
72: , pa_txn_accum ta
73: , pa_implementations i
74: , pa_periods per
75: WHERE i.accumulation_period_type = 'PA'
76: AND p.project_type = pt.project_type
77: AND pt.project_type_class_code = 'CONTRACT'

Line 97: , pa_implementations I

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
101: AND pt.project_type_class_code = 'CONTRACT'

Line 126: , pa_implementations i

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'
130: AND p.project_id = bpa.project_id

Line 148: , pa_implementations i

144: , 0 BUD_COST
145: , 0 BUD_REVENUE
146: FROM pa_projects p
147: , pa_project_types pt
148: , pa_implementations i
149: , gl_period_statuses per
150: WHERE i.accumulation_period_type = 'GL'
151: AND p.project_type = pt.project_type
152: AND pt.project_type_class_code = 'CONTRACT'

Line 173: , pa_implementations i

169: , 0 BUD_COST
170: , 0 BUD_REVENUE
171: FROM pa_projects p
172: , pa_project_types pt
173: , pa_implementations i
174: , pa_periods per
175: WHERE i.accumulation_period_type = 'PA'
176: AND p.project_type = pt.project_type
177: AND pt.project_type_class_code = 'CONTRACT'

Line 220: pa_implementations i ,

216: 0 BUD_COST,
217: 0 BUD_REVENUE
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

Line 248: , pa_implementations i ,

244: FROM
245: pa_projects p
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

Line 280: pa_implementations i ,

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'
284: AND p.project_type =

Line 335: , pa_implementations i

331: , 0 BUD_COST
332: , 0 BUD_REVENUE
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'

Line 367: , pa_implementations i

363: , 0 BUD_REVENUE
364: FROM pa_projects p
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'

Line 401: , pa_implementations I

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
405: WHERE i.accumulation_period_type = 'GL'

Line 454: , pa_implementations i

450: , 0 ACT_REVENUE
451: , 0 BUD_COST
452: , 0 BUD_REVENUE
453: FROM pa_periods per
454: , pa_implementations i
455: WHERE i.accumulation_period_type = 'PA'
456: AND per.start_date <= v_pa_org_start_date_high
457: AND per.start_date > v_pa_org_start_date_low
458: UNION ALL

Line 471: , pa_implementations i

467: , 0 BUD_REVENUE
468: FROM pa_projects p
469: , pa_project_types pt
470: , pa_txn_accum ta
471: , pa_implementations i
472: , pa_periods per
473: WHERE i.accumulation_period_type = 'PA'
474: AND p.project_type = pt.project_type
475: AND pt.project_type_class_code = 'CONTRACT'

Line 493: , pa_implementations i

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'
497: AND p.project_id = bpa.project_id

Line 511: FROM pa_implementations i

507: , 0 ACT_COST
508: , 0 ACT_REVENUE
509: , 0 BUD_COST
510: , 0 BUD_REVENUE
511: FROM pa_implementations i
512: , gl_period_statuses per
513: WHERE i.accumulation_period_type = 'GL'
514: AND per.application_id = PA_Period_Process_Pkg.Application_ID
515: -- Changed from 101 for PA/GL Period Enhancements

Line 533: , pa_implementations i

529: , 0 BUD_REVENUE
530: FROM pa_projects p
531: , pa_project_types pt
532: , pa_txn_accum ta
533: , pa_implementations i
534: , gl_period_statuses per
535: WHERE i.accumulation_period_type = 'GL'
536: AND p.project_type = pt.project_type
537: AND pt.project_type_class_code = 'CONTRACT'

Line 559: , pa_implementations i

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
563: AND pt.project_type_class_code = 'CONTRACT'

Line 588: Select org_id into x_org_id from pa_implementations;

584: prd_drills_rec4 c_prd_drills4%rowtype;
585:
586: BEGIN
587:
588: Select org_id into x_org_id from pa_implementations;
589:
590: -- high date for pa_org:
591: select per2.start_date
592: into v_pa_org_start_date_high

Line 597: /* Removed the pa_implementations join from the main query and added as subquery Bug # 2634995*/

593: from pa_periods per2
594: where per2.current_pa_period_flag = 'Y';
595:
596: -- low date for pa_org:
597: /* Removed the pa_implementations join from the main query and added as subquery Bug # 2634995*/
598: select DECODE(gl_pt2.number_per_fiscal_year, 52,
599: (ADD_MONTHS(per2.start_date, -3)), 26,
600: (ADD_MONTHS(per2.start_date, -6)),12,
601: (ADD_MONTHS(per2.start_date, -12)),

Line 606: --pa_implementations i2,

602: (ADD_MONTHS(per2.start_date, -3)))
603: into v_pa_org_start_date_low
604: from
605: pa_periods per2,
606: --pa_implementations i2,
607: gl_period_types gl_pt2
608: where
609: per2.current_pa_period_flag = 'Y'
610: --and i2.pa_period_type = gl_pt2.period_type

Line 612: from pa_implementations i2);

608: where
609: per2.current_pa_period_flag = 'Y'
610: --and i2.pa_period_type = gl_pt2.period_type
611: and gl_pt2.period_type = (select i2.pa_period_type
612: from pa_implementations i2);
613:
614: -- low date for gl_org:
615: select ADD_MONTHS(gl_per.start_date, -12)
616: into v_gl_org_start_date_low

Line 618: , pa_implementations pa_i

614: -- low date for gl_org:
615: select ADD_MONTHS(gl_per.start_date, -12)
616: into v_gl_org_start_date_low
617: from gl_period_statuses gl_per
618: , pa_implementations pa_i
619: , pa_periods pa_per
620: where gl_per.application_id = PA_Period_Process_Pkg.Application_ID
621: -- Changed from 101 for PA/GL Period Enhancements
622: and gl_per.set_of_books_id = pa_i.set_of_books_id

Line 630: , pa_implementations pa_i

626: -- high date for gl_org:
627: select gl_per.start_date
628: into v_gl_org_start_date_high
629: from gl_period_statuses gl_per
630: , pa_implementations pa_i
631: , pa_periods pa_per
632: where gl_per.application_id = PA_Period_Process_Pkg.Application_ID
633: -- Changed from 101 for PA/GL Period Enhancements
634: and gl_per.set_of_books_id = pa_i.set_of_books_id