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_PERIOD_PROCESS_PKG

Line 52: AND per.application_id = PA_Period_Process_Pkg.Application_ID

48: AND p.project_type = pt.project_type
49: AND pt.project_type_class_code = 'CONTRACT'
50: AND ta.project_id = p.project_id
51: AND ta.gl_period = per.period_name
52: AND per.application_id = PA_Period_Process_Pkg.Application_ID
53: -- Changed from 101 for PA/GL Period Enhancements
54: AND per.set_of_books_id = i.set_of_books_id
55: AND per.adjustment_period_flag = 'N'
56: AND per.start_date <= v_gl_org_start_date_high

Line 105: AND per.application_id = PA_Period_Process_Pkg.Application_ID

101: AND pt.project_type_class_code = 'CONTRACT'
102: AND p.project_id = bpa.project_id
103: AND bpa.budget_type_code in ('AR','AC')
104: AND bpa.gl_period_name = per.period_name
105: AND per.application_id = PA_Period_Process_Pkg.Application_ID
106: -- Changed from 101 for PA/GL Period Enhancements
107: AND per.set_of_books_id = i.set_of_books_id
108: AND per.adjustment_period_flag = 'N'
109: AND per.start_date <= v_gl_org_start_date_high

Line 153: AND per.application_id = PA_Period_Process_Pkg.Application_ID

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'
153: AND per.application_id = PA_Period_Process_Pkg.Application_ID
154: -- Changed from 101 for PA/GL Period Enhancements
155: AND per.set_of_books_id = i.set_of_books_id
156: AND per.adjustment_period_flag = 'N'
157: AND per.start_date <= v_gl_org_start_date_high

Line 342: AND per.application_id = PA_Period_Process_Pkg.Application_ID

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
343: -- Changed from 101 for PA/GL Period Enhancements
344: AND per.set_of_books_id = i.set_of_books_id
345: AND p.project_id = pc.project_id
346: AND pc.class_category = cc.class_category

Line 376: AND per.application_id = PA_Period_Process_Pkg.Application_ID

372: AND p.project_type = pt.project_type
373: AND pt.project_type_class_code = 'CONTRACT'
374: AND ta.project_id = p.project_id
375: AND ta.gl_period = per.period_name
376: AND per.application_id = PA_Period_Process_Pkg.Application_ID
377: -- Changed from 101 for PA/GL Period Enhancements
378: AND per.set_of_books_id = i.set_of_books_id
379: AND p.project_id = pc.project_id
380: AND pc.class_category = cc.class_category

Line 411: AND per.application_id = PA_Period_Process_Pkg.Application_ID

407: AND pt.project_type_class_code = 'CONTRACT'
408: AND p.project_id = bpa.project_id
409: AND bpa.budget_type_code in ('AR','AC')
410: AND bpa.gl_period_name = per.period_name
411: AND per.application_id = PA_Period_Process_Pkg.Application_ID
412: -- Changed from 101 for PA/GL Period Enhancements
413: AND per.set_of_books_id = i.set_of_books_id
414: AND p.project_id = pc.project_id
415: AND pc.class_category = cc.class_category

Line 514: AND per.application_id = PA_Period_Process_Pkg.Application_ID

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
516: AND per.set_of_books_id = i.set_of_books_id
517: AND per.adjustment_period_flag = 'N'
518: AND per.start_date <= v_gl_org_start_date_high

Line 540: AND per.application_id = PA_Period_Process_Pkg.Application_ID

536: AND p.project_type = pt.project_type
537: AND pt.project_type_class_code = 'CONTRACT'
538: AND ta.project_id = p.project_id
539: AND ta.gl_period = per.period_name
540: AND per.application_id = PA_Period_Process_Pkg.Application_ID
541: -- Changed from 101 for PA/GL Period Enhancements
542: AND per.set_of_books_id = i.set_of_books_id
543: AND per.adjustment_period_flag = 'N'
544: AND per.start_date <= v_gl_org_start_date_high

Line 567: AND per.application_id = PA_Period_Process_Pkg.Application_ID

563: AND pt.project_type_class_code = 'CONTRACT'
564: AND p.project_id = bpa.project_id
565: AND bpa.budget_type_code in ('AR','AC')
566: AND bpa.gl_period_name = per.period_name
567: AND per.application_id = PA_Period_Process_Pkg.Application_ID
568: -- Changed from 101 for PA/GL Period Enhancements
569: AND per.set_of_books_id = i.set_of_books_id
570: AND per.adjustment_period_flag = 'N'
571: AND per.start_date <= v_gl_org_start_date_high

Line 620: where gl_per.application_id = PA_Period_Process_Pkg.Application_ID

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
624: and pa_per.current_pa_period_flag = 'Y';

Line 632: where gl_per.application_id = PA_Period_Process_Pkg.Application_ID

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
636: and pa_per.current_pa_period_flag = 'Y';