APPS.FA_FASRSVED_XMLP_PKG dependencies on FA_DEPRN_PERIODS

Line 95: FROM FA_DEPRN_PERIODS_MRC_V

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

Line 107: FROM FA_DEPRN_PERIODS

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

Line 143: FROM FA_DEPRN_PERIODS_MRC_V

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

Line 155: FROM FA_DEPRN_PERIODS

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

Line 2323: FA_DEPRN_PERIODS_MRC_V DP,

2319: FA_CATEGORY_BOOKS CB,
2320: FA_DISTRIBUTION_HISTORY DH,
2321: FA_ASSET_HISTORY AH,
2322: FA_DEPRN_DETAIL_MRC_V DD,
2323: FA_DEPRN_PERIODS_MRC_V DP,
2324: FA_ADJUSTMENTS_MRC_V ADJ
2325: WHERE
2326: DH.Book_Type_Code = Distribution_Source_Book
2327: AND

Line 2402: FA_DEPRN_PERIODS DP,

2398: FA_CATEGORY_BOOKS CB,
2399: FA_DISTRIBUTION_HISTORY DH,
2400: FA_ASSET_HISTORY AH,
2401: FA_DEPRN_DETAIL DD,
2402: FA_DEPRN_PERIODS DP,
2403: FA_ADJUSTMENTS ADJ
2404: WHERE
2405: DH.Book_Type_Code = Distribution_Source_Book
2406: AND

Line 2594: FA_DEPRN_PERIODS_MRC_V P1,

2590: Period2_PC,
2591: Period2_PCD,
2592: Distribution_Source_Book
2593: FROM
2594: FA_DEPRN_PERIODS_MRC_V P1,
2595: FA_DEPRN_PERIODS_MRC_V P2,
2596: FA_BOOK_CONTROLS_MRC_V BC
2597: WHERE
2598: BC.Book_Type_Code = Book

Line 2595: FA_DEPRN_PERIODS_MRC_V P2,

2591: Period2_PCD,
2592: Distribution_Source_Book
2593: FROM
2594: FA_DEPRN_PERIODS_MRC_V P1,
2595: FA_DEPRN_PERIODS_MRC_V P2,
2596: FA_BOOK_CONTROLS_MRC_V BC
2597: WHERE
2598: BC.Book_Type_Code = Book
2599: AND

Line 2621: FA_DEPRN_PERIODS P1,

2617: Period2_PC,
2618: Period2_PCD,
2619: Distribution_Source_Book
2620: FROM
2621: FA_DEPRN_PERIODS P1,
2622: FA_DEPRN_PERIODS P2,
2623: FA_BOOK_CONTROLS BC
2624: WHERE
2625: BC.Book_Type_Code = Book

Line 2622: FA_DEPRN_PERIODS P2,

2618: Period2_PCD,
2619: Distribution_Source_Book
2620: FROM
2621: FA_DEPRN_PERIODS P1,
2622: FA_DEPRN_PERIODS P2,
2623: FA_BOOK_CONTROLS BC
2624: WHERE
2625: BC.Book_Type_Code = Book
2626: AND