DBA Data[Home] [Help]

APPS.PQH_RLS_BUS dependencies on PQH_POSITION_ROLES_V

Line 369: FROM pqh_position_roles_v

365: --
366:
367: CURSOR csr_role_positions IS
368: SELECT count(*)
369: FROM pqh_position_roles_v
370: WHERE role_id = p_role_id;
371:
372: CURSOR csr_role_name IS
373: SELECT role_name

Line 627: from pqh_position_roles_v

623: and nvl(enable_flag,'N') = 'Y';
624: --
625: cursor csr_cnt_positions is
626: select count(*)
627: from pqh_position_roles_v
628: where role_id = NVL(p_role_id,0);
629: --
630: cursor csr_cnt_users is
631: select count(*)