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 240: fa_price_index_values pii

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

Line 1135: FROM fa_price_index_values pii

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

Line 1142: FROM fa_price_index_values pii

1138:
1139: CURSOR Get_last_price_index (pol_price_index_id NUMBER) IS
1140: SELECT pii.price_index_id,
1141: pii.price_index_value
1142: FROM fa_price_index_values pii
1143: WHERE pii.price_index_id = nvl(p_pol_price_index_id,0)
1144: AND pii.to_date = (SELECT max(pii2.to_date)
1145: FROM fa_price_index_values pii2
1146: WHERE pii2.price_index_id = pii.price_index_id);

Line 1145: FROM fa_price_index_values pii2

1141: pii.price_index_value
1142: FROM fa_price_index_values pii
1143: WHERE pii.price_index_id = nvl(p_pol_price_index_id,0)
1144: AND pii.to_date = (SELECT max(pii2.to_date)
1145: FROM fa_price_index_values pii2
1146: WHERE pii2.price_index_id = pii.price_index_id);
1147:
1148: BEGIN
1149: