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_PERIODS

Line 4757: l_orig_fiscal_year gl_periods.period_year%TYPE;

4753: -- l_cc_prov_encmbrnc_flag igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_enable_flag%TYPE := 'N';
4754: -- l_cc_conf_encmbrnc_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE := 'N';
4755: l_cc_prov_encmbrnc_flag VARCHAR2(1);
4756: l_cc_conf_encmbrnc_flag VARCHAR2(1);
4757: l_orig_fiscal_year gl_periods.period_year%TYPE;
4758: l_new_fiscal_year gl_periods.period_year%TYPE;
4759:
4760: l_COUNT NUMBER;
4761: l_min_rel_start_date DATE;

Line 4758: l_new_fiscal_year gl_periods.period_year%TYPE;

4754: -- l_cc_conf_encmbrnc_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE := 'N';
4755: l_cc_prov_encmbrnc_flag VARCHAR2(1);
4756: l_cc_conf_encmbrnc_flag VARCHAR2(1);
4757: l_orig_fiscal_year gl_periods.period_year%TYPE;
4758: l_new_fiscal_year gl_periods.period_year%TYPE;
4759:
4760: l_COUNT NUMBER;
4761: l_min_rel_start_date DATE;
4762: l_cover_start_date DATE;

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 5447: gl_periods gl

5443: -- );
5444: SELECT distinct gl.period_year
5445: INTO l_orig_fiscal_year
5446: FROM gl_sets_of_books sob,
5447: gl_periods gl
5448: WHERE sob.set_of_books_id = p_sob_id
5449: AND gl.period_set_name= sob.period_set_name
5450: AND gl.period_type = sob.accounted_period_type
5451: AND (p_prev_acct_date between gl.start_date and gl.end_date);

Line 5475: gl_periods gl

5471: -- );
5472: SELECT distinct gl.period_year
5473: INTO l_new_fiscal_year
5474: FROM gl_sets_of_books sob,
5475: gl_periods gl
5476: WHERE sob.set_of_books_id = p_sob_id
5477: AND gl.period_set_name= sob.period_set_name
5478: AND gl.period_type = sob.accounted_period_type
5479: AND (p_acct_date between gl.start_date and gl.end_date);

Line 5667: gl_periods gl

5663: -- );
5664: SELECT distinct gl.period_year
5665: INTO l_orig_fiscal_year
5666: FROM gl_sets_of_books sob,
5667: gl_periods gl
5668: WHERE sob.set_of_books_id = p_sob_id
5669: AND gl.period_set_name= sob.period_set_name
5670: AND gl.period_type = sob.accounted_period_type
5671: AND (p_prev_acct_date between gl.start_date and gl.end_date);

Line 5695: gl_periods gl

5691: -- );
5692: SELECT distinct gl.period_year
5693: INTO l_new_fiscal_year
5694: FROM gl_sets_of_books sob,
5695: gl_periods gl
5696: WHERE sob.set_of_books_id = p_sob_id
5697: AND gl.period_set_name= sob.period_set_name
5698: AND gl.period_type = sob.accounted_period_type
5699: AND (p_acct_date between gl.start_date and gl.end_date);

Line 6130: gl_periods gl

6126: -- );
6127: SELECT distinct gl.period_year
6128: INTO l_orig_fiscal_year
6129: FROM gl_sets_of_books sob,
6130: gl_periods gl
6131: WHERE sob.set_of_books_id = p_sob_id
6132: AND gl.period_set_name= sob.period_set_name
6133: AND gl.period_type = sob.accounted_period_type
6134: AND (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date between gl.start_date and gl.end_date);

Line 6159: gl_periods gl

6155: -- );
6156: SELECT distinct gl.period_year
6157: INTO l_new_fiscal_year
6158: FROM gl_sets_of_books sob,
6159: gl_periods gl
6160: WHERE sob.set_of_books_id = p_sob_id
6161: AND gl.period_set_name= sob.period_set_name
6162: AND gl.period_type = sob.accounted_period_type
6163: AND (l_cc_det_pf_lines_rec.cc_det_pf_date between gl.start_date and gl.end_date);

Line 6482: gl_periods gl

6478: -- );
6479: SELECT distinct gl.period_year
6480: INTO l_orig_fiscal_year
6481: FROM gl_sets_of_books sob,
6482: gl_periods gl
6483: WHERE sob.set_of_books_id = p_sob_id
6484: AND gl.period_set_name= sob.period_set_name
6485: AND gl.period_type = sob.accounted_period_type
6486: AND (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date between gl.start_date and gl.end_date);

Line 6511: gl_periods gl

6507: -- );
6508: SELECT distinct gl.period_year
6509: INTO l_new_fiscal_year
6510: FROM gl_sets_of_books sob,
6511: gl_periods gl
6512: WHERE sob.set_of_books_id = p_sob_id
6513: AND gl.period_set_name= sob.period_set_name
6514: AND gl.period_type = sob.accounted_period_type
6515: AND (l_cc_det_pf_lines_rec.cc_det_pf_date between gl.start_date and gl.end_date);