DBA Data[Home] [Help]

APPS.FA_FASCOSTS_XMLP_PKG dependencies on FA_DEPRN_PERIODS

Line 94: FROM FA_DEPRN_PERIODS_MRC_V

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

Line 106: FROM FA_DEPRN_PERIODS

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

Line 139: FROM FA_DEPRN_PERIODS_MRC_V

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

Line 151: FROM FA_DEPRN_PERIODS

147: INTO l_period_PC,
148: l_period_POD,
149: l_period_PCD,
150: l_period_FY
151: FROM FA_DEPRN_PERIODS
152: WHERE book_type_code = P_BOOK
153: AND period_name = P_PERIOD2;
154: end if;
155:

Line 2327: FA_DEPRN_PERIODS_MRC_V DP,

2323: FA_CATEGORY_BOOKS CB,
2324: FA_DISTRIBUTION_HISTORY DH,
2325: FA_ASSET_HISTORY AH,
2326: FA_DEPRN_DETAIL_MRC_V DD,
2327: FA_DEPRN_PERIODS_MRC_V DP,
2328: FA_ADJUSTMENTS_MRC_V ADJ
2329: WHERE
2330: DH.Book_Type_Code = Distribution_Source_Book
2331: AND

Line 2406: FA_DEPRN_PERIODS DP,

2402: FA_CATEGORY_BOOKS CB,
2403: FA_DISTRIBUTION_HISTORY DH,
2404: FA_ASSET_HISTORY AH,
2405: FA_DEPRN_DETAIL DD,
2406: FA_DEPRN_PERIODS DP,
2407: FA_ADJUSTMENTS ADJ
2408: WHERE
2409: DH.Book_Type_Code = Distribution_Source_Book
2410: AND

Line 2601: FA_DEPRN_PERIODS_MRC_V P1,

2597: Period2_PC,
2598: Period2_PCD,
2599: Distribution_Source_Book
2600: FROM
2601: FA_DEPRN_PERIODS_MRC_V P1,
2602: FA_DEPRN_PERIODS_MRC_V P2,
2603: FA_BOOK_CONTROLS_MRC_V BC
2604: WHERE
2605: BC.Book_Type_Code = Book

Line 2602: FA_DEPRN_PERIODS_MRC_V P2,

2598: Period2_PCD,
2599: Distribution_Source_Book
2600: FROM
2601: FA_DEPRN_PERIODS_MRC_V P1,
2602: FA_DEPRN_PERIODS_MRC_V P2,
2603: FA_BOOK_CONTROLS_MRC_V BC
2604: WHERE
2605: BC.Book_Type_Code = Book
2606: AND

Line 2628: FA_DEPRN_PERIODS P1,

2624: Period2_PC,
2625: Period2_PCD,
2626: Distribution_Source_Book
2627: FROM
2628: FA_DEPRN_PERIODS P1,
2629: FA_DEPRN_PERIODS P2,
2630: FA_BOOK_CONTROLS BC
2631: WHERE
2632: BC.Book_Type_Code = Book

Line 2629: FA_DEPRN_PERIODS P2,

2625: Period2_PCD,
2626: Distribution_Source_Book
2627: FROM
2628: FA_DEPRN_PERIODS P1,
2629: FA_DEPRN_PERIODS P2,
2630: FA_BOOK_CONTROLS BC
2631: WHERE
2632: BC.Book_Type_Code = Book
2633: AND