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.XLA_BALANCES_CALC_PKG dependencies on GL_PERIOD_STATUSES

Line 229: , gl_period_statuses gps

225: , g_application_array
226: , g_accounting_batch_array
227: FROM xla_ae_headers xah
228: , xla_ae_lines xal
229: , gl_period_statuses gps
230: , xla_ledger_relationships_v xlr
231: WHERE xah.application_id = p_application_id
232: AND xah.ledger_id = p_ledger_id
233: AND xah.ae_header_id = xal.ae_header_id

Line 534: , gl_period_statuses gps

530: FROM xla_ae_headers aeh
531: , xla_ae_lines ael
532: , xla_ae_line_acs acs
533: , xla_analytical_hdrs_b xbh
534: , gl_period_statuses gps
535: , xla_ledger_options xlo
536: , xla_ledger_relationships_v xlr
537: $bal_concurrency$
538: WHERE aeh.application_id = :'||l_summary_bind_count||'

Line 986: FROM gl_period_statuses gps

982: , tmp.ac5
983: , gps.period_name
984: , gps.effective_period_num
985: , gps.period_year
986: FROM gl_period_statuses gps
987: ,xla_analytical_hdrs_b xbh --Bug13498442
988: , gl_code_combinations gcc --Bug13498442
989: , xla_ac_bal_interim_gt tmp
990: , xla_ledger_options xlo

Line 1268: , gl_period_statuses gps

1264: , '||g_req_id||'
1265: FROM xla_ac_bal_interim_gt temp
1266: , xla_analytical_hdrs_b xbh
1267: , gl_code_combinations gcc
1268: , gl_period_statuses gps
1269: , xla_ledger_relationships_v xlr
1270: WHERE xlr.ledger_id = temp.ledger_id
1271: AND gps.ledger_id = DECODE(xlr.ledger_category_code,''ALC''
1272: ,xlr.primary_ledger_id , temp.ledger_id)

Line 1372: , gl_period_statuses gps

1368: ael.ae_header_id
1369: ,ael.ae_line_num
1370: FROM xla_ae_headers aeh
1371: , xla_ae_lines ael
1372: , gl_period_statuses gps
1373: , xla_ledger_options xlo
1374: , xla_ledger_relationships_v xlr
1375: $bal_concurrency$
1376: WHERE aeh.accounting_entry_status_code = ''F''

Line 1634: , gl_period_statuses gps

1630: , $period_balance_cr$
1631: , SUBSTR (gps.effective_period_num, 1, 4) period_year
1632: FROM xla_ae_headers aeh
1633: , xla_ae_lines ael
1634: , gl_period_statuses gps
1635: , xla_ledger_options xlo
1636: , xla_ledger_relationships_v xlr
1637: $bal_concurrency$
1638: WHERE aeh.application_id = :'||l_summary_bind_count||'

Line 2033: FROM gl_period_statuses gps

2029: , tmp.beginning_balance_cr
2030: , gps.period_name
2031: , gps.effective_period_num
2032: , gps.period_year
2033: FROM gl_period_statuses gps
2034: , xla_ctrl_bal_interim_gt tmp
2035: , xla_ledger_options xlo
2036: , xla_ledger_relationships_v xlr
2037: WHERE gps.effective_period_num <= xlo.effective_period_num

Line 2260: , gl_period_statuses gps

2256: , '||g_prog_appl_id||'
2257: , '||g_prog_id||'
2258: , '||g_req_id||'
2259: FROM xla_ctrl_bal_interim_gt temp
2260: , gl_period_statuses gps
2261: , xla_ledger_relationships_v xlr
2262: WHERE xlr.ledger_id = temp.ledger_id
2263: AND gps.ledger_id = DECODE(xlr.ledger_category_code, ''ALC''
2264: ,xlr.primary_ledger_id , xlr.ledger_id)

Line 2343: , gl_period_statuses gps

2339: ael.ae_header_id
2340: ,ael.ae_line_num
2341: FROM xla_ae_headers aeh
2342: , xla_ae_lines ael
2343: , gl_period_statuses gps
2344: , xla_ledger_options xlo
2345: , xla_ledger_relationships_v xlr
2346: $bal_concurrency$
2347: WHERE aeh.accounting_entry_status_code = ''F''

Line 2648: FROM gl_period_statuses gps

