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_PRICE_INDEX_VALUES

Line 250: fa_price_index_values pii

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)
253: AND pol.asset_policy_id = mpol.asset_policy_id
254: AND pol.asset_id = bks.asset_id

Line 1129: FROM fa_price_index_values pii

1125: ) IS
1126:
1127: SELECT pii.price_index_id,
1128: pii.price_index_value
1129: FROM fa_price_index_values pii
1130: WHERE pii.price_index_id = nvl(p_pol_price_index_id,0)
1131: AND year_date_end BETWEEN pii.from_date AND pii.to_date;
1132:
1133: CURSOR Get_last_price_index (pol_price_index_id NUMBER) IS

Line 1136: FROM fa_price_index_values pii

1132:
1133: CURSOR Get_last_price_index (pol_price_index_id NUMBER) IS
1134: SELECT pii.price_index_id,
1135: pii.price_index_value
1136: FROM fa_price_index_values pii
1137: WHERE pii.price_index_id = nvl(p_pol_price_index_id,0)
1138: AND pii.to_date = (SELECT max(pii2.to_date)
1139: FROM fa_price_index_values pii2
1140: WHERE pii2.price_index_id = pii.price_index_id);

Line 1139: FROM fa_price_index_values pii2

1135: pii.price_index_value
1136: FROM fa_price_index_values pii
1137: WHERE pii.price_index_id = nvl(p_pol_price_index_id,0)
1138: AND pii.to_date = (SELECT max(pii2.to_date)
1139: FROM fa_price_index_values pii2
1140: WHERE pii2.price_index_id = pii.price_index_id);
1141:
1142: BEGIN
1143: