[Home] [Help]
20: select rowid,
21: balance_type_id,
22: input_value_id,
23: effective_start_date
24: from PAY_BALANCE_FEEDS_F
25: where BALANCE_FEED_ID=c_bal_feed_id;
26:
27: Cursor csr_sub_class_rowid is
28: select rowid
39: bf.input_value_id,
40: bf.effective_start_date
41: from pay_sub_classification_rules_f scr,
42: pay_input_values_f iv,
43: pay_balance_feeds_f bf,
44: pay_balance_classifications bc,
45: pay_balance_types bt
46: where scr.sub_classification_rule_id = p_sub_classification_rule_id
47: and iv.element_type_id = scr.element_type_id
80: /*
81: hrassact.trash_latest_balances gets called from trigger
82: pay_balance_feeds_ard , due to performance issues in delting from
83: pay_assignment_latest_balances we are performing this operation here
84: before delete from pay_balance_feeds_f.
85:
86: */
87:
88: If bal_type_id is not null then
95: inp_value_id,
96: eff_start_date,
97: c_batch_size);
98:
99: Delete from pay_balance_feeds_f
100: where rowid = bal_rowid;
101:
102: -- pay_balance_feeds_f_pkg.delete_row (bal_rowid,bal_type_id);
103:
98:
99: Delete from pay_balance_feeds_f
100: where rowid = bal_rowid;
101:
102: -- pay_balance_feeds_f_pkg.delete_row (bal_rowid,bal_type_id);
103:
104: elsif c_pur_mode='Sub Classification' and c_sub_class_id is not null then
105:
106: Open csr_sub_class_rowid;
117: v_bf_rec.effective_start_date,
118: c_batch_size);
119:
120:
121: delete from pay_balance_feeds_f bf
122: where bf.rowid = v_bf_rec.row_id;
123:
124: end loop;
125: