DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 4403: jtf_rs_resource_extns sre

4399: SELECT sre.user_id
4400: FROM aso_quote_accesses sales_team,
4401: jtf_rs_role_relations rr,
4402: jtf_rs_roles_b rl,
4403: jtf_rs_resource_extns sre
4404: WHERE sales_team.quote_number = p_quote_number
4405: AND rr.ROLE_ID = rl.ROLE_ID
4406: AND NVL(rr.delete_flag,'N') <> 'Y'
4407: AND rr.Role_resource_type = 'RS_INDIVIDUAL'

Line 4423: jtf_rs_resource_extns sre,

4419:
4420: CURSOR con_admin_role_member_csr(p_sales_group_id IN aso_quote_headers_all.resource_grp_id%TYPE) IS
4421: SELECT sre.user_id
4422: FROM jtf_rs_group_members srg,
4423: jtf_rs_resource_extns sre,
4424: jtf_rs_role_relations rr,
4425: jtf_rs_roles_b rl
4426: WHERE srg.group_id = p_sales_group_id
4427: AND srg.resource_id = sre.resource_id