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 4699: l_orig_fiscal_year gl_periods.period_year%TYPE;

4695: -- l_cc_prov_encmbrnc_flag igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_enable_flag%TYPE := 'N';
4696: -- l_cc_conf_encmbrnc_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE := 'N';
4697: l_cc_prov_encmbrnc_flag VARCHAR2(1);
4698: l_cc_conf_encmbrnc_flag VARCHAR2(1);
4699: l_orig_fiscal_year gl_periods.period_year%TYPE;
4700: l_new_fiscal_year gl_periods.period_year%TYPE;
4701:
4702: l_COUNT NUMBER;
4703: l_min_rel_start_date DATE;

Line 4700: l_new_fiscal_year gl_periods.period_year%TYPE;

4696: -- l_cc_conf_encmbrnc_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE := 'N';
4697: l_cc_prov_encmbrnc_flag VARCHAR2(1);
4698: l_cc_conf_encmbrnc_flag VARCHAR2(1);
4699: l_orig_fiscal_year gl_periods.period_year%TYPE;
4700: l_new_fiscal_year gl_periods.period_year%TYPE;
4701:
4702: l_COUNT NUMBER;
4703: l_min_rel_start_date DATE;
4704: l_cover_start_date DATE;

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

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

Line 5389: gl_periods gl

5385: -- );
5386: SELECT distinct gl.period_year
5387: INTO l_orig_fiscal_year
5388: FROM gl_sets_of_books sob,
5389: gl_periods gl
5390: WHERE sob.set_of_books_id = p_sob_id
5391: AND gl.period_set_name= sob.period_set_name
5392: AND gl.period_type = sob.accounted_period_type
5393: AND (p_prev_acct_date between gl.start_date and gl.end_date);

Line 5417: gl_periods gl

5413: -- );
5414: SELECT distinct gl.period_year
5415: INTO l_new_fiscal_year
5416: FROM gl_sets_of_books sob,
5417: gl_periods gl
5418: WHERE sob.set_of_books_id = p_sob_id
5419: AND gl.period_set_name= sob.period_set_name
5420: AND gl.period_type = sob.accounted_period_type
5421: AND (p_acct_date between gl.start_date and gl.end_date);

Line 5609: gl_periods gl

5605: -- );
5606: SELECT distinct gl.period_year
5607: INTO l_orig_fiscal_year
5608: FROM gl_sets_of_books sob,
5609: gl_periods gl
5610: WHERE sob.set_of_books_id = p_sob_id
5611: AND gl.period_set_name= sob.period_set_name
5612: AND gl.period_type = sob.accounted_period_type
5613: AND (p_prev_acct_date between gl.start_date and gl.end_date);

Line 5637: gl_periods gl

5633: -- );
5634: SELECT distinct gl.period_year
5635: INTO l_new_fiscal_year
5636: FROM gl_sets_of_books sob,
5637: gl_periods gl
5638: WHERE sob.set_of_books_id = p_sob_id
5639: AND gl.period_set_name= sob.period_set_name
5640: AND gl.period_type = sob.accounted_period_type
5641: AND (p_acct_date between gl.start_date and gl.end_date);

Line 6070: gl_periods gl

6066: -- );
6067: SELECT distinct gl.period_year
6068: INTO l_orig_fiscal_year
6069: FROM gl_sets_of_books sob,
6070: gl_periods gl
6071: WHERE sob.set_of_books_id = p_sob_id
6072: AND gl.period_set_name= sob.period_set_name
6073: AND gl.period_type = sob.accounted_period_type
6074: AND (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date between gl.start_date and gl.end_date);

Line 6099: gl_periods gl

6095: -- );
6096: SELECT distinct gl.period_year
6097: INTO l_new_fiscal_year
6098: FROM gl_sets_of_books sob,
6099: gl_periods gl
6100: WHERE sob.set_of_books_id = p_sob_id
6101: AND gl.period_set_name= sob.period_set_name
6102: AND gl.period_type = sob.accounted_period_type
6103: AND (l_cc_det_pf_lines_rec.cc_det_pf_date between gl.start_date and gl.end_date);

Line 6420: gl_periods gl

6416: -- );
6417: SELECT distinct gl.period_year
6418: INTO l_orig_fiscal_year
6419: FROM gl_sets_of_books sob,
6420: gl_periods gl
6421: WHERE sob.set_of_books_id = p_sob_id
6422: AND gl.period_set_name= sob.period_set_name
6423: AND gl.period_type = sob.accounted_period_type
6424: AND (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date between gl.start_date and gl.end_date);

Line 6449: gl_periods gl

6445: -- );
6446: SELECT distinct gl.period_year
6447: INTO l_new_fiscal_year
6448: FROM gl_sets_of_books sob,
6449: gl_periods gl
6450: WHERE sob.set_of_books_id = p_sob_id
6451: AND gl.period_set_name= sob.period_set_name
6452: AND gl.period_type = sob.accounted_period_type
6453: AND (l_cc_det_pf_lines_rec.cc_det_pf_date between gl.start_date and gl.end_date);