APPS.FA_FASTXPRF_XMLP_PKG dependencies on FA_DEPRN_PERIODS

Line 80: FROM FA_DEPRN_PERIODS DP_CORP,

76: l_period_POD,
77: l_period_PCD,
78: l_period_FY,
79: l_corp_end_pc
80: FROM FA_DEPRN_PERIODS DP_CORP,
81: FA_DEPRN_PERIODS DP_FED
82: WHERE DP_FED.book_type_code = P_BOOK
83: AND DP_FED.period_name = P_PERIOD1
84: AND DP_CORP.BOOK_TYPE_CODE = DISTRIBUTION_SOURCE_BOOK

Line 81: FA_DEPRN_PERIODS DP_FED

77: l_period_PCD,
78: l_period_FY,
79: l_corp_end_pc
80: FROM FA_DEPRN_PERIODS DP_CORP,
81: FA_DEPRN_PERIODS DP_FED
82: WHERE DP_FED.book_type_code = P_BOOK
83: AND DP_FED.period_name = P_PERIOD1
84: AND DP_CORP.BOOK_TYPE_CODE = DISTRIBUTION_SOURCE_BOOK
85: AND DP_CORP.PERIOD_COUNTER = (SELECT MAX(DP.PERIOD_COUNTER)

Line 86: FROM FA_DEPRN_PERIODS DP

82: WHERE DP_FED.book_type_code = P_BOOK
83: AND DP_FED.period_name = P_PERIOD1
84: AND DP_CORP.BOOK_TYPE_CODE = DISTRIBUTION_SOURCE_BOOK
85: AND DP_CORP.PERIOD_COUNTER = (SELECT MAX(DP.PERIOD_COUNTER)
86: FROM FA_DEPRN_PERIODS DP
87: WHERE DP.BOOK_TYPE_CODE =
88: DISTRIBUTION_SOURCE_BOOK AND
89: DP.CALENDAR_PERIOD_CLOSE_DATE <=
90: DP_FED.CALENDAR_PERIOD_CLOSE_DATE);

Line 120: FROM fa_deprn_periods fp1, fa_deprn_periods fp2

116: max(fp1.period_counter),
117: min(fp2.period_counter)
118: INTO l_fed_min_pc, l_fed_max_pc,
119: l_corp_min_pc
120: FROM fa_deprn_periods fp1, fa_deprn_periods fp2
121: WHERE fp1.book_type_code = P_BOOK
122: and fp1.period_close_date is not NULL
123: and fp1.period_counter <= period1_pc
124: and fp1.fiscal_year = period1_FY

Line 151: FA_DEPRN_PERIODS DP,

147: DD_FED.ASSET_ID ASSET_ID,
148: SUM(DD_FED.deprn_amount) FED_YTD_DEPRN,
149: 0
150: FROM
151: FA_DEPRN_PERIODS DP,
152: FA_DEPRN_DETAIL DD_FED,
153: FA_ASSET_HISTORY AH,
154: FA_BOOKS BK_FED,
155: FA_CATEGORY_BOOKS CB_CORP,