DBA Data[Home] [Help]

APPS.JTF_TERR_ENGINE_GEN_PVT dependencies on JTF_RS_ROLES_VL

Line 551: from jtf_rs_roles_vl r

547: , lp_terr_group_account_id NUMBER) IS
548: SELECT distinct
549: b.role_code role_code
550: , r.role_name role_name
551: from jtf_rs_roles_vl r
552: , jtf_tty_role_prod_int a
553: , jtf_tty_terr_grp_roles b
554: where r.role_code = b.role_code
555: and a.terr_group_role_id = b.terr_group_role_id

Line 2258: from jtf_rs_roles_vl r

2254: BEGIN
2255:
2256: SELECT COUNT( DISTINCT b.role_code )
2257: into l_pi_count
2258: from jtf_rs_roles_vl r
2259: , jtf_tty_role_prod_int a
2260: , jtf_tty_terr_grp_roles b
2261: where r.role_code = b.role_code
2262: and a.terr_group_role_id = b.terr_group_role_id