APPS.PAY_BALANCE_FEED_DEL_PKG dependencies on PAY_SUB_CLASSIFICATION_RULES_F

Line 29: from pay_sub_classification_rules_f

25: where BALANCE_FEED_ID=c_bal_feed_id;
26:
27: Cursor csr_sub_class_rowid is
28: select rowid
29: from pay_sub_classification_rules_f
30: where SUB_CLASSIFICATION_RULE_ID = c_sub_class_id;
31:
32: Cursor csr_bal_feeds_sub_class_rule
33: (

Line 41: from pay_sub_classification_rules_f scr,

37: select bf.rowid row_id,
38: bf.balance_type_id,
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

Line 127: delete from pay_sub_classification_rules_f

123:
124: end loop;
125:
126: If sub_rowid is not null then
127: delete from pay_sub_classification_rules_f
128: where rowid = sub_rowid;
129: End If;
130: if sql%notfound then -- system error trap
131: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');