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 480: FROM gl_period_statuses gpssource

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

Line 481: ,gl_period_statuses gpsdest

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

Line 491: FROM gl_period_statuses gps2

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

Line 1159: FROM gl_period_statuses gps

1155: END IF;
1156:
1157: SELECT MAX(gps.effective_period_num)
1158: INTO l_latest_effective_period_num
1159: FROM gl_period_statuses gps
1160: WHERE gps.ledger_id = p_ledger_id
1161: AND gps.application_id = 101
1162: AND gps.closing_status IN ('O', 'C', 'P')
1163: AND gps.adjustment_period_flag = 'N';

Line 1177: FROM gl_period_statuses gps

1173:
1174: l_return_value :=TRUE;
1175:
1176: FOR i IN ( SELECT gps.effective_period_num
1177: FROM gl_period_statuses gps
1178: WHERE gps.ledger_id = p_ledger_id
1179: AND gps.application_id = 101
1180: AND gps.closing_status IN ('O', 'C', 'P')
1181: AND gps.adjustment_period_flag = 'N'

Line 1500: FROM gl_period_statuses gps2

1496: END IF;
1497:
1498: SELECT MAX(gps2.effective_period_num)
1499: INTO l_latest_open_eff_period_num
1500: FROM gl_period_statuses gps2
1501: WHERE gps2.ledger_id = i.ledger_id
1502: AND gps2.application_id = 101
1503: AND gps2.closing_status IN ('O', 'C', 'P')
1504: AND gps2.adjustment_period_flag = 'N';

Line 2238: from xla_control_balances xcb, gl_period_statuses gps

2234: l_begin_bal_cr := null; --7608545 - Reset begin_bal_cr to null
2235: FOR j IN (select nvl(beginning_balance_dr,0) + nvl(period_balance_dr,0) begin_dr
2236: ,nvl(beginning_balance_cr,0) + nvl(period_balance_cr,0) begin_cr
2237: from(select xcb.*
2238: from xla_control_balances xcb, gl_period_statuses gps
2239: where xcb.application_id = la_application_id(i)
2240: and xcb.application_id = gps.application_id
2241: and xcb.ledger_id = gps.ledger_id
2242: and xcb.ledger_id = la_ledger_id(i)

Line 3481: FROM gl_period_statuses gps2

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

Line 3499: ,gl_period_statuses gpsbs

3495: ,l_prog_appl_id
3496: ,l_prog_id
3497: ,NVL(l_req_id, -1)
3498: FROM xla_balance_statuses xbs
3499: ,gl_period_statuses gpsbs
3500: ,xla_control_balances xba
3501: ,gl_period_statuses gpsnew
3502: WHERE xbs.application_id = p_application_id
3503: AND xbs.ledger_id = p_ledger_id

Line 3501: ,gl_period_statuses gpsnew

3497: ,NVL(l_req_id, -1)
3498: FROM xla_balance_statuses xbs
3499: ,gl_period_statuses gpsbs
3500: ,xla_control_balances xba
3501: ,gl_period_statuses gpsnew
3502: WHERE xbs.application_id = p_application_id
3503: AND xbs.ledger_id = p_ledger_id
3504: AND xbs.balance_source_code = 'C'
3505: AND xbs.effective_period_num < p_dest_effective_period_num

Line 3525: ,gl_period_statuses gpsint

3521: AND gpsnew.effective_period_num >
3522: (
3523: SELECT MAX(effective_period_num)
3524: FROM xla_control_balances xbanew
3525: ,gl_period_statuses gpsint
3526: WHERE xbanew.ledger_id = p_ledger_id
3527: AND xbanew.application_id = p_application_id
3528: AND xbanew.code_combination_id = p_code_combination_id
3529: AND xbanew.party_type_code = p_party_type_code

Line 3638: FROM gl_period_statuses gps2

3634: ,NULL
3635: ,'Y'
3636: ,'N'
3637: )
3638: FROM gl_period_statuses gps2
3639: WHERE gps2.ledger_id = ledger_id
3640: AND gps2.application_id = 101
3641: AND gps2.closing_status IN ('O','C','P')
3642: AND gps2.adjustment_period_flag = 'N'

Line 3656: ,gl_period_statuses gpsbs

3652: ,l_prog_appl_id
3653: ,l_prog_id
3654: ,NVL(l_req_id, -1)
3655: FROM xla_balance_statuses xbs
3656: ,gl_period_statuses gpsbs
3657: ,xla_ac_balances xba
3658: ,gl_period_statuses gpsnew
3659: ,xla_analytical_hdrs_b xbh
3660: WHERE xbs.application_id = p_application_id

Line 3658: ,gl_period_statuses gpsnew

3654: ,NVL(l_req_id, -1)
3655: FROM xla_balance_statuses xbs
3656: ,gl_period_statuses gpsbs
3657: ,xla_ac_balances xba
3658: ,gl_period_statuses gpsnew
3659: ,xla_analytical_hdrs_b xbh
3660: WHERE xbs.application_id = p_application_id
3661: AND xbs.ledger_id = p_ledger_id
3662: AND xbs.balance_source_code = 'A'

Line 3698: ,gl_period_statuses gpsint

3694: AND gpsnew.effective_period_num >
3695: (
3696: SELECT MAX(effective_period_num)
3697: FROM xla_ac_balances xbanew
3698: ,gl_period_statuses gpsint
3699: WHERE xbanew.ledger_id = p_ledger_id
3700: AND xbanew.application_id = p_application_id
3701: AND xbanew.code_combination_id = p_code_combination_id
3702: AND gpsint.ledger_id = p_ledger_id

Line 4040: ,gl_period_statuses gps

4036: ,ael.accounted_dr
4037: ,ael.accounted_cr
4038: FROM xla_ae_headers aeh
4039: ,xla_ae_lines ael
4040: ,gl_period_statuses gps
4041: WHERE ael.ae_header_id = aeh.ae_header_id
4042: AND ael.application_id = aeh.application_id
4043: AND gps.ledger_id = aeh.ledger_id
4044: AND gps.application_id = 101

Line 4315: ,gl_period_statuses gps

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

Line 4359: ,gl_period_statuses gps

4355: ,ael.accounted_cr
4356: FROM xla_events xev
4357: ,xla_ae_headers aeh
4358: ,xla_ae_lines ael
4359: ,gl_period_statuses gps
4360: WHERE xev.request_id = p_request_id
4361: AND xev.application_id = p_application_id
4362: AND xev.process_status_code IN ('D', 'P')
4363: AND aeh.event_id = xev.event_id

Line 4401: ,gl_period_statuses gps

4397: ,ael.accounted_dr
4398: ,ael.accounted_cr
4399: FROM xla_ae_headers aeh
4400: ,xla_ae_lines ael
4401: ,gl_period_statuses gps
4402: WHERE aeh.application_id = p_application_id
4403: AND aeh.entity_id = p_entity_id
4404: AND ael.ae_header_id = aeh.ae_header_id
4405: AND ael.application_id = aeh.application_id

Line 4542: ,gl_period_statuses gps

4538: FROM xla_events_gt xeg
4539: ,xla_events xe
4540: ,xla_ae_headers aeh
4541: ,xla_ae_lines ael
4542: ,gl_period_statuses gps
4543: WHERE xeg.application_id = p_application_id
4544: AND aeh.application_id = xeg.application_id
4545: AND aeh.event_id = xeg.event_id
4546: AND xe.event_id = xeg.event_id

Line 4667: ,gl_period_statuses gps

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

Line 4788: ,gl_period_statuses gps

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

Line 5630: FROM gl_period_statuses gps2

5626: ,( SELECT NVL2( MAX(gps2.effective_period_num)
5627: ,'N'
5628: ,'Y'
5629: )
5630: FROM gl_period_statuses gps2
5631: WHERE gps2.application_id = 101
5632: AND gps2.ledger_id = gps.ledger_id
5633: AND gps2.closing_status IN ('O','C','P')
5634: AND gps2.adjustment_period_flag = 'N'

Line 5638: FROM gl_period_statuses gps

5634: AND gps2.adjustment_period_flag = 'N'
5635: AND gps2.period_year = gps.period_year
5636: AND gps2.effective_period_num < gps.effective_period_num
5637: ) first_period_in_year_flag
5638: FROM gl_period_statuses gps
5639: WHERE gps.application_id = 101
5640: AND gps.ledger_id = p_ledger_id
5641: AND gps.closing_status IN ('O','C','P')
5642: AND gps.adjustment_period_flag = 'N'

Line 5680: FROM gl_period_statuses gps2

5676: ,( SELECT NVL2( MAX(gps2.effective_period_num)
5677: ,'N'
5678: ,'Y'
5679: )
5680: FROM gl_period_statuses gps2
5681: WHERE gps2.application_id = 101
5682: AND gps2.ledger_id = gps.ledger_id
5683: AND gps2.closing_status IN ('O','C','P')
5684: AND gps2.adjustment_period_flag = 'N'

Line 5688: FROM gl_period_statuses gps

5684: AND gps2.adjustment_period_flag = 'N'
5685: AND gps2.period_year = gps.period_year
5686: AND gps2.effective_period_num < gps.effective_period_num
5687: ) first_period_in_year_flag
5688: FROM gl_period_statuses gps
5689: WHERE gps.application_id = 101
5690: AND gps.ledger_id = p_ledger_id
5691: AND gps.closing_status IN ('O','C','P')
5692: AND gps.adjustment_period_flag = 'N'

Line 5728: FROM gl_period_statuses gps2

5724: ,( SELECT NVL2( MAX(gps2.effective_period_num)
5725: ,'N'
5726: ,'Y'
5727: )
5728: FROM gl_period_statuses gps2
5729: WHERE gps2.application_id = 101
5730: AND gps2.ledger_id = gps.ledger_id
5731: AND gps2.closing_status IN ('O','C','P')
5732: AND gps2.adjustment_period_flag = 'N'

Line 5736: FROM gl_period_statuses gps

5732: AND gps2.adjustment_period_flag = 'N'
5733: AND gps2.period_year = gps.period_year
5734: AND gps2.effective_period_num < gps.effective_period_num
5735: ) first_period_in_year_flag
5736: FROM gl_period_statuses gps
5737: WHERE gps.application_id = 101
5738: AND gps.ledger_id = p_ledger_id
5739: AND gps.closing_status IN ('O','C','P')
5740: AND gps.adjustment_period_flag = 'N'

Line 5777: FROM gl_period_statuses gps2

5773: ,( SELECT NVL2( MAX(gps2.effective_period_num)
5774: ,'N'
5775: ,'Y'
5776: )
5777: FROM gl_period_statuses gps2
5778: WHERE gps2.application_id = 101
5779: AND gps2.ledger_id = gps.ledger_id
5780: AND gps2.closing_status IN ('O','C','P')
5781: AND gps2.adjustment_period_flag = 'N'

Line 5785: FROM gl_period_statuses gps

5781: AND gps2.adjustment_period_flag = 'N'
5782: AND gps2.period_year = gps.period_year
5783: AND gps2.effective_period_num < gps.effective_period_num
5784: ) first_period_in_year_flag
5785: FROM gl_period_statuses gps
5786: WHERE gps.application_id = 101
5787: AND gps.ledger_id = p_ledger_id
5788: AND gps.closing_status IN ('O','C','P')
5789: AND gps.adjustment_period_flag = 'N'

Line 6814: ,gl_period_statuses gps

6810: FROM xla_bal_ctrl_lines_gt xbct
6811: )
6812: AND EXISTS (SELECT 1
6813: FROM xla_ae_headers aeh
6814: ,gl_period_statuses gps
6815: WHERE ael.ae_header_id = aeh.ae_header_id
6816: AND aeh.application_id = ael.application_id
6817: AND gps.application_id = 101
6818: AND gps.period_name = aeh.period_name

Line 6969: ,gl_period_statuses gps

6965: FROM xla_bal_anacri_lines_gt xbct
6966: )
6967: AND EXISTS (SELECT 1
6968: FROM xla_ae_headers aeh
6969: ,gl_period_statuses gps
6970: WHERE ael.ae_header_id = aeh.ae_header_id
6971: AND aeh.application_id = ael.application_id
6972: AND gps.application_id = 101
6973: AND gps.period_name = aeh.period_name

Line 7891: ,gl_period_statuses gps

7887: WHERE xcbext.ROWID IN
7888: ( SELECT xcb.ROWID
7889: FROM xla_balance_statuses xbs
7890: ,xla_control_balances xcb
7891: ,gl_period_statuses gps
7892: WHERE xbs.balance_source_code = 'C'
7893: AND xbs.balance_status_code = 'R'
7894: AND xbs.request_id = NVL(l_req_id, -1)
7895: AND xcb.initial_balance_flag = 'N'

Line 7951: ,gl_period_statuses gps

7947: WHERE xabext.ROWID IN
7948: ( SELECT xab.ROWID
7949: FROM xla_balance_statuses xbs
7950: ,xla_ac_balances xab
7951: ,gl_period_statuses gps
7952: WHERE xbs.balance_source_code = 'A'
7953: AND xbs.balance_status_code = 'R'
7954: AND xbs.request_id = NVL(l_req_id, -1)
7955: AND xab.initial_balance_flag = 'N'

Line 8001: ,gl_period_statuses gps

7997: (SELECT xal.ROWID
7998: FROM xla_balance_statuses xbs
7999: ,xla_ae_headers xah
8000: ,xla_ae_lines xal
8001: ,gl_period_statuses gps
8002: WHERE xbs.balance_status_code = 'R'
8003: AND xbs.balance_source_code = 'C'
8004: AND xbs.request_id = NVL(l_req_id, -1)
8005: AND xah.ledger_id = xbs.ledger_id

Line 8060: ,gl_period_statuses gps

8056: (SELECT xal.ROWID
8057: FROM xla_balance_statuses xbs
8058: ,xla_ae_headers xah
8059: ,xla_ae_lines xal
8060: ,gl_period_statuses gps
8061: WHERE xbs.balance_status_code = 'R'
8062: AND xbs.balance_source_code = 'A'
8063: AND xbs.request_id = NVL(l_req_id, -1)
8064: AND xah.ledger_id = xbs.ledger_id

Line 8107: FROM gl_period_statuses gps

8103: ,MAX(gps.effective_period_num)
8104: )
8105: ,xbs.effective_period_num
8106: )
8107: FROM gl_period_statuses gps
8108: WHERE gps.ledger_id = xbs.ledger_id
8109: AND gps.application_id = 101
8110: AND gps.closing_status IN ('O', 'C', 'P')
8111: AND gps.adjustment_period_flag = 'N'

Line 8189: FROM gl_period_statuses gps2

8185:
8186: FOR i IN ( SELECT gps.period_name
8187: ,gps.effective_period_num
8188: ,( SELECT MAX(gps2.effective_period_num)
8189: FROM gl_period_statuses gps2
8190: WHERE gps2.ledger_id = l_current_ledger_id
8191: AND gps2.application_id = 101
8192: AND gps2.effective_period_num < gps.effective_period_num
8193: AND gps2.closing_status IN ('O', 'C', 'P')

Line 8196: FROM gl_period_statuses gps

8192: AND gps2.effective_period_num < gps.effective_period_num
8193: AND gps2.closing_status IN ('O', 'C', 'P')
8194: AND gps2.adjustment_period_flag = 'N'
8195: ) previous_effective_period_num
8196: FROM gl_period_statuses gps
8197: WHERE gps.ledger_id = l_current_ledger_id
8198: AND gps.application_id = 101
8199: AND gps.closing_status IN ('O', 'C', 'P')
8200: AND gps.adjustment_period_flag = 'N'

Line 8518: FROM gl_period_statuses gps

8514: IF p_starting_period_name IS NOT NULL
8515: THEN
8516: SELECT gps.effective_period_num
8517: INTO l_starting_eff_period_num
8518: FROM gl_period_statuses gps
8519: WHERE gps.ledger_id = p_ledger_id
8520: AND gps.application_id = 101
8521: AND gps.period_name = p_starting_period_name;
8522: END IF;

Line 8664: FROM gl_period_statuses gps

8660: ,xbsext.recreate_effective_period_num = DECODE( xbsext.balance_status_code
8661: ,'A'
8662: ,NVL( l_starting_eff_period_num
8663: ,(SELECT MIN(effective_period_num)
8664: FROM gl_period_statuses gps
8665: WHERE gps.ledger_id = xbsext.ledger_id
8666: AND gps.application_id = 101
8667: AND gps.closing_status IN ('O', 'C', 'P')
8668: AND gps.adjustment_period_flag = 'N'

Line 8836: FROM gl_period_statuses gps

8832: AND p_starting_period_name IS NOT NULL
8833: THEN
8834: SELECT gps.effective_period_num
8835: INTO l_starting_eff_period_num
8836: FROM gl_period_statuses gps
8837: WHERE gps.ledger_id = p_ledger_id
8838: AND gps.application_id = 101
8839: AND gps.period_name = p_starting_period_name;
8840: END IF;

Line 8871: FROM gl_period_statuses gps

8867: ,xbsext.recreate_effective_period_num = DECODE( xbsext.balance_status_code
8868: ,'A'
8869: ,NVL( l_starting_eff_period_num
8870: ,(SELECT MIN(effective_period_num)
8871: FROM gl_period_statuses gps
8872: WHERE gps.ledger_id = xbsext.ledger_id
8873: AND gps.application_id = 101
8874: AND gps.closing_status IN ('O', 'C', 'P')
8875: AND gps.adjustment_period_flag = 'N'

Line 10204: FROM gl_period_statuses gps

10200: SELECT gps.effective_period_num
10201: ,gps.start_date
10202: INTO l_effective_period_num
10203: ,l_period_start_date
10204: FROM gl_period_statuses gps
10205: WHERE gps.ledger_id = p_ledger_id
10206: AND gps.period_name = p_period_name
10207: AND gps.application_id = 101;
10208:

Line 10293: FROM gl_period_statuses gps

10289: END IF;
10290:
10291: SELECT MIN(gps.effective_period_num)
10292: INTO l_first_entry_eff_period_num
10293: FROM gl_period_statuses gps
10294: ,xla_ae_headers xah
10295: ,xla_ae_lines xal
10296: WHERE gps.ledger_id = p_ledger_id
10297: AND gps.application_id = 101