APPS.PQH_PA_WHATIF_PROCESS dependencies on PQH_ROLES

Line 3864: From pqh_roles rls

3860: ,p_role_id OUT NOCOPY NUMBER
3861: ) IS
3862: Cursor csr_user_role IS
3863: Select rls.role_id
3864: From pqh_roles rls
3865: ,per_people_extra_info pei
3866: ,fnd_user usr
3867: Where rls.role_type_cd=p_user_type
3868: and nvl(rls.enable_flag,'N')='Y'

Line 3878: From pqh_roles

3874: and usr.user_id=p_user_id;
3875:
3876: Cursor csr_default_role IS
3877: Select role_id
3878: From pqh_roles
3879: Where role_type_cd=p_user_type
3880: and role_name='XXXX';
3881:
3882: l_proc VARCHAR2(72);