APPS.FA_FASCOSTD_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 138: FROM FA_DEPRN_PERIODS_MRC_V

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

Line 150: FROM FA_DEPRN_PERIODS

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

Line 2296: FA_DEPRN_PERIODS_MRC_V DP,

2292: FA_CATEGORY_BOOKS CB,
2293: FA_DISTRIBUTION_HISTORY DH,
2294: FA_ASSET_HISTORY AH,
2295: FA_DEPRN_DETAIL_MRC_V DD,
2296: FA_DEPRN_PERIODS_MRC_V DP,
2297: FA_ADJUSTMENTS_MRC_V ADJ
2298: WHERE
2299: DH.Book_Type_Code = Distribution_Source_Book
2300: AND

Line 2375: FA_DEPRN_PERIODS DP,

2371: FA_CATEGORY_BOOKS CB,
2372: FA_DISTRIBUTION_HISTORY DH,
2373: FA_ASSET_HISTORY AH,
2374: FA_DEPRN_DETAIL DD,
2375: FA_DEPRN_PERIODS DP,
2376: FA_ADJUSTMENTS ADJ
2377: WHERE
2378: DH.Book_Type_Code = Distribution_Source_Book
2379: AND

Line 2567: FA_DEPRN_PERIODS_MRC_V P1,

2563: Period2_PC,
2564: Period2_PCD,
2565: Distribution_Source_Book
2566: FROM
2567: FA_DEPRN_PERIODS_MRC_V P1,
2568: FA_DEPRN_PERIODS_MRC_V P2,
2569: FA_BOOK_CONTROLS_MRC_V BC
2570: WHERE
2571: BC.Book_Type_Code = Book

Line 2568: FA_DEPRN_PERIODS_MRC_V P2,

2564: Period2_PCD,
2565: Distribution_Source_Book
2566: FROM
2567: FA_DEPRN_PERIODS_MRC_V P1,
2568: FA_DEPRN_PERIODS_MRC_V P2,
2569: FA_BOOK_CONTROLS_MRC_V BC
2570: WHERE
2571: BC.Book_Type_Code = Book
2572: AND

Line 2594: FA_DEPRN_PERIODS P1,

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

Line 2595: FA_DEPRN_PERIODS P2,

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