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

Line 5020: gl_period_statuses gl,

5016: BEGIN
5017: SELECT count(*)
5018: INTO l_COUNT
5019: FROM gl_sets_of_books sob,
5020: gl_period_statuses gl,
5021: igc_cc_periods cp
5022: WHERE sob.set_of_books_id = p_sob_id
5023: AND gl.set_of_books_id = sob.set_of_books_id
5024: AND gl.application_id = 101

Line 5220: -- view gl_period_statuses_v with

5216:
5217: IF p_encumbrance_flag = FND_API.G_TRUE THEN
5218: BEGIN
5219: -- Performance Tuning, replaced
5220: -- view gl_period_statuses_v with
5221: -- gl_period_statuses
5222: SELECT count(*)
5223: INTO l_COUNT
5224: FROM gl_sets_of_books sob,

Line 5221: -- gl_period_statuses

5217: IF p_encumbrance_flag = FND_API.G_TRUE THEN
5218: BEGIN
5219: -- Performance Tuning, replaced
5220: -- view gl_period_statuses_v with
5221: -- gl_period_statuses
5222: SELECT count(*)
5223: INTO l_COUNT
5224: FROM gl_sets_of_books sob,
5225: gl_period_statuses gl,

Line 5225: gl_period_statuses gl,

5221: -- gl_period_statuses
5222: SELECT count(*)
5223: INTO l_COUNT
5224: FROM gl_sets_of_books sob,
5225: gl_period_statuses gl,
5226: igc_cc_periods cp
5227: WHERE sob.set_of_books_id = p_sob_id
5228: AND gl.set_of_books_id = sob.set_of_books_id
5229: AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 5325: -- view gl_period_statuses_v with

5321: (l_cc_prov_encmbrnc_flag ='Y' AND l_cc_conf_encmbrnc_flag = 'Y')
5322: THEN
5323: BEGIN
5324: -- Performance Tuning, replaced
5325: -- view gl_period_statuses_v with
5326: -- gl_period_statuses
5327: SELECT count(*)
5328: INTO l_COUNT
5329: FROM gl_sets_of_books sob,

Line 5326: -- gl_period_statuses

5322: THEN
5323: BEGIN
5324: -- Performance Tuning, replaced
5325: -- view gl_period_statuses_v with
5326: -- gl_period_statuses
5327: SELECT count(*)
5328: INTO l_COUNT
5329: FROM gl_sets_of_books sob,
5330: gl_period_statuses gl,

Line 5330: gl_period_statuses gl,

5326: -- gl_period_statuses
5327: SELECT count(*)
5328: INTO l_COUNT
5329: FROM gl_sets_of_books sob,
5330: gl_period_statuses gl,
5331: igc_cc_periods cp
5332: WHERE sob.set_of_books_id = p_sob_id
5333: AND gl.set_of_books_id = sob.set_of_books_id
5334: AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 5376: -- gl_period_statuses_v gl,

5372: -- interested in the fiscal years.
5373: -- SELECT DISTINCT cp.period_year
5374: -- INTO l_orig_fiscal_year
5375: -- FROM gl_sets_of_books sob,
5376: -- gl_period_statuses_v gl,
5377: -- igc_cc_periods_v cp
5378: -- WHERE sob.set_of_books_id = p_sob_id
5379: -- AND gl.set_of_books_id = sob.set_of_books_id
5380: -- AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 5404: -- gl_period_statuses_v gl,

5400: -- interested in the fiscal years.
5401: -- SELECT DISTINCT cp.period_year
5402: -- INTO l_new_fiscal_year
5403: -- FROM gl_sets_of_books sob,
5404: -- gl_period_statuses_v gl,
5405: -- igc_cc_periods_v cp
5406: -- WHERE sob.set_of_books_id = p_sob_id
5407: -- AND gl.set_of_books_id = sob.set_of_books_id
5408: -- AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 5440: -- view gl_period_statuses_v with

5436: ELSIF (p_cc_state = 'CM' OR p_cc_state = 'CT')
5437: THEN
5438: BEGIN
5439: -- Performance Tuning, replaced
5440: -- view gl_period_statuses_v with
5441: -- gl_period_statuses
5442: SELECT count(*)
5443: INTO l_COUNT
5444: FROM gl_sets_of_books sob,

