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_CBC_PO_GRP dependencies on GL_PERIODS

Line 101: FROM gl_periods gp,

97: -- Define cursor to extract the fiscal year for p_date
98:
99: CURSOR c_fiscal_year(p_sob_id NUMBER) IS
100: SELECT period_year
101: FROM gl_periods gp,
102: gl_sets_of_books gsob
103: WHERE gp.period_set_name = gsob.period_set_name
104: AND gp.period_type = gsob.accounted_period_type
105: AND trunc(p_date) BETWEEN trunc(gp.start_date)

Line 316: l_max_fiscal_year gl_periods.period_year%TYPE;

312: l_sob_id financials_system_parameters.set_of_books_id%TYPE;
313: l_document_id NUMBER := to_number(p_document_id);
314: l_max_gl_date po_distributions.gl_encumbered_date%TYPE;
315: l_min_gl_date po_distributions.gl_encumbered_date%TYPE;
316: l_max_fiscal_year gl_periods.period_year%TYPE;
317: l_min_fiscal_year gl_periods.period_year%TYPE;
318: l_req_encumbrance_flag financials_system_parameters.req_encumbrance_flag%TYPE;
319: l_purch_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE;
320: e_document_not_found EXCEPTION;

Line 317: l_min_fiscal_year gl_periods.period_year%TYPE;

313: l_document_id NUMBER := to_number(p_document_id);
314: l_max_gl_date po_distributions.gl_encumbered_date%TYPE;
315: l_min_gl_date po_distributions.gl_encumbered_date%TYPE;
316: l_max_fiscal_year gl_periods.period_year%TYPE;
317: l_min_fiscal_year gl_periods.period_year%TYPE;
318: l_req_encumbrance_flag financials_system_parameters.req_encumbrance_flag%TYPE;
319: l_purch_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE;
320: e_document_not_found EXCEPTION;
321: