APPS.FA_INS_MST_POLS_PKG dependencies on FA_INS_POLICIES

Line 96: FROM fa_ins_policies

92: X_Asset_id VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
93:
94: CURSOR C IS
95: SELECT 1
96: FROM fa_ins_policies
97: WHERE asset_policy_id = X_asset_policy_id
98: AND asset_id <> X_Asset_id;
99:
100: dummy varchar2(1);

Line 122: DELETE FROM fa_ins_policies

118:
119: -- commit;
120:
121:
122: DELETE FROM fa_ins_policies
123: WHERE asset_policy_id = X_asset_policy_id
124: AND asset_id = X_Asset_id;
125:
126: DELETE FROM fa_ins_values