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.IGI_ITR_FUNDS_CONTROL_PKG dependencies on GL_PERIOD_STATUSES

Line 36: gl_period_statuses P1

32: From
33: igi_itr_charge_headers H,
34: igi_itr_charge_lines L,
35: igi_itr_charge_lines_audit A,
36: gl_period_statuses P1
37: Where H.it_header_id = p_it_header_id
38: And L.it_header_id = H.it_header_id
39: And A.it_header_id = L.it_header_id
40: And L.it_service_line_id = nvl(p_it_service_line_id, L.it_service_line_id)

Line 275: l_period_num gl_period_statuses.period_num%type;

271: l_amount igi_itr_charge_lines_audit.entered_dr%type;
272: l_gl_encumbered_date igi_itr_charge_lines_audit.gl_encumbered_date%type;
273: l_period_name igi_itr_charge_headers.it_period_name%type;
274: l_currency_code igi_itr_charge_headers.currency_code%type;
275: l_period_num gl_period_statuses.period_num%type;
276: l_period_year gl_period_statuses.period_year%type;
277: l_quarter_num gl_period_statuses.quarter_num%type;
278: l_current_period_name igi_itr_charge_headers.it_period_name%type;
279: l_current_period_num gl_period_statuses.period_num%type;

Line 276: l_period_year gl_period_statuses.period_year%type;

272: l_gl_encumbered_date igi_itr_charge_lines_audit.gl_encumbered_date%type;
273: l_period_name igi_itr_charge_headers.it_period_name%type;
274: l_currency_code igi_itr_charge_headers.currency_code%type;
275: l_period_num gl_period_statuses.period_num%type;
276: l_period_year gl_period_statuses.period_year%type;
277: l_quarter_num gl_period_statuses.quarter_num%type;
278: l_current_period_name igi_itr_charge_headers.it_period_name%type;
279: l_current_period_num gl_period_statuses.period_num%type;
280: l_current_period_year gl_period_statuses.period_year%type;

Line 277: l_quarter_num gl_period_statuses.quarter_num%type;

273: l_period_name igi_itr_charge_headers.it_period_name%type;
274: l_currency_code igi_itr_charge_headers.currency_code%type;
275: l_period_num gl_period_statuses.period_num%type;
276: l_period_year gl_period_statuses.period_year%type;
277: l_quarter_num gl_period_statuses.quarter_num%type;
278: l_current_period_name igi_itr_charge_headers.it_period_name%type;
279: l_current_period_num gl_period_statuses.period_num%type;
280: l_current_period_year gl_period_statuses.period_year%type;
281: l_current_quarter_num gl_period_statuses.quarter_num%type;

Line 279: l_current_period_num gl_period_statuses.period_num%type;

275: l_period_num gl_period_statuses.period_num%type;
276: l_period_year gl_period_statuses.period_year%type;
277: l_quarter_num gl_period_statuses.quarter_num%type;
278: l_current_period_name igi_itr_charge_headers.it_period_name%type;
279: l_current_period_num gl_period_statuses.period_num%type;
280: l_current_period_year gl_period_statuses.period_year%type;
281: l_current_quarter_num gl_period_statuses.quarter_num%type;
282: l_reversal_flag igi_itr_charge_lines_audit.reversal_flag%type;
283: l_old_packet_id igi_itr_charge_lines_audit.packet_id%type;

Line 280: l_current_period_year gl_period_statuses.period_year%type;

276: l_period_year gl_period_statuses.period_year%type;
277: l_quarter_num gl_period_statuses.quarter_num%type;
278: l_current_period_name igi_itr_charge_headers.it_period_name%type;
279: l_current_period_num gl_period_statuses.period_num%type;
280: l_current_period_year gl_period_statuses.period_year%type;
281: l_current_quarter_num gl_period_statuses.quarter_num%type;
282: l_reversal_flag igi_itr_charge_lines_audit.reversal_flag%type;
283: l_old_packet_id igi_itr_charge_lines_audit.packet_id%type;
284: l_description igi_itr_charge_lines_audit.description%type;

Line 281: l_current_quarter_num gl_period_statuses.quarter_num%type;

277: l_quarter_num gl_period_statuses.quarter_num%type;
278: l_current_period_name igi_itr_charge_headers.it_period_name%type;
279: l_current_period_num gl_period_statuses.period_num%type;
280: l_current_period_year gl_period_statuses.period_year%type;
281: l_current_quarter_num gl_period_statuses.quarter_num%type;
282: l_reversal_flag igi_itr_charge_lines_audit.reversal_flag%type;
283: l_old_packet_id igi_itr_charge_lines_audit.packet_id%type;
284: l_description igi_itr_charge_lines_audit.description%type;
285: l_charge_service_id igi_itr_charge_lines_audit.charge_service_id%type;

Line 310: From gl_period_statuses

306: period_name,
307: period_num,
308: period_year,
309: quarter_num
310: From gl_period_statuses
311: Where trunc(sysdate) Between trunc(start_date) And trunc(end_date)
312: And set_of_books_id = p_set_of_books_id
313: And NVL(adjustment_period_flag,'N') = 'N'
314: And application_id = (Select application_id