APPS.PAY_SLA_UPDATE_PKG dependencies on GL_PERIOD_STATUSES

Line 37: FROM gl_Period_Statuses gps

33: IS
34: CURSOR csr_Get_Periods IS
35: SELECT gps.Ledger_Id Ledger_Id,
36: gps.Period_Name Period_Name
37: FROM gl_Period_Statuses gps
38: WHERE gps.Ledger_Id = p_Ledger_Id
39: AND gps.cLosing_Status IN ('C','P')
40: AND gps.Adjustment_Period_Flag = 'N'
41: AND gps.Application_Id = '101'

Line 43: FROM gl_Period_Statuses

39: AND gps.cLosing_Status IN ('C','P')
40: AND gps.Adjustment_Period_Flag = 'N'
41: AND gps.Application_Id = '101'
42: AND gps.Start_Date >= (SELECT Start_Date
43: FROM gl_Period_Statuses
44: WHERE Ledger_Id = p_Ledger_Id
45: AND Application_Id = '101'
46: AND Period_Name = p_Start_Period)
47: AND (gps.End_Date <= (SELECT End_Date

Line 48: FROM gl_Period_Statuses

44: WHERE Ledger_Id = p_Ledger_Id
45: AND Application_Id = '101'
46: AND Period_Name = p_Start_Period)
47: AND (gps.End_Date <= (SELECT End_Date
48: FROM gl_Period_Statuses
49: WHERE Ledger_Id = p_Ledger_Id
50: AND Application_Id = '101'
51: AND Period_Name = p_End_Period)
52: OR p_End_Period is null)