DBA Data[Home] [Help]

APPS.PA_PACRCIPF_XMLP_PKG dependencies on FA_DEPRN_PERIODS

Line 146: FROM fa_deprn_periods

142: BEGIN
143: IF p_from_period IS NOT NULL THEN
144: SELECT MIN(period_open_date)
145: INTO cp_min_open_date
146: FROM fa_deprn_periods
147: WHERE period_name=p_from_period;
148: END IF;
149: EXCEPTION
150: WHEN NO_DATA_FOUND THEN

Line 159: FROM fa_deprn_periods

155: BEGIN
156: IF p_to_period IS NOT NULL THEN
157: SELECT MAX(period_close_date)
158: INTO cp_max_close_date
159: FROM fa_deprn_periods
160: WHERE period_name=p_to_period;
161: END IF;
162: EXCEPTION
163: WHEN NO_DATA_FOUND THEN