DBA Data[Home] [Help]

APPS.PQH_PEI_DDF dependencies on PQH_ROLES

Line 166: l_role_id pqh_roles.role_id%TYPE;

162: ) is
163:
164: --
165: l_proc varchar2(72) := g_package||'chk_default_role';
166: l_role_id pqh_roles.role_id%TYPE;
167: l_role_name pqh_roles.role_name%TYPE;
168: --
169: CURSOR csr_duplicate_role IS
170: SELECT pei_information3

Line 167: l_role_name pqh_roles.role_name%TYPE;

163:
164: --
165: l_proc varchar2(72) := g_package||'chk_default_role';
166: l_role_id pqh_roles.role_id%TYPE;
167: l_role_name pqh_roles.role_name%TYPE;
168: --
169: CURSOR csr_duplicate_role IS
170: SELECT pei_information3
171: FROM per_people_extra_info