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 5078: gl_period_statuses gl,

5074: BEGIN
5075: SELECT count(*)
5076: INTO l_COUNT
5077: FROM gl_sets_of_books sob,
5078: gl_period_statuses gl,
5079: igc_cc_periods cp
5080: WHERE sob.set_of_books_id = p_sob_id
5081: AND gl.set_of_books_id = sob.set_of_books_id
5082: AND gl.application_id = 101

Line 5278: -- view gl_period_statuses_v with

5274:
5275: IF p_encumbrance_flag = FND_API.G_TRUE THEN
5276: BEGIN
5277: -- Performance Tuning, replaced
5278: -- view gl_period_statuses_v with
5279: -- gl_period_statuses
5280: SELECT count(*)
5281: INTO l_COUNT
5282: FROM gl_sets_of_books sob,

Line 5279: -- gl_period_statuses

5275: IF p_encumbrance_flag = FND_API.G_TRUE THEN
5276: BEGIN
5277: -- Performance Tuning, replaced
5278: -- view gl_period_statuses_v with
5279: -- gl_period_statuses
5280: SELECT count(*)
5281: INTO l_COUNT
5282: FROM gl_sets_of_books sob,
5283: gl_period_statuses gl,

Line 5283: gl_period_statuses gl,

5279: -- gl_period_statuses
5280: SELECT count(*)
5281: INTO l_COUNT
5282: FROM gl_sets_of_books sob,
5283: gl_period_statuses gl,
5284: igc_cc_periods cp
5285: WHERE sob.set_of_books_id = p_sob_id
5286: AND gl.set_of_books_id = sob.set_of_books_id
5287: AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 5383: -- view gl_period_statuses_v with

5379: (l_cc_prov_encmbrnc_flag ='Y' AND l_cc_conf_encmbrnc_flag = 'Y')
5380: THEN
5381: BEGIN
5382: -- Performance Tuning, replaced
5383: -- view gl_period_statuses_v with
5384: -- gl_period_statuses
5385: SELECT count(*)
5386: INTO l_COUNT
5387: FROM gl_sets_of_books sob,

Line 5384: -- gl_period_statuses

5380: THEN
5381: BEGIN
5382: -- Performance Tuning, replaced
5383: -- view gl_period_statuses_v with
5384: -- gl_period_statuses
5385: SELECT count(*)
5386: INTO l_COUNT
5387: FROM gl_sets_of_books sob,
5388: gl_period_statuses gl,

Line 5388: gl_period_statuses gl,

5384: -- gl_period_statuses
5385: SELECT count(*)
5386: INTO l_COUNT
5387: FROM gl_sets_of_books sob,
5388: gl_period_statuses gl,
5389: igc_cc_periods cp
5390: WHERE sob.set_of_books_id = p_sob_id
5391: AND gl.set_of_books_id = sob.set_of_books_id
5392: AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 5434: -- gl_period_statuses_v gl,

5430: -- interested in the fiscal years.
5431: -- SELECT DISTINCT cp.period_year
5432: -- INTO l_orig_fiscal_year
5433: -- FROM gl_sets_of_books sob,
5434: -- gl_period_statuses_v gl,
5435: -- igc_cc_periods_v cp
5436: -- WHERE sob.set_of_books_id = p_sob_id
5437: -- AND gl.set_of_books_id = sob.set_of_books_id
5438: -- AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 5462: -- gl_period_statuses_v gl,

5458: -- interested in the fiscal years.
5459: -- SELECT DISTINCT cp.period_year
5460: -- INTO l_new_fiscal_year
5461: -- FROM gl_sets_of_books sob,
5462: -- gl_period_statuses_v gl,
5463: -- igc_cc_periods_v cp
5464: -- WHERE sob.set_of_books_id = p_sob_id
5465: -- AND gl.set_of_books_id = sob.set_of_books_id
5466: -- AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 5498: -- view gl_period_statuses_v with

5494: ELSIF (p_cc_state = 'CM' OR p_cc_state = 'CT')
5495: THEN
5496: BEGIN
5497: -- Performance Tuning, replaced
5498: -- view gl_period_statuses_v with
5499: -- gl_period_statuses
5500: SELECT count(*)
5501: INTO l_COUNT
5502: FROM gl_sets_of_books sob,

