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 IGC_CC_PERIODS

Line 5037: FROM gl_sets_of_books sob, gl_periods gp, igc_cc_periods cp

5033:
5034: BEGIN
5035: SELECT count(*)
5036: INTO l_COUNT
5037: FROM gl_sets_of_books sob, gl_periods gp, igc_cc_periods cp
5038: WHERE sob.set_of_books_id = p_sob_id
5039: AND sob.period_set_name = gp.period_set_name
5040: AND cp.org_id = p_org_id
5041: AND gp.period_set_name = cp.period_set_name

Line 5079: igc_cc_periods cp

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
5083: AND cp.org_id = p_org_id

Line 5284: igc_cc_periods cp

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
5288: AND cp.org_id = p_org_id

Line 5389: igc_cc_periods cp

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
5393: AND cp.org_id = p_org_id

Line 5435: -- igc_cc_periods_v cp

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
5439: -- AND cp.org_id = p_org_id

Line 5463: -- igc_cc_periods_v cp

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
5467: -- AND cp.org_id = p_org_id

Line 5504: igc_cc_periods cp

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
5508: AND cp.org_id = p_org_id

Line 5610: igc_cc_periods cp

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
5614: AND cp.org_id = p_org_id

Line 5655: -- igc_cc_periods_v cp

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
5659: -- AND cp.org_id = p_org_id

Line 5683: -- igc_cc_periods_v cp

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
5687: -- AND cp.org_id = p_org_id

Line 5724: igc_cc_periods cp

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
5728: AND cp.org_id = p_org_id

Line 6007: igc_cc_periods cp

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
6011: AND cp.org_id = p_org_id

Line 6117: -- igc_cc_periods_v cp

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
6121: -- AND cp.org_id = p_org_id

Line 6146: -- igc_cc_periods_v cp

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
6150: -- AND cp.org_id = p_org_id

Line 6359: igc_cc_periods cp

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
6363: AND cp.org_id = p_org_id

Line 6469: -- igc_cc_periods_v cp

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
6473: -- AND cp.org_id = p_org_id

Line 6498: -- igc_cc_periods_v cp

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
6502: -- AND cp.org_id = p_org_id