DBA Data[Home] [Help]

APPS.FA_FASRCOST_XMLP_PKG dependencies on FA_DEPRN_PERIODS

Line 71: FROM FA_DEPRN_PERIODS

67: INTO l_period_PC,
68: l_period_POD,
69: l_period_PCD,
70: l_period_FY
71: FROM FA_DEPRN_PERIODS
72: WHERE book_type_code = P_BOOK
73: AND period_name = P_PERIOD1;
74:
75: Period1_POD := l_period_POD;

Line 116: FROM FA_DEPRN_PERIODS

112: nvl(period_close_date, sysdate)
113: INTO l_period_PC,
114: l_period_POD,
115: l_period_PCD
116: FROM FA_DEPRN_PERIODS
117: --WHERE book_type_code = Distribution_Source_Book
118: WHERE book_type_code = chg_distribution_source_book
119: AND period_name = P_PERIOD1;
120:

Line 130: FROM FA_DEPRN_PERIODS

126: nvl(period_close_date, sysdate)
127: INTO l_period_PC,
128: l_period_POD,
129: l_period_PCD
130: FROM FA_DEPRN_PERIODS
131: --WHERE book_type_code = Distribution_Source_Book
132: WHERE book_type_code = chg_distribution_source_book
133: AND Period1_PCD BETWEEN PERIOD_OPEN_DATE AND
134: NVL(PERIOD_CLOSE_DATE, Period1_PCD);