APPS.PA_BIS_SUMMARY dependencies on GL_PERIOD_STATUSES

Line 46: , gl_period_statuses per

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

Line 98: , gl_period_statuses per

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

Line 149: , gl_period_statuses per

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'
153: AND per.application_id = PA_Period_Process_Pkg.Application_ID

Line 336: , gl_period_statuses per

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

Line 368: , gl_period_statuses per

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

Line 402: , gl_period_statuses per

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

Line 512: , gl_period_statuses per

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
516: AND per.set_of_books_id = i.set_of_books_id

Line 534: , gl_period_statuses per

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

Line 560: , gl_period_statuses per

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

Line 617: from gl_period_statuses gl_per

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

Line 629: from gl_period_statuses gl_per

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