APPS.PAY_TER_INS dependencies on PAY_TEMPLATE_EXCLUSION_RULES

Line 55: -- Insert the row into: pay_template_exclusion_rules

51: Begin
52: hr_utility.set_location('Entering:'||l_proc, 5);
53: p_rec.object_version_number := 1; -- Initialise the object version
54: --
55: -- Insert the row into: pay_template_exclusion_rules
56: --
57: insert into pay_template_exclusion_rules
58: ( exclusion_rule_id,
59: template_id,

Line 57: insert into pay_template_exclusion_rules

53: p_rec.object_version_number := 1; -- Initialise the object version
54: --
55: -- Insert the row into: pay_template_exclusion_rules
56: --
57: insert into pay_template_exclusion_rules
58: ( exclusion_rule_id,
59: template_id,
60: flexfield_column,
61: exclusion_value,

Line 133: Cursor C_Sel1 is select pay_template_exclusion_rules_s.nextval from sys.dual;

129: Procedure pre_insert(p_rec in out nocopy pay_ter_shd.g_rec_type) is
130: --
131: l_proc varchar2(72) := g_package||'pre_insert';
132: --
133: Cursor C_Sel1 is select pay_template_exclusion_rules_s.nextval from sys.dual;
134: --
135: Begin
136: hr_utility.set_location('Entering:'||l_proc, 5);
137: --