DBA Data[Home] [Help]

APPS.FA_MASS_REVAL_PKG dependencies on FA_ADDITIONS_B

Line 201: fa_additions_b ad

197: 'YES', rr.revalue_cip_assets_flag,
198: g_def_revalue_cip_assets_flag)
199: FROM fa_parallel_workers pw,
200: fa_mass_revaluation_rules rr,
201: fa_additions_b ad
202: WHERE pw.request_id = p_parent_request_id
203: AND pw.worker_number = p_request_number
204: AND pw.process_status = 'UNPROCESSED'
205: AND pw.asset_category_id is null

Line 258: fa_additions_b ad

254: 'YES', rr.revalue_cip_assets_flag,
255: g_def_revalue_cip_assets_flag)
256: FROM fa_parallel_workers pw,
257: fa_mass_revaluation_rules rr,
258: fa_additions_b ad
259: WHERE pw.request_id = p_parent_request_id
260: AND pw.worker_number = p_request_number
261: AND pw.process_status = 'UNPROCESSED'
262: AND pw.asset_category_id is not null

Line 1007: FROM fa_additions_b ad,

1003: p_book_type_code,
1004: mod(ad.asset_id, p_total_requests) + 1,
1005: 1,
1006: 'UNPROCESSED'
1007: FROM fa_additions_b ad,
1008: fa_books bk,
1009: fa_deprn_summary ds,
1010: fa_mass_revaluation_rules rr
1011: WHERE rr.mass_reval_id = p_mass_reval_id

Line 1069: FROM fa_additions_b ad,

1065: p_book_type_code,
1066: mod(ad.asset_id, p_total_requests) + 1,
1067: 1,
1068: 'UNPROCESSED'
1069: FROM fa_additions_b ad,
1070: fa_books bk,
1071: fa_deprn_summary ds,
1072: fa_mass_revaluation_rules rr
1073: WHERE rr.mass_reval_id = p_mass_reval_id