Line 5499: -- gl_period_statuses

5495: THEN
5496: BEGIN
5497: -- Performance Tuning, replaced
5498: -- view gl_period_statuses_v with
5499: -- gl_period_statuses
5500: SELECT count(*)
5501: INTO l_COUNT
5502: FROM gl_sets_of_books sob,
5503: gl_period_statuses gl,

Line 5503: gl_period_statuses gl,

5499: -- gl_period_statuses
5500: SELECT count(*)
5501: INTO l_COUNT
5502: FROM gl_sets_of_books sob,
5503: gl_period_statuses gl,
5504: igc_cc_periods cp
5505: WHERE sob.set_of_books_id = p_sob_id
5506: AND gl.set_of_books_id = sob.set_of_books_id
5507: AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 5604: -- view gl_period_statuses_v with

5600: (l_cc_prov_encmbrnc_flag ='Y' AND l_cc_conf_encmbrnc_flag = 'Y')
5601: THEN
5602: BEGIN
5603: -- Performance Tuning, replaced
5604: -- view gl_period_statuses_v with
5605: -- gl_period_statuses
5606: SELECT count(*)
5607: INTO l_COUNT
5608: FROM gl_sets_of_books sob,

Line 5605: -- gl_period_statuses

5601: THEN
5602: BEGIN
5603: -- Performance Tuning, replaced
5604: -- view gl_period_statuses_v with
5605: -- gl_period_statuses
5606: SELECT count(*)
5607: INTO l_COUNT
5608: FROM gl_sets_of_books sob,
5609: gl_period_statuses gl,

Line 5609: gl_period_statuses gl,

5605: -- gl_period_statuses
5606: SELECT count(*)
5607: INTO l_COUNT
5608: FROM gl_sets_of_books sob,
5609: gl_period_statuses gl,
5610: igc_cc_periods cp
5611: WHERE sob.set_of_books_id = p_sob_id
5612: AND gl.set_of_books_id = sob.set_of_books_id
5613: AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 5654: -- gl_period_statuses_v gl,

5650: -- interested in the fiscal years.
5651: -- SELECT DISTINCT cp.period_year
5652: -- INTO l_orig_fiscal_year
5653: -- FROM gl_sets_of_books sob,
5654: -- gl_period_statuses_v gl,
5655: -- igc_cc_periods_v cp
5656: -- WHERE sob.set_of_books_id = p_sob_id
5657: -- AND gl.set_of_books_id = sob.set_of_books_id
5658: -- AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 5682: -- gl_period_statuses_v gl,

5678: -- interested in the fiscal years.
5679: -- SELECT DISTINCT cp.period_year
5680: -- INTO l_new_fiscal_year
5681: -- FROM gl_sets_of_books sob,
5682: -- gl_period_statuses_v gl,
5683: -- igc_cc_periods_v cp
5684: -- WHERE sob.set_of_books_id = p_sob_id
5685: -- AND gl.set_of_books_id = sob.set_of_books_id
5686: -- AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 5718: -- view gl_period_statuses_v with

5714: ELSIF (p_cc_state = 'CM' OR p_cc_state = 'CT')
5715: THEN
5716: BEGIN
5717: -- Performance Tuning, replaced
5718: -- view gl_period_statuses_v with
5719: -- gl_period_statuses
5720: SELECT count(*)
5721: INTO l_COUNT
5722: FROM gl_sets_of_books sob,

Line 5719: -- gl_period_statuses

5715: THEN
5716: BEGIN
5717: -- Performance Tuning, replaced
5718: -- view gl_period_statuses_v with
5719: -- gl_period_statuses
5720: SELECT count(*)
5721: INTO l_COUNT
5722: FROM gl_sets_of_books sob,
5723: gl_period_statuses gl,

Line 5723: gl_period_statuses gl,

5719: -- gl_period_statuses
5720: SELECT count(*)
5721: INTO l_COUNT
5722: FROM gl_sets_of_books sob,
5723: gl_period_statuses gl,
5724: igc_cc_periods cp
5725: WHERE sob.set_of_books_id = p_sob_id
5726: AND gl.set_of_books_id = sob.set_of_books_id
5727: AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 6001: -- view gl_period_statuses_v with

