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_INS_POLICIES_PKG dependencies on FA_INS_MST_POLS

Line 18: FROM fa_ins_mst_pols_v pol

14: SELECT pol.calculation_method,
15: pol.Vendor_Site_code,
16: pol.vendor_site_id,
17: nvl(pol.asset_policy_id,0)
18: FROM fa_ins_mst_pols_v pol
19: WHERE pol.vendor_id = X_Vendor_id
20: AND pol.policy_number = X_Policy_number
21: ;
22:

Line 90: FROM fa_ins_mst_pols

86: AND asset_id = X_Asset_id;
87:
88: CURSOR C1 (X_Policy_Number Varchar2, X_vendor_id NUMBER) IS
89: SELECT asset_policy_id
90: FROM fa_ins_mst_pols
91: WHERE policy_number = X_Policy_number
92: AND Vendor_id = X_Vendor_id;
93:
94: l_asset_policy_id NUMBER;

Line 112: INSERT INTO fa_ins_mst_pols

108: FROM dual;
109:
110: l_asset_policy_id := X_Asset_policy_id;
111:
112: INSERT INTO fa_ins_mst_pols
113: (asset_policy_id,
114: policy_number,
115: calculation_method,
116: vendor_id,