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

Line 10219: --Derive Period_Name for the given GL_Date from GL_Period_Statuses

10215: AND dist.invoice_distribution_id = p_invoice_distribution_id
10216: AND inv.invoice_id = dist.invoice_id;
10217:
10218: --Bug 2905892
10219: --Derive Period_Name for the given GL_Date from GL_Period_Statuses
10220: --for Application_Id 101.
10221: --Funds checking is done using GL periods (application id = 101)
10222: FUNCTION Get_FC_Period_Name(P_GL_Date IN DATE) RETURN VARCHAR2 IS
10223: l_Period_Name pa_bc_packets.period_name%type;

Line 10234: From Gl_Period_Statuses

10230: Else
10231:
10232: Select Period_Name,PERIOD_YEAR
10233: Into l_Period_Name,l_period_year
10234: From Gl_Period_Statuses
10235: Where Application_Id = 101
10236: And Trunc(P_GL_Date) Between Trunc(Start_Date) And Trunc(End_Date)
10237: And Set_Of_Books_Id = G_SobId
10238: And adjustment_period_flag = 'N'; -- added for bug 3083625