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_PKG dependencies on GL_PERIOD_STATUSES

Line 481: FROM gl_period_statuses gpssource

477: ,l_dest_period_name
478: ,l_dest_effective_period_num
479: ,l_dest_period_year
480: ,l_dest_first_period_flag
481: FROM gl_period_statuses gpssource
482: ,gl_period_statuses gpsdest
483: WHERE gpssource.ledger_id = p_ledger_id
484: AND gpssource.application_id = 101
485: AND gpssource.closing_status IN ('O', 'C', 'P')

Line 482: ,gl_period_statuses gpsdest

478: ,l_dest_effective_period_num
479: ,l_dest_period_year
480: ,l_dest_first_period_flag
481: FROM gl_period_statuses gpssource
482: ,gl_period_statuses gpsdest
483: WHERE gpssource.ledger_id = p_ledger_id
484: AND gpssource.application_id = 101
485: AND gpssource.closing_status IN ('O', 'C', 'P')
486: AND gpssource.adjustment_period_flag = 'N'

Line 492: FROM gl_period_statuses gps2

488: AND gpsdest.ledger_id = p_ledger_id
489: AND gpsdest.application_id = 101
490: AND gpsdest.effective_period_num =
491: ( SELECT MIN(gps2.effective_period_num)
492: FROM gl_period_statuses gps2
493: WHERE gps2.ledger_id = p_ledger_id
494: AND gps2.application_id = 101
495: AND gps2.effective_period_num > p_source_effective_period_num
496: AND gps2.closing_status IN ('O', 'C', 'P')

Line 1148: FROM gl_period_statuses gps

1144: END IF;
1145:
1146: SELECT MAX(gps.effective_period_num)
1147: INTO l_latest_effective_period_num
1148: FROM gl_period_statuses gps
1149: WHERE gps.ledger_id = p_ledger_id
1150: AND gps.application_id = 101
1151: AND gps.closing_status IN ('O', 'C', 'P')
1152: AND gps.adjustment_period_flag = 'N';

Line 1166: FROM gl_period_statuses gps

1162:
1163: l_return_value :=TRUE;
1164:
1165: FOR i IN ( SELECT gps.effective_period_num
1166: FROM gl_period_statuses gps
1167: WHERE gps.ledger_id = p_ledger_id
1168: AND gps.application_id = 101
1169: AND gps.closing_status IN ('O', 'C', 'P')
1170: AND gps.adjustment_period_flag = 'N'

Line 1489: FROM gl_period_statuses gps2

1485: END IF;
1486:
1487: SELECT MAX(gps2.effective_period_num)
1488: INTO l_latest_open_eff_period_num
1489: FROM gl_period_statuses gps2
1490: WHERE gps2.ledger_id = i.ledger_id
1491: AND gps2.application_id = 101
1492: AND gps2.closing_status IN ('O', 'C', 'P')
1493: AND gps2.adjustment_period_flag = 'N';

Line 2227: from xla_control_balances xcb, gl_period_statuses gps

2223: l_begin_bal_cr := null; --7608545 - Reset begin_bal_cr to null
2224: FOR j IN (select nvl(beginning_balance_dr,0) + nvl(period_balance_dr,0) begin_dr
2225: ,nvl(beginning_balance_cr,0) + nvl(period_balance_cr,0) begin_cr
2226: from(select xcb.*
2227: from xla_control_balances xcb, gl_period_statuses gps
2228: where xcb.application_id = la_application_id(i)
2229: and xcb.application_id = gps.application_id
2230: and xcb.ledger_id = gps.ledger_id
2231: and xcb.ledger_id = la_ledger_id(i)

Line 3484: FROM gl_period_statuses gps2

3480: ,NULL
3481: ,'Y'
3482: ,'N'
3483: )
3484: FROM gl_period_statuses gps2
3485: WHERE gps2.ledger_id = ledger_id
3486: AND gps2.application_id = 101
3487: AND gps2.closing_status IN ('O','C','P')
3488: AND gps2.adjustment_period_flag = 'N'

Line 3503: ,gl_period_statuses gpsbs

3499: ,l_prog_id
3500: ,NVL(l_req_id, -1)
3501: ,gpsbs.effective_period_num
3502: FROM xla_balance_statuses xbs
3503: ,gl_period_statuses gpsbs
3504: ,xla_control_balances xba
3505: ,gl_period_statuses gpsnew
3506: WHERE xbs.application_id = p_application_id
3507: AND xbs.ledger_id = p_ledger_id

Line 3505: ,gl_period_statuses gpsnew

3501: ,gpsbs.effective_period_num
3502: FROM xla_balance_statuses xbs
3503: ,gl_period_statuses gpsbs
3504: ,xla_control_balances xba
3505: ,gl_period_statuses gpsnew
3506: WHERE xbs.application_id = p_application_id
3507: AND xbs.ledger_id = p_ledger_id
3508: AND xbs.balance_source_code = 'C'
3509: AND xbs.effective_period_num < p_dest_effective_period_num

Line 3529: ,gl_period_statuses gpsint

3525: AND gpsnew.effective_period_num >
3526: (
3527: SELECT MAX(gpsint.effective_period_num)
3528: FROM xla_control_balances xbanew
3529: ,gl_period_statuses gpsint
3530: WHERE xbanew.ledger_id = p_ledger_id
3531: AND xbanew.application_id = p_application_id
3532: AND xbanew.code_combination_id = p_code_combination_id
3533: AND xbanew.party_type_code = p_party_type_code

Line 3643: FROM gl_period_statuses gps2

3639: ,NULL
3640: ,'Y'
3641: ,'N'
3642: )
3643: FROM gl_period_statuses gps2
3644: WHERE gps2.ledger_id = ledger_id
3645: AND gps2.application_id = 101
3646: AND gps2.closing_status IN ('O','C','P')
3647: AND gps2.adjustment_period_flag = 'N'

Line 3662: ,gl_period_statuses gpsbs

3658: ,l_prog_id
3659: ,NVL(l_req_id, -1)
3660: ,gpsbs.effective_period_num
3661: FROM xla_balance_statuses xbs
3662: ,gl_period_statuses gpsbs
3663: ,xla_ac_balances xba
3664: ,gl_period_statuses gpsnew
3665: ,xla_analytical_hdrs_b xbh
3666: WHERE xbs.application_id = p_application_id

Line 3664: ,gl_period_statuses gpsnew

3660: ,gpsbs.effective_period_num
3661: FROM xla_balance_statuses xbs
3662: ,gl_period_statuses gpsbs
3663: ,xla_ac_balances xba
3664: ,gl_period_statuses gpsnew
3665: ,xla_analytical_hdrs_b xbh
3666: WHERE xbs.application_id = p_application_id
3667: AND xbs.ledger_id = p_ledger_id
3668: AND xbs.balance_source_code = 'A'

Line 3704: ,gl_period_statuses gpsint

3700: AND gpsnew.effective_period_num >
3701: (
3702: SELECT MAX(gpsint.effective_period_num)
3703: FROM xla_ac_balances xbanew
3704: ,gl_period_statuses gpsint
3705: WHERE xbanew.ledger_id = p_ledger_id
3706: AND xbanew.application_id = p_application_id
3707: AND xbanew.code_combination_id = p_code_combination_id
3708: AND gpsint.ledger_id = p_ledger_id

Line 4047: ,gl_period_statuses gps

4043: ,ael.accounted_dr
4044: ,ael.accounted_cr
4045: FROM xla_ae_headers aeh
4046: ,xla_ae_lines ael
4047: ,gl_period_statuses gps
4048: WHERE ael.ae_header_id = aeh.ae_header_id
4049: AND ael.application_id = aeh.application_id
4050: AND gps.ledger_id = aeh.ledger_id
4051: AND gps.application_id = 101

Line 4311: ,gl_period_statuses gps

4307: FROM xla_events xev
4308: ,xla_events_gt xeg
4309: ,xla_ae_headers aeh
4310: ,xla_ae_lines ael
4311: ,gl_period_statuses gps
4312: WHERE xev.application_id = p_application_id
4313: AND xeg.event_id = xev.event_id
4314: AND xeg.application_id = xev.application_id
4315: AND xev.process_status_code in ('D', 'I')

Line 4355: ,gl_period_statuses gps

4351: ,ael.accounted_cr
4352: FROM xla_events xev
4353: ,xla_ae_headers aeh
4354: ,xla_ae_lines ael
4355: ,gl_period_statuses gps
4356: WHERE xev.request_id = p_request_id
4357: AND xev.application_id = p_application_id
4358: AND xev.process_status_code = 'P'
4359: AND aeh.event_id = xev.event_id

Line 4397: ,gl_period_statuses gps

4393: ,ael.accounted_dr
4394: ,ael.accounted_cr
4395: FROM xla_ae_headers aeh
4396: ,xla_ae_lines ael
4397: ,gl_period_statuses gps
4398: WHERE aeh.application_id = p_application_id
4399: AND aeh.entity_id = p_entity_id
4400: AND ael.ae_header_id = aeh.ae_header_id
4401: AND ael.application_id = aeh.application_id

Line 4538: ,gl_period_statuses gps

4534: FROM xla_events_gt xeg
4535: ,xla_events xe
4536: ,xla_ae_headers aeh
4537: ,xla_ae_lines ael
4538: ,gl_period_statuses gps
4539: WHERE xeg.application_id = p_application_id
4540: AND aeh.application_id = xeg.application_id
4541: AND aeh.event_id = xeg.event_id
4542: AND xe.event_id = xeg.event_id

Line 4666: ,gl_period_statuses gps

4662: ,ael.accounted_cr
4663: FROM xla_events xev
4664: ,xla_ae_headers aeh
4665: ,xla_ae_lines ael
4666: ,gl_period_statuses gps
4667: WHERE xev.request_id = p_request_id
4668: AND xev.application_id = p_application_id
4669: AND xev.process_status_code = 'P'
4670: AND aeh.application_id = xev.application_id

Line 4790: ,gl_period_statuses gps

4786: ,ael.accounted_dr
4787: ,ael.accounted_cr
4788: FROM xla_ae_headers aeh
4789: ,xla_ae_lines ael
4790: ,gl_period_statuses gps
4791: WHERE aeh.application_id = p_application_id
4792: AND aeh.entity_id = p_entity_id
4793: AND ael.ae_header_id = aeh.ae_header_id
4794: AND ael.application_id = aeh.application_id

Line 5649: FROM gl_period_statuses gps2

5645: ,( SELECT NVL2( MAX(gps2.effective_period_num)
5646: ,'N'
5647: ,'Y'
5648: )
5649: FROM gl_period_statuses gps2
5650: WHERE gps2.application_id = 101
5651: AND gps2.ledger_id = gps.ledger_id
5652: AND gps2.closing_status IN ('O','C','P')
5653: AND gps2.adjustment_period_flag = 'N'

Line 5657: FROM gl_period_statuses gps

5653: AND gps2.adjustment_period_flag = 'N'
5654: AND gps2.period_year = gps.period_year
5655: AND gps2.effective_period_num < gps.effective_period_num
5656: ) first_period_in_year_flag
5657: FROM gl_period_statuses gps
5658: WHERE gps.application_id = 101
5659: AND gps.ledger_id = p_ledger_id
5660: AND gps.closing_status IN ('O','C','P')
5661: AND gps.adjustment_period_flag = 'N'

Line 5699: FROM gl_period_statuses gps2

5695: ,( SELECT NVL2( MAX(gps2.effective_period_num)
5696: ,'N'
5697: ,'Y'
5698: )
5699: FROM gl_period_statuses gps2
5700: WHERE gps2.application_id = 101
5701: AND gps2.ledger_id = gps.ledger_id
5702: AND gps2.closing_status IN ('O','C','P')
5703: AND gps2.adjustment_period_flag = 'N'

Line 5707: FROM gl_period_statuses gps

5703: AND gps2.adjustment_period_flag = 'N'
5704: AND gps2.period_year = gps.period_year
5705: AND gps2.effective_period_num < gps.effective_period_num
5706: ) first_period_in_year_flag
5707: FROM gl_period_statuses gps
5708: WHERE gps.application_id = 101
5709: AND gps.ledger_id = p_ledger_id
5710: AND gps.closing_status IN ('O','C','P')
5711: AND gps.adjustment_period_flag = 'N'

Line 5747: FROM gl_period_statuses gps2

5743: ,( SELECT NVL2( MAX(gps2.effective_period_num)
5744: ,'N'
5745: ,'Y'
5746: )
5747: FROM gl_period_statuses gps2
5748: WHERE gps2.application_id = 101
5749: AND gps2.ledger_id = gps.ledger_id
5750: AND gps2.closing_status IN ('O','C','P')
5751: AND gps2.adjustment_period_flag = 'N'

Line 5755: FROM gl_period_statuses gps

5751: AND gps2.adjustment_period_flag = 'N'
5752: AND gps2.period_year = gps.period_year
5753: AND gps2.effective_period_num < gps.effective_period_num
5754: ) first_period_in_year_flag
5755: FROM gl_period_statuses gps
5756: WHERE gps.application_id = 101
5757: AND gps.ledger_id = p_ledger_id
5758: AND gps.closing_status IN ('O','C','P')
5759: AND gps.adjustment_period_flag = 'N'

Line 5796: FROM gl_period_statuses gps2

5792: ,( SELECT NVL2( MAX(gps2.effective_period_num)
5793: ,'N'
5794: ,'Y'
5795: )
5796: FROM gl_period_statuses gps2
5797: WHERE gps2.application_id = 101
5798: AND gps2.ledger_id = gps.ledger_id
5799: AND gps2.closing_status IN ('O','C','P')
5800: AND gps2.adjustment_period_flag = 'N'

Line 5804: FROM gl_period_statuses gps

5800: AND gps2.adjustment_period_flag = 'N'
5801: AND gps2.period_year = gps.period_year
5802: AND gps2.effective_period_num < gps.effective_period_num
5803: ) first_period_in_year_flag
5804: FROM gl_period_statuses gps
5805: WHERE gps.application_id = 101
5806: AND gps.ledger_id = p_ledger_id
5807: AND gps.closing_status IN ('O','C','P')
5808: AND gps.adjustment_period_flag = 'N'

Line 6834: FROM gl_period_statuses gps

6830: (SELECT /*+ leading(XBCT) */ xbct.line_rowid
6831: FROM xla_bal_ctrl_lines_gt xbct
6832: WHERE EXISTS
6833: (SELECT /*+ no_unnest */ 1
6834: FROM gl_period_statuses gps
6835: WHERE gps.application_id = 101
6836: AND gps.period_name = xbct.period_name
6837: AND gps.ledger_id = xbct.ledger_id
6838: AND gps.closing_status IN ('O','C','P'))

Line 8069: ,gl_period_statuses gps

8065: WHERE xcbext.ROWID IN
8066: ( SELECT xcb.ROWID
8067: FROM xla_balance_statuses xbs
8068: ,xla_control_balances xcb
8069: ,gl_period_statuses gps
8070: WHERE xbs.balance_source_code = 'C'
8071: AND xbs.balance_status_code = 'R'
8072: AND xbs.request_id = NVL(l_req_id, -1)
8073: AND xcb.initial_balance_flag = 'N'

Line 8129: ,gl_period_statuses gps

8125: WHERE xabext.ROWID IN
8126: ( SELECT xab.ROWID
8127: FROM xla_balance_statuses xbs
8128: ,xla_ac_balances xab
8129: ,gl_period_statuses gps
8130: WHERE xbs.balance_source_code = 'A'
8131: AND xbs.balance_status_code = 'R'
8132: AND xbs.request_id = NVL(l_req_id, -1)
8133: AND xab.initial_balance_flag = 'N'

Line 8179: ,gl_period_statuses gps

8175: (SELECT xal.ROWID
8176: FROM xla_balance_statuses xbs
8177: ,xla_ae_headers xah
8178: ,xla_ae_lines xal
8179: ,gl_period_statuses gps
8180: WHERE xbs.balance_status_code = 'R'
8181: AND xbs.balance_source_code = 'C'
8182: AND xbs.request_id = NVL(l_req_id, -1)
8183: AND xah.ledger_id = xbs.ledger_id

Line 8238: ,gl_period_statuses gps

8234: (SELECT xal.ROWID
8235: FROM xla_balance_statuses xbs
8236: ,xla_ae_headers xah
8237: ,xla_ae_lines xal
8238: ,gl_period_statuses gps
8239: WHERE xbs.balance_status_code = 'R'
8240: AND xbs.balance_source_code = 'A'
8241: AND xbs.request_id = NVL(l_req_id, -1)
8242: AND xah.ledger_id = xbs.ledger_id

Line 8285: FROM gl_period_statuses gps

8281: ,MAX(gps.effective_period_num)
8282: )
8283: ,xbs.effective_period_num
8284: )
8285: FROM gl_period_statuses gps
8286: WHERE gps.ledger_id = xbs.ledger_id
8287: AND gps.application_id = 101
8288: AND gps.closing_status IN ('O', 'C', 'P')
8289: AND gps.adjustment_period_flag = 'N'

Line 8367: FROM gl_period_statuses gps2

8363:
8364: FOR i IN ( SELECT gps.period_name
8365: ,gps.effective_period_num
8366: ,( SELECT MAX(gps2.effective_period_num)
8367: FROM gl_period_statuses gps2
8368: WHERE gps2.ledger_id = l_current_ledger_id
8369: AND gps2.application_id = 101
8370: AND gps2.effective_period_num < gps.effective_period_num
8371: AND gps2.closing_status IN ('O', 'C', 'P')

Line 8374: FROM gl_period_statuses gps

8370: AND gps2.effective_period_num < gps.effective_period_num
8371: AND gps2.closing_status IN ('O', 'C', 'P')
8372: AND gps2.adjustment_period_flag = 'N'
8373: ) previous_effective_period_num
8374: FROM gl_period_statuses gps
8375: WHERE gps.ledger_id = l_current_ledger_id
8376: AND gps.application_id = 101
8377: AND gps.closing_status IN ('O', 'C', 'P')
8378: AND gps.adjustment_period_flag = 'N'

Line 8697: FROM gl_period_statuses gps

8693: IF p_starting_period_name IS NOT NULL
8694: THEN
8695: SELECT gps.effective_period_num
8696: INTO l_starting_eff_period_num
8697: FROM gl_period_statuses gps
8698: WHERE gps.ledger_id = p_ledger_id
8699: AND gps.application_id = 101
8700: AND gps.period_name = p_starting_period_name;
8701: END IF;

Line 8843: FROM gl_period_statuses gps

8839: ,xbsext.recreate_effective_period_num = DECODE( xbsext.balance_status_code
8840: ,'A'
8841: ,NVL( l_starting_eff_period_num
8842: ,(SELECT MIN(effective_period_num)
8843: FROM gl_period_statuses gps
8844: WHERE gps.ledger_id = xbsext.ledger_id
8845: AND gps.application_id = 101
8846: AND gps.closing_status IN ('O', 'C', 'P')
8847: AND gps.adjustment_period_flag = 'N'

Line 9015: FROM gl_period_statuses gps

9011: AND p_starting_period_name IS NOT NULL
9012: THEN
9013: SELECT gps.effective_period_num
9014: INTO l_starting_eff_period_num
9015: FROM gl_period_statuses gps
9016: WHERE gps.ledger_id = p_ledger_id
9017: AND gps.application_id = 101
9018: AND gps.period_name = p_starting_period_name;
9019: END IF;

Line 9050: FROM gl_period_statuses gps

9046: ,xbsext.recreate_effective_period_num = DECODE( xbsext.balance_status_code
9047: ,'A'
9048: ,NVL( l_starting_eff_period_num
9049: ,(SELECT MIN(effective_period_num)
9050: FROM gl_period_statuses gps
9051: WHERE gps.ledger_id = xbsext.ledger_id
9052: AND gps.application_id = 101
9053: AND gps.closing_status IN ('O', 'C', 'P')
9054: AND gps.adjustment_period_flag = 'N'

Line 10393: FROM gl_period_statuses gps

10389: SELECT gps.effective_period_num
10390: ,gps.start_date
10391: INTO l_effective_period_num
10392: ,l_period_start_date
10393: FROM gl_period_statuses gps
10394: WHERE gps.ledger_id = p_ledger_id
10395: AND gps.period_name = p_period_name
10396: AND gps.application_id = 101;
10397:

Line 10482: FROM gl_period_statuses gps

10478: END IF;
10479:
10480: SELECT MIN(gps.effective_period_num)
10481: INTO l_first_entry_eff_period_num
10482: FROM gl_period_statuses gps
10483: ,xla_ae_headers xah
10484: ,xla_ae_lines xal
10485: WHERE gps.ledger_id = p_ledger_id
10486: AND gps.application_id = 101