DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 4352: jtf_rs_role_relations rr,

4348:
4349: CURSOR quote_sales_team_csr(p_quote_number IN aso_quote_headers_all.quote_number%TYPE) IS
4350: SELECT sre.user_id
4351: FROM aso_quote_accesses sales_team,
4352: jtf_rs_role_relations rr,
4353: jtf_rs_roles_b rl,
4354: jtf_rs_resource_extns sre
4355: WHERE sales_team.quote_number = p_quote_number
4356: AND rr.ROLE_ID = rl.ROLE_ID

Line 4375: jtf_rs_role_relations rr,

4371: CURSOR con_admin_role_member_csr(p_sales_group_id IN aso_quote_headers_all.resource_grp_id%TYPE) IS
4372: SELECT sre.user_id
4373: FROM jtf_rs_group_members srg,
4374: jtf_rs_resource_extns sre,
4375: jtf_rs_role_relations rr,
4376: jtf_rs_roles_b rl
4377: WHERE srg.group_id = p_sales_group_id
4378: AND srg.resource_id = sre.resource_id
4379: AND NVL(srg.delete_flag,'N') <> 'Y'