DBA Data[Home] [Help]

APPS.FA_MASS_REVAL_PKG dependencies on FA_MASS_REVALUATION_RULES

Line 200: fa_mass_revaluation_rules rr,

196: DECODE(rr.override_defaults_flag,
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'

Line 257: fa_mass_revaluation_rules rr,

253: DECODE(rr.override_defaults_flag,
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'

Line 1010: fa_mass_revaluation_rules rr

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
1012: AND rr.category_id IS NULL
1013: AND rr.asset_id is not null
1014: AND ad.asset_id = rr.asset_id

Line 1072: fa_mass_revaluation_rules rr

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
1074: AND rr.category_id = ad.asset_category_id
1075: AND rr.category_id IS not NULL
1076: AND rr.asset_id is null