2644: )
2645: FROM (
2646: SELECT DISTINCT xlo.effective_period_num xlo_effective_period_num
2647: ,(SELECT MAX(gps.effective_period_num)
2648: FROM gl_period_statuses gps
2649: WHERE gps.application_id = 101
2650: AND gps.ledger_id = xlo.ledger_id
2651: AND gps.closing_status IN (''O'',''C'',''P'')
2652: AND gps.adjustment_period_flag = ''N''

Line 2669: FROM gl_period_statuses gps

2665: )
2666: FROM (
2667: SELECT DISTINCT xlo.effective_period_num xlo_effective_period_num
2668: ,(SELECT MAX(gps.effective_period_num)
2669: FROM gl_period_statuses gps
2670: WHERE gps.application_id = 101
2671: AND gps.ledger_id = xlo.ledger_id
2672: AND gps.closing_status IN (''O'',''C'',''P'')
2673: AND gps.adjustment_period_flag = ''N''

Line 2921: FROM gl_period_statuses

2917:
2918: -- Validate the Target Period
2919: SELECT count(1)
2920: INTO l_count
2921: FROM gl_period_statuses
2922: WHERE application_id=101
2923: AND ledger_id = p_ledger_id
2924: AND effective_period_num = p_effective_period_num
2925: AND closing_status in ('O','C','P')

Line 3094: FROM gl_period_statuses gps

3090: ,g_date
3091: ,g_prog_appl_id
3092: ,g_prog_id
3093: ,g_req_id
3094: FROM gl_period_statuses gps
3095: , xla_ac_balances bal
3096: , gl_code_combinations gcc
3097: , xla_analytical_hdrs_b xbh
3098: , (select ledger_id

Line 3240: FROM gl_period_statuses gps

3236: ,g_date
3237: ,g_prog_appl_id
3238: ,g_prog_id
3239: ,g_req_id
3240: FROM gl_period_statuses gps
3241: , xla_control_balances bal
3242: ,(select ledger_id
3243: from xla_ledger_relationships_v
3244: where (ledger_category_code IN ('PRIMARY','ALC')

Line 3368: FROM gl_period_statuses gps

3364: IS
3365: SELECT l.ledger_category_code
3366: , gps.effective_period_num
3367: , adjustment_period_flag -- Bug 12613841
3368: FROM gl_period_statuses gps
3369: , gl_ledgers l
3370: WHERE l.ledger_id = p_ledger_id
3371: AND gps.ledger_id = l.ledger_id
3372: AND gps.application_id = 101

Line 3458: FROM gl_period_statuses gps,gl_ledgers gll

3454: IF l_xlo_not_nul_count > 0 THEN -- added Bug12613841
3455:
3456: UPDATE xla_ledger_options xlo
3457: SET effective_period_num = (SELECT gps.effective_period_num
3458: FROM gl_period_statuses gps,gl_ledgers gll
3459: WHERE gps.application_id= 101
3460: AND gps.ledger_id = xlo.ledger_id
3461: AND gll.ledger_id = xlo.ledger_id
3462: AND gps.period_name = gll.FIRST_LEDGER_PERIOD_NAME

Line 3478: FROM gl_period_statuses gps

3474: -- Begin Bug 13928188
3475:
3476: UPDATE xla_ac_balances xab
3477: SET EFFECTIVE_PERIOD_NUM = ( SELECT gps.effective_period_num
3478: FROM gl_period_statuses gps
3479: WHERE gps.ledger_id = xab.ledger_id
3480: AND gps.application_id = 101
3481: AND gps.adjustment_period_flag = 'N'
3482: AND gps.period_name = xab.period_name

Line 3506: FROM gl_period_statuses gps

3502:
3503:
3504: UPDATE xla_control_balances xab
3505: SET EFFECTIVE_PERIOD_NUM = ( SELECT gps.effective_period_num
3506: FROM gl_period_statuses gps
3507: WHERE gps.ledger_id = xab.ledger_id
3508: AND gps.application_id = 101
3509: AND gps.adjustment_period_flag = 'N'
3510: AND gps.period_name=xab.period_name

Line 3576: FROM gl_period_statuses gps

3572: -- Begin Bug 13928188
3573:
3574: UPDATE xla_ac_balances xab
3575: SET EFFECTIVE_PERIOD_NUM = ( SELECT gps.effective_period_num
3576: FROM gl_period_statuses gps
3577: WHERE gps.ledger_id = xab.ledger_id
3578: AND gps.application_id = 101
3579: AND gps.adjustment_period_flag = 'N'
3580: AND gps.period_name = xab.period_name

Line 3604: FROM gl_period_statuses gps

3600:
3601:
3602: UPDATE xla_control_balances xab
3603: SET EFFECTIVE_PERIOD_NUM = ( SELECT gps.effective_period_num
3604: FROM gl_period_statuses gps
3605: WHERE gps.ledger_id = xab.ledger_id
3606: AND gps.application_id = 101
3607: AND gps.adjustment_period_flag = 'N'
3608: AND gps.period_name=xab.period_name

Line 4913: ,gl_period_statuses gps1

4909: FROM dual
4910: where exists(select 1
4911: from xla_ae_lines xal
4912: ,xla_ae_line_acs xac
4913: ,gl_period_statuses gps1
4914: ,gl_period_statuses gps2
4915: ,xla_ae_headers xah
4916: where xah.application_id = :'||to_number(l_bind_count)||'
4917: and xah.ledger_id = :'||to_number(l_bind_count+1)||'

Line 4914: ,gl_period_statuses gps2

4910: where exists(select 1
4911: from xla_ae_lines xal
4912: ,xla_ae_line_acs xac
4913: ,gl_period_statuses gps1
4914: ,gl_period_statuses gps2
4915: ,xla_ae_headers xah
4916: where xah.application_id = :'||to_number(l_bind_count)||'
4917: and xah.ledger_id = :'||to_number(l_bind_count+1)||'
4918: and xah.accounting_date between gps1.start_date and gps2.end_date