APPS.FA_FASRSVES_XMLP_PKG dependencies on FA_DEPRN_PERIODS

Line 93: FROM FA_DEPRN_PERIODS_MRC_V

89: INTO l_period_PC,
90: l_period_POD,
91: l_period_PCD,
92: l_period_FY
93: FROM FA_DEPRN_PERIODS_MRC_V
94: WHERE book_type_code = P_BOOK
95: AND period_name = P_PERIOD1;
96: ELSE
97: SELECT period_counter,

Line 105: FROM FA_DEPRN_PERIODS

101: INTO l_period_PC,
102: l_period_POD,
103: l_period_PCD,
104: l_period_FY
105: FROM FA_DEPRN_PERIODS
106: WHERE book_type_code = P_BOOK
107: AND period_name = P_PERIOD1;
108: END IF;
109:

Line 141: FROM FA_DEPRN_PERIODS_MRC_V

137: INTO l_period_PC,
138: l_period_POD,
139: l_period_PCD,
140: l_period_FY
141: FROM FA_DEPRN_PERIODS_MRC_V
142: WHERE book_type_code = P_BOOK
143: AND period_name = P_PERIOD2;
144: ELSE
145: SELECT period_counter,

Line 153: FROM FA_DEPRN_PERIODS

149: INTO l_period_PC,
150: l_period_POD,
151: l_period_PCD,
152: l_period_FY
153: FROM FA_DEPRN_PERIODS
154: WHERE book_type_code = P_BOOK
155: AND period_name = P_PERIOD2;
156: END IF;
157:

Line 2351: FA_DEPRN_PERIODS_MRC_V DP,

2347: FA_CATEGORY_BOOKS CB,
2348: FA_DISTRIBUTION_HISTORY DH,
2349: FA_ASSET_HISTORY AH,
2350: FA_DEPRN_DETAIL_MRC_V DD,
2351: FA_DEPRN_PERIODS_MRC_V DP,
2352: FA_ADJUSTMENTS_MRC_V ADJ
2353: WHERE
2354: DH.Book_Type_Code = Distribution_Source_Book
2355: AND

Line 2430: FA_DEPRN_PERIODS DP,

2426: FA_CATEGORY_BOOKS CB,
2427: FA_DISTRIBUTION_HISTORY DH,
2428: FA_ASSET_HISTORY AH,
2429: FA_DEPRN_DETAIL DD,
2430: FA_DEPRN_PERIODS DP,
2431: FA_ADJUSTMENTS ADJ
2432: WHERE
2433: DH.Book_Type_Code = Distribution_Source_Book
2434: AND

Line 2625: FA_DEPRN_PERIODS_MRC_V P1,

2621: Period2_PC,
2622: Period2_PCD,
2623: Distribution_Source_Book
2624: FROM
2625: FA_DEPRN_PERIODS_MRC_V P1,
2626: FA_DEPRN_PERIODS_MRC_V P2,
2627: FA_BOOK_CONTROLS_MRC_V BC
2628: WHERE
2629: BC.Book_Type_Code = Book

Line 2626: FA_DEPRN_PERIODS_MRC_V P2,

2622: Period2_PCD,
2623: Distribution_Source_Book
2624: FROM
2625: FA_DEPRN_PERIODS_MRC_V P1,
2626: FA_DEPRN_PERIODS_MRC_V P2,
2627: FA_BOOK_CONTROLS_MRC_V BC
2628: WHERE
2629: BC.Book_Type_Code = Book
2630: AND

Line 2652: FA_DEPRN_PERIODS P1,

2648: Period2_PC,
2649: Period2_PCD,
2650: Distribution_Source_Book
2651: FROM
2652: FA_DEPRN_PERIODS P1,
2653: FA_DEPRN_PERIODS P2,
2654: FA_BOOK_CONTROLS BC
2655: WHERE
2656: BC.Book_Type_Code = Book

Line 2653: FA_DEPRN_PERIODS P2,

2649: Period2_PCD,
2650: Distribution_Source_Book
2651: FROM
2652: FA_DEPRN_PERIODS P1,
2653: FA_DEPRN_PERIODS P2,
2654: FA_BOOK_CONTROLS BC
2655: WHERE
2656: BC.Book_Type_Code = Book
2657: AND