561: l_StartDay Number := 1; -- week starts on Sunday
562:
563: Cursor c_PeriodDate(p_periodSetName Varchar2,p_periodType varchar2,p_date date) Is
564: Select Start_Date,End_Date 565: From GL_Periods 566: Where period_set_name = p_periodsetname
567: and period_type = p_periodType
568: and adjustment_period_flag = 'N'
569: and p_Date between Start_date and End_date;