5997: NVL(l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_amt,0) ) THEN -- Added for Bug 9366764
5998:
5999: BEGIN
6000: -- Performance Tuning, replaced
6001: -- view gl_period_statuses_v with
6002: -- gl_period_statuses
6003: SELECT count(*)
6004: INTO l_COUNT
6005: FROM gl_sets_of_books sob,

Line 6002: -- gl_period_statuses

5998:
5999: BEGIN
6000: -- Performance Tuning, replaced
6001: -- view gl_period_statuses_v with
6002: -- gl_period_statuses
6003: SELECT count(*)
6004: INTO l_COUNT
6005: FROM gl_sets_of_books sob,
6006: gl_period_statuses gl,

Line 6006: gl_period_statuses gl,

6002: -- gl_period_statuses
6003: SELECT count(*)
6004: INTO l_COUNT
6005: FROM gl_sets_of_books sob,
6006: gl_period_statuses gl,
6007: igc_cc_periods cp
6008: WHERE sob.set_of_books_id = p_sob_id
6009: AND gl.set_of_books_id = sob.set_of_books_id
6010: AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 6116: -- gl_period_statuses_v gl,

6112: -- interested in the fiscal years.
6113: -- SELECT DISTINCT cp.period_year
6114: -- INTO l_orig_fiscal_year
6115: -- FROM gl_sets_of_books sob,
6116: -- gl_period_statuses_v gl,
6117: -- igc_cc_periods_v cp
6118: -- WHERE sob.set_of_books_id = p_sob_id
6119: -- AND gl.set_of_books_id = sob.set_of_books_id
6120: -- AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 6145: -- gl_period_statuses_v gl,

6141: -- interested in the fiscal years.
6142: -- SELECT DISTINCT cp.period_year
6143: -- INTO l_new_fiscal_year
6144: -- FROM gl_sets_of_books sob,
6145: -- gl_period_statuses_v gl,
6146: -- igc_cc_periods_v cp
6147: -- WHERE sob.set_of_books_id = p_sob_id
6148: -- AND gl.set_of_books_id = sob.set_of_books_id
6149: -- AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 6353: -- view gl_period_statuses_v with

6349: NVL(l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_amt,0) ) THEN
6350:
6351: BEGIN
6352: -- Performance Tuning, replaced
6353: -- view gl_period_statuses_v with
6354: -- gl_period_statuses
6355: SELECT count(*)
6356: INTO l_COUNT
6357: FROM gl_sets_of_books sob,

Line 6354: -- gl_period_statuses

6350:
6351: BEGIN
6352: -- Performance Tuning, replaced
6353: -- view gl_period_statuses_v with
6354: -- gl_period_statuses
6355: SELECT count(*)
6356: INTO l_COUNT
6357: FROM gl_sets_of_books sob,
6358: gl_period_statuses gl,

Line 6358: gl_period_statuses gl,

6354: -- gl_period_statuses
6355: SELECT count(*)
6356: INTO l_COUNT
6357: FROM gl_sets_of_books sob,
6358: gl_period_statuses gl,
6359: igc_cc_periods cp
6360: WHERE sob.set_of_books_id = p_sob_id
6361: AND gl.set_of_books_id = sob.set_of_books_id
6362: AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 6468: -- gl_period_statuses_v gl,

6464: -- interested in the fiscal years.
6465: -- SELECT DISTINCT cp.period_year
6466: -- INTO l_orig_fiscal_year
6467: -- FROM gl_sets_of_books sob,
6468: -- gl_period_statuses_v gl,
6469: -- igc_cc_periods_v cp
6470: -- WHERE sob.set_of_books_id = p_sob_id
6471: -- AND gl.set_of_books_id = sob.set_of_books_id
6472: -- AND gl.application_id = l_gl_application_id -- Bug 1830385

Line 6497: -- gl_period_statuses_v gl,

6493: -- interested in the fiscal years.
6494: -- SELECT DISTINCT cp.period_year
6495: -- INTO l_new_fiscal_year
6496: -- FROM gl_sets_of_books sob,
6497: -- gl_period_statuses_v gl,
6498: -- igc_cc_periods_v cp
6499: -- WHERE sob.set_of_books_id = p_sob_id
6500: -- AND gl.set_of_books_id = sob.set_of_books_id
6501: -- AND gl.application_id = l_gl_application_id -- Bug 1830385