[Home] [Help]
4975:
4976: BEGIN
4977: SELECT count(*)
4978: INTO l_COUNT
4979: FROM gl_sets_of_books sob, gl_periods gp, igc_cc_periods cp
4980: WHERE sob.set_of_books_id = p_sob_id
4981: AND sob.period_set_name = gp.period_set_name
4982: AND cp.org_id = p_org_id
4983: AND gp.period_set_name = cp.period_set_name
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
5025: AND cp.org_id = p_org_id
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
5230: AND cp.org_id = p_org_id
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
5335: AND cp.org_id = p_org_id
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
5381: -- AND cp.org_id = p_org_id
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
5409: -- AND cp.org_id = p_org_id
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
5450: AND cp.org_id = p_org_id
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
5556: AND cp.org_id = p_org_id
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
5601: -- AND cp.org_id = p_org_id
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
5629: -- AND cp.org_id = p_org_id
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
5670: AND cp.org_id = p_org_id
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
5951: AND cp.org_id = p_org_id
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
6061: -- AND cp.org_id = p_org_id
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
6090: -- AND cp.org_id = p_org_id
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
6301: AND cp.org_id = p_org_id
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
6411: -- AND cp.org_id = p_org_id
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
6440: -- AND cp.org_id = p_org_id