59: INTO l_period_PC,
60: l_period_POD,
61: l_period_PCD,
62: l_period_FY
63: FROM FA_DEPRN_PERIODS
64: WHERE book_type_code = P_FED_BOOK
65: AND period_name = P_PERIOD1;
66: Period1_POD := l_period_POD;
67: Period1_PCD := l_period_PCD;
87: l_fed_end_period_pc,
88: l_amt_start_period_pc,
89: l_amt_end_period_pc
90: from
91: fa_deprn_periods dp_amt,
92: fa_deprn_periods dp_fed
93: where
94: dp_fed.book_type_code = P_FED_BOOK and
95: dp_fed.fiscal_year = Period1_FY and
88: l_amt_start_period_pc,
89: l_amt_end_period_pc
90: from
91: fa_deprn_periods dp_amt,
92: fa_deprn_periods dp_fed
93: where
94: dp_fed.book_type_code = P_FED_BOOK and
95: dp_fed.fiscal_year = Period1_FY and
96: dp_amt.book_type_code = P_AMT_BOOK and