APPS.PQH_BEL_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 165: from pay_element_types_f a

161: l_dummy varchar2(1);
162: --
163: cursor c1 is
164: select null
165: from pay_element_types_f a
166: where a.element_type_id = p_element_type_id
167: and sysdate between effective_start_date and effective_end_date;
168: --
169: Begin

Line 183: -- check if element_type_id value exists in pay_element_types_f table

179: <> nvl(pqh_bel_shd.g_old_rec.element_type_id,hr_api.g_number)
180: or not l_api_updating) then
181:
182: --
183: -- check if element_type_id value exists in pay_element_types_f table
184: --
185: open c1;
186: --
187: fetch c1 into l_dummy;

Line 192: -- raise error as FK does not relate to PK in pay_element_types_f

188: if c1%notfound then
189: --
190: close c1;
191: --
192: -- raise error as FK does not relate to PK in pay_element_types_f
193: -- table.
194: hr_utility.set_message(8302,'PQH_INVALID_ELEMENT');
195: hr_utility.raise_error;
196: