[Home] [Help]
191: end if;
192:
193: select count(*)
194: into h_count
195: from FA_DEPRN_RULE_DETAILS
196: where deprn_basis_rule_id = x_deprn_basis_rule_id;
197:
198: if h_count >0 then
199: DELETE from fa_deprn_rule_details
195: from FA_DEPRN_RULE_DETAILS
196: where deprn_basis_rule_id = x_deprn_basis_rule_id;
197:
198: if h_count >0 then
199: DELETE from fa_deprn_rule_details
200: WHERE deprn_basis_rule_id = x_deprn_basis_rule_id;
201: end if;
202:
203: exception