APPS.PA_TRX_IMPORT dependencies on GL_PERIOD_STATUSES

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

11046: AND inv.invoice_id = dist.invoice_id
11047: ;
11048:
11049: --Bug 2905892
11050: --Derive Period_Name for the given GL_Date from GL_Period_Statuses
11051: --for Application_Id 101.
11052: --Funds checking is done using GL periods (application id = 101)
11053: FUNCTION Get_FC_Period_Name(P_GL_Date IN DATE) RETURN VARCHAR2 IS
11054: l_Period_Name pa_bc_packets.period_name%type;

Line 11070: From Gl_Period_Statuses

11066: Else
11067:
11068: Select Period_Name,PERIOD_YEAR
11069: Into l_Period_Name,l_period_year
11070: From Gl_Period_Statuses
11071: Where Application_Id = 101
11072: And Trunc(P_GL_Date) Between Trunc(Start_Date) And Trunc(End_Date)
11073: And Set_Of_Books_Id = G_SobId
11074: And adjustment_period_flag = 'N'; -- added for bug 3083625