eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_C_INSURE dependencies on FA_INS_POLICIES

Line 248: fa_ins_policies pol,

244: nvl(pol.last_price_index_value,pii.price_index_value),
245: bks.period_counter_fully_reserved
246: FROM fa_additions fad,
247: fa_books bks,
248: fa_ins_policies pol,
249: fa_ins_mst_pols mpol,
250: fa_price_index_values pii
251: WHERE fad.asset_number BETWEEN NVL(p_asset_start, fad.asset_number)
252: AND NVL(p_asset_end,fad.asset_number)

Line 1611: UPDATE fa_ins_policies pol

1607: ) IS
1608:
1609: BEGIN
1610:
1611: UPDATE fa_ins_policies pol
1612: SET pol.current_insurance_value = round(p_cal_insurance_value,2),
1613: pol.last_indexation_id = p_indexation_id,
1614: pol.last_price_index_value = nvl(p_new_price_index_value,1),
1615: pol.value_before_retirement = nvl(p_pol_retirement_value,-1),