37: SELECT period_name,
38: period_open_date
39: INTO l_period_name,
40: l_period_POD
41: FROM FA_DEPRN_PERIODS
42: WHERE book_type_code = P_BOOK
43: AND period_name = P_PERIOD1;
44: Period1_POD := l_period_POD;
45: return(l_period_name);
80: SELECT period_name,
81: nvl(period_close_date, sysdate)
82: INTO l_period_name,
83: l_period_PCD
84: FROM FA_DEPRN_PERIODS
85: WHERE book_type_code = P_BOOK
86: AND period_name = P_PERIOD2;
87: Period2_PCD := l_period_PCD;
88: return(l_period_name);