Line 5441: -- gl_period_statuses

5437: THEN
5438: BEGIN
5439: -- Performance Tuning, replaced
5440: -- view gl_period_statuses_v with
5441: -- gl_period_statuses
5442: SELECT count(*)
5443: INTO l_COUNT
5444: FROM gl_sets_of_books sob,
5445: gl_period_statuses gl,

Line 5445: gl_period_statuses gl,

5441: -- gl_period_statuses
5442: SELECT count(*)
5443: INTO l_COUNT
5444: FROM gl_sets_of_books sob,
5445: gl_period_statuses gl,
5446: igc_cc_periods cp
5447: WHERE sob.set_of_books_id = p_sob_id
5448: AND gl.set_of_books_id = sob.set_of_books_id
5449: AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 5546: -- view gl_period_statuses_v with

5542: (l_cc_prov_encmbrnc_flag ='Y' AND l_cc_conf_encmbrnc_flag = 'Y')
5543: THEN
5544: BEGIN
5545: -- Performance Tuning, replaced
5546: -- view gl_period_statuses_v with
5547: -- gl_period_statuses
5548: SELECT count(*)
5549: INTO l_COUNT
5550: FROM gl_sets_of_books sob,

Line 5547: -- gl_period_statuses

5543: THEN
5544: BEGIN
5545: -- Performance Tuning, replaced
5546: -- view gl_period_statuses_v with
5547: -- gl_period_statuses
5548: SELECT count(*)
5549: INTO l_COUNT
5550: FROM gl_sets_of_books sob,
5551: gl_period_statuses gl,

Line 5551: gl_period_statuses gl,

5547: -- gl_period_statuses
5548: SELECT count(*)
5549: INTO l_COUNT
5550: FROM gl_sets_of_books sob,
5551: gl_period_statuses gl,
5552: igc_cc_periods cp
5553: WHERE sob.set_of_books_id = p_sob_id
5554: AND gl.set_of_books_id = sob.set_of_books_id
5555: AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 5596: -- gl_period_statuses_v gl,

5592: -- interested in the fiscal years.
5593: -- SELECT DISTINCT cp.period_year
5594: -- INTO l_orig_fiscal_year
5595: -- FROM gl_sets_of_books sob,
5596: -- gl_period_statuses_v gl,
5597: -- igc_cc_periods_v cp
5598: -- WHERE sob.set_of_books_id = p_sob_id
5599: -- AND gl.set_of_books_id = sob.set_of_books_id
5600: -- AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 5624: -- gl_period_statuses_v gl,

5620: -- interested in the fiscal years.
5621: -- SELECT DISTINCT cp.period_year
5622: -- INTO l_new_fiscal_year
5623: -- FROM gl_sets_of_books sob,
5624: -- gl_period_statuses_v gl,
5625: -- igc_cc_periods_v cp
5626: -- WHERE sob.set_of_books_id = p_sob_id
5627: -- AND gl.set_of_books_id = sob.set_of_books_id
5628: -- AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 5660: -- view gl_period_statuses_v with

5656: ELSIF (p_cc_state = 'CM' OR p_cc_state = 'CT')
5657: THEN
5658: BEGIN
5659: -- Performance Tuning, replaced
5660: -- view gl_period_statuses_v with
5661: -- gl_period_statuses
5662: SELECT count(*)
5663: INTO l_COUNT
5664: FROM gl_sets_of_books sob,

Line 5661: -- gl_period_statuses

5657: THEN
5658: BEGIN
5659: -- Performance Tuning, replaced
5660: -- view gl_period_statuses_v with
5661: -- gl_period_statuses
5662: SELECT count(*)
5663: INTO l_COUNT
5664: FROM gl_sets_of_books sob,
5665: gl_period_statuses gl,

Line 5665: gl_period_statuses gl,

5661: -- gl_period_statuses
5662: SELECT count(*)
5663: INTO l_COUNT
5664: FROM gl_sets_of_books sob,
5665: gl_period_statuses gl,
5666: igc_cc_periods cp
5667: WHERE sob.set_of_books_id = p_sob_id
5668: AND gl.set_of_books_id = sob.set_of_books_id
5669: AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 5941: -- view gl_period_statuses_v with

