DBA Data[Home] [Help]

APPS.FA_XADJ_ITF_PKG dependencies on FA_ADDITIONS_B

Line 88: fa_additions_b fab

84: , fat.extended_depreciation_period period
85: , fat.posting_status status
86: , fat.extended_deprn_limit -- bug 6658280
87: from fa_adjustments_t fat,
88: fa_additions_b fab
89: where fat.asset_number = fab.asset_number
90: and fat.posting_status = 'POST' /* bug 8597025 */
91: and fat.batch_id = p_batch_id
92: and fab.asset_id >= l_start_range

Line 227: , fa_additions_b fab

223: select min(asset_id), max(asset_id)
224: into l_start_range
225: , l_end_range
226: from fa_adjustments_t fat
227: , fa_additions_b fab
228: where batch_id = p_batch_id
229: and fat.asset_number = fab.asset_number;
230:
231: when others then

Line 633: from fa_adjustments_t fat, fa_additions_b fab

629: select min(aid), max(aid), 0,
630: 'UNASSIGNED', p_parent_request_id from ( select /*+ parallel(dh) */
631: fab.asset_id aid, floor(rank()
632: over (order by fab.asset_id)/l_batch_size ) unit_id
633: from fa_adjustments_t fat, fa_additions_b fab
634: where batch_id = p_batch_id
635: and fat.asset_number = fab.asset_number)
636: group by unit_id;
637: