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

Line 5758: x_period_name gl_period_statuses.period_name%type;

5754: x_gl_appl_id number;
5755:
5756: x_po_encumbrance_flag varchar2(1);
5757: x_req_encumbrance_flag varchar2(1);
5758: x_period_name gl_period_statuses.period_name%type;
5759: x_sob_id number;
5760: x_receiving_flag varchar2(1);
5761: X_expense_accrual_code po_system_parameters.price_type_lookup_code%type;
5762: x_date date;

Line 6025: FROM GL_PERIOD_STATUSES PS1

6021:
6022: l_progress := '080';
6023: SELECT PS1.period_name
6024: INTO x_period_name
6025: FROM GL_PERIOD_STATUSES PS1
6026: , GL_PERIOD_STATUSES PS2
6027: , GL_SETS_OF_BOOKS GSOB
6028: WHERE PS1.application_id = x_gl_appl_id
6029: AND PS1.set_of_books_id = x_sob_id

Line 6026: , GL_PERIOD_STATUSES PS2

6022: l_progress := '080';
6023: SELECT PS1.period_name
6024: INTO x_period_name
6025: FROM GL_PERIOD_STATUSES PS1
6026: , GL_PERIOD_STATUSES PS2
6027: , GL_SETS_OF_BOOKS GSOB
6028: WHERE PS1.application_id = x_gl_appl_id
6029: AND PS1.set_of_books_id = x_sob_id
6030: AND PS1.adjustment_period_flag = 'N'