5937: -- match or mismatch
5938:
5939: BEGIN
5940: -- Performance Tuning, replaced
5941: -- view gl_period_statuses_v with
5942: -- gl_period_statuses
5943: SELECT count(*)
5944: INTO l_COUNT
5945: FROM gl_sets_of_books sob,

Line 5942: -- gl_period_statuses

5938:
5939: BEGIN
5940: -- Performance Tuning, replaced
5941: -- view gl_period_statuses_v with
5942: -- gl_period_statuses
5943: SELECT count(*)
5944: INTO l_COUNT
5945: FROM gl_sets_of_books sob,
5946: gl_period_statuses gl,

Line 5946: gl_period_statuses gl,

5942: -- gl_period_statuses
5943: SELECT count(*)
5944: INTO l_COUNT
5945: FROM gl_sets_of_books sob,
5946: gl_period_statuses gl,
5947: igc_cc_periods cp
5948: WHERE sob.set_of_books_id = p_sob_id
5949: AND gl.set_of_books_id = sob.set_of_books_id
5950: AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 6056: -- gl_period_statuses_v gl,

6052: -- interested in the fiscal years.
6053: -- SELECT DISTINCT cp.period_year
6054: -- INTO l_orig_fiscal_year
6055: -- FROM gl_sets_of_books sob,
6056: -- gl_period_statuses_v gl,
6057: -- igc_cc_periods_v cp
6058: -- WHERE sob.set_of_books_id = p_sob_id
6059: -- AND gl.set_of_books_id = sob.set_of_books_id
6060: -- AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 6085: -- gl_period_statuses_v gl,

6081: -- interested in the fiscal years.
6082: -- SELECT DISTINCT cp.period_year
6083: -- INTO l_new_fiscal_year
6084: -- FROM gl_sets_of_books sob,
6085: -- gl_period_statuses_v gl,
6086: -- igc_cc_periods_v cp
6087: -- WHERE sob.set_of_books_id = p_sob_id
6088: -- AND gl.set_of_books_id = sob.set_of_books_id
6089: -- AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 6291: -- view gl_period_statuses_v with

6287: -- match or mismatch
6288:
6289: BEGIN
6290: -- Performance Tuning, replaced
6291: -- view gl_period_statuses_v with
6292: -- gl_period_statuses
6293: SELECT count(*)
6294: INTO l_COUNT
6295: FROM gl_sets_of_books sob,

Line 6292: -- gl_period_statuses

6288:
6289: BEGIN
6290: -- Performance Tuning, replaced
6291: -- view gl_period_statuses_v with
6292: -- gl_period_statuses
6293: SELECT count(*)
6294: INTO l_COUNT
6295: FROM gl_sets_of_books sob,
6296: gl_period_statuses gl,

Line 6296: gl_period_statuses gl,

6292: -- gl_period_statuses
6293: SELECT count(*)
6294: INTO l_COUNT
6295: FROM gl_sets_of_books sob,
6296: gl_period_statuses gl,
6297: igc_cc_periods cp
6298: WHERE sob.set_of_books_id = p_sob_id
6299: AND gl.set_of_books_id = sob.set_of_books_id
6300: AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 6406: -- gl_period_statuses_v gl,

6402: -- interested in the fiscal years.
6403: -- SELECT DISTINCT cp.period_year
6404: -- INTO l_orig_fiscal_year
6405: -- FROM gl_sets_of_books sob,
6406: -- gl_period_statuses_v gl,
6407: -- igc_cc_periods_v cp
6408: -- WHERE sob.set_of_books_id = p_sob_id
6409: -- AND gl.set_of_books_id = sob.set_of_books_id
6410: -- AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 6435: -- gl_period_statuses_v gl,

6431: -- interested in the fiscal years.
6432: -- SELECT DISTINCT cp.period_year
6433: -- INTO l_new_fiscal_year
6434: -- FROM gl_sets_of_books sob,
6435: -- gl_period_statuses_v gl,
6436: -- igc_cc_periods_v cp
6437: -- WHERE sob.set_of_books_id = p_sob_id
6438: -- AND gl.set_of_books_id = sob.set_of_books_id
6439: -- AND gl.application_id = l_gl_application_id -- Bug 1830385