DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 4354: jtf_rs_resource_extns sre

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
4357: AND NVL(rr.delete_flag,'N') <> 'Y'
4358: AND rr.Role_resource_type = 'RS_INDIVIDUAL'

Line 4374: jtf_rs_resource_extns sre,

4370:
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