DBA Data[Home] [Help]

APPS.FA_MASS_REVAL_PKG dependencies on FA_ADDITIONS_B

Line 188: fa_additions_b ad

184: 'YES', rr.revalue_cip_assets_flag,
185: g_def_revalue_cip_assets_flag)
186: FROM fa_parallel_workers pw,
187: fa_mass_revaluation_rules rr,
188: fa_additions_b ad
189: WHERE pw.request_id = p_parent_request_id
190: AND pw.worker_number = p_request_number
191: AND pw.process_status = 'UNPROCESSED'
192: AND pw.asset_category_id is null

Line 240: fa_additions_b ad

236: 'YES', rr.revalue_cip_assets_flag,
237: g_def_revalue_cip_assets_flag)
238: FROM fa_parallel_workers pw,
239: fa_mass_revaluation_rules rr,
240: fa_additions_b ad
241: WHERE pw.request_id = p_parent_request_id
242: AND pw.worker_number = p_request_number
243: AND pw.process_status = 'UNPROCESSED'
244: AND pw.asset_category_id is not null

Line 924: FROM fa_additions_b ad,

920: p_book_type_code,
921: mod(ad.asset_id, p_total_requests) + 1,
922: 1,
923: 'UNPROCESSED'
924: FROM fa_additions_b ad,
925: fa_books bk,
926: fa_mass_revaluation_rules rr
927: WHERE rr.mass_reval_id = p_mass_reval_id
928: AND rr.category_id IS NULL

Line 983: FROM fa_additions_b ad,

979: p_book_type_code,
980: mod(ad.asset_id, p_total_requests) + 1,
981: 1,
982: 'UNPROCESSED'
983: FROM fa_additions_b ad,
984: fa_books bk,
985: fa_mass_revaluation_rules rr
986: WHERE rr.mass_reval_id = p_mass_reval_id
987: AND rr.category_id = ad.asset_category_id