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_PERIODS

Line 74: , pa_periods per

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'
78: AND ta.project_id = p.project_id

Line 174: , pa_periods per

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'
178: AND per.start_date <= v_pa_org_start_date_high

Line 221: pa_periods per ,

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
225: i.accumulation_period_type = 'PA' AND

Line 249: pa_periods per ,

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
253: i.accumulation_period_type = 'PA'

Line 453: FROM pa_periods per

449: , 0 ACT_COST
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

Line 472: , pa_periods per

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'
476: AND ta.project_id = p.project_id

Line 593: from pa_periods per2

589:
590: -- high date for pa_org:
591: select per2.start_date
592: into v_pa_org_start_date_high
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*/

Line 605: pa_periods per2,

601: (ADD_MONTHS(per2.start_date, -12)),
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'

Line 619: , pa_periods pa_per

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
623: and pa_per.gl_period_name = gl_per.period_name

Line 631: , pa_periods pa_per

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
635: and pa_per.gl_period_name = gl_per.period_name