107: l_dummy varchar2(1);
108: --
109: cursor c1 is
110: select null
111: from pay_accrual_plans a
112: where a.accrual_plan_id = p_accrual_plan_id;
113: --
114: Begin
115: --
123: and nvl(p_accrual_plan_id,hr_api.g_number)
124: <> nvl(pay_ncr_shd.g_old_rec.accrual_plan_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if accrual_plan_id value exists in pay_accrual_plans table
128: --
129: open c1;
130: --
131: fetch c1 into l_dummy;
132: if c1%notfound then
133: --
134: close c1;
135: --
136: -- raise error as FK does not relate to PK in pay_accrual_plans
137: -- table.
138: --
139: pay_ncr_shd.constraint_error('PAY_NET_CALCULATION_RULES_FK1');
140: --
181: l_pto_input_value_id number;
182:
183: cursor c_get_absence_iv is
184: select pto_input_value_id
185: from pay_accrual_plans
186: where accrual_plan_id = p_accrual_plan_id;
187: --
188: begin
189: --