DBA Data[Home] [Help]

APPS.PQH_PTE_BUS dependencies on PER_POSITION_INFO_TYPES

Line 186: from per_position_info_types a

182: l_dummy varchar2(1);
183: --
184: cursor c1 is
185: select null
186: from per_position_info_types a
187: where a.information_type = p_information_type;
188: --
189: Begin
190: --

Line 202: -- check if information_type value exists in per_position_info_types table

198: and nvl(p_information_type,hr_api.g_varchar2)
199: <> nvl(pqh_pte_shd.g_old_rec.information_type,hr_api.g_varchar2)
200: or not l_api_updating) then
201: --
202: -- check if information_type value exists in per_position_info_types table
203: --
204: open c1;
205: --
206: fetch c1 into l_dummy;