DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 4401: jtf_rs_role_relations rr,

4397:
4398: CURSOR quote_sales_team_csr(p_quote_number IN aso_quote_headers_all.quote_number%TYPE) IS
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

Line 4424: jtf_rs_role_relations rr,

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
4428: AND NVL(srg.delete_flag,'N') <> 'Y'