DBA Data[Home] [Help]

APPS.FA_C_INSURE dependencies on FA_INS_POLICIES

Line 238: fa_ins_policies pol,

234: nvl(pol.last_price_index_value,pii.price_index_value),
235: bks.period_counter_fully_reserved
236: FROM fa_additions fad,
237: fa_books bks,
238: fa_ins_policies pol,
239: fa_ins_mst_pols mpol,
240: fa_price_index_values pii
241: WHERE fad.asset_number BETWEEN NVL(p_asset_start, fad.asset_number)
242: AND NVL(p_asset_end,fad.asset_number)

Line 1623: UPDATE fa_ins_policies pol

1619: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
1620:
1621: BEGIN
1622:
1623: UPDATE fa_ins_policies pol
1624: SET pol.current_insurance_value = round(p_cal_insurance_value,2),
1625: pol.last_indexation_id = p_indexation_id,
1626: pol.last_price_index_value = nvl(p_new_price_index_value,1),
1627: pol.value_before_retirement = nvl(p_pol_retirement_value,-1),