APPS.JTF_TERR_ENGINE_GEN_PVT dependencies on JTF_TTY_ROLE_PROD_INT

Line 494: FROM jtf_tty_role_prod_int rpi

490: AND nar.rsc_role_code = tgr.role_code
491: AND ra.terr_group_role_id = tgr.terr_group_role_id
492: AND NOT EXISTS (
493: SELECT NULL
494: FROM jtf_tty_role_prod_int rpi
495: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id );
496:
497:
498: /* Access Types for a Territory Group */

Line 518: FROM jtf_tty_role_prod_int rpi

514: and b.role_code = lp_role
515: AND NOT EXISTS (
516: /* Product Interest does not exist for this role */
517: SELECT NULL
518: FROM jtf_tty_role_prod_int rpi
519: WHERE rpi.terr_group_role_id = B.TERR_GROUP_ROLE_ID )
520: order by a.access_type ;
521:
522:

Line 538: from jtf_tty_role_prod_int a

534: CURSOR role_interest_nonpi(l_terr_group_id number) IS
535: SELECT b.role_code role_code
536: --,a.interest_type_id
537: ,b.terr_group_id
538: from jtf_tty_role_prod_int a
539: , jtf_tty_terr_grp_roles b
540: where a.terr_group_role_id(+) = b.terr_group_role_id
541: and b.terr_group_id = l_terr_group_id
542: and a.terr_group_role_id is null

Line 552: , jtf_tty_role_prod_int a

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
556: and b.terr_group_id = lp_terr_group_id

Line 569: from jtf_tty_role_prod_int a

565:
566: /* Product Interest for a Role */
567: CURSOR role_pi_interest(l_terr_group_id number,l_role varchar2) IS
568: SELECT a.interest_type_id
569: from jtf_tty_role_prod_int a
570: , jtf_tty_terr_grp_roles b
571: where a.terr_group_role_id = b.terr_group_role_id
572: and b.terr_group_id = l_terr_group_id
573: and b.role_code = l_role;

Line 670: , jtf_tty_role_prod_int rpi

666: /* Salesperson, with Role that has a Product
667: ** Interest defined, exists for this Named Account */
668: SELECT NULL
669: FROM jtf_tty_named_acct_rsc nar
670: , jtf_tty_role_prod_int rpi
671: , jtf_tty_terr_grp_roles tgr
672: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id
673: AND tgr.terr_group_id = C.TERR_GROUP_ID
674: AND tgr.role_code = nar.rsc_role_code

Line 702: , jtf_tty_role_prod_int rpi

698: /* Salesperson, with Role that has a Product
699: ** Interest defined, exists for this Named Account */
700: SELECT NULL
701: FROM jtf_tty_named_acct_rsc nar
702: , jtf_tty_role_prod_int rpi
703: , jtf_tty_terr_grp_roles tgr
704: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id
705: AND tgr.terr_group_id = C.TERR_GROUP_ID
706: AND tgr.role_code = nar.rsc_role_code

Line 783: , jtf_tty_role_prod_int c

779: CURSOR role_no_pi(l_terr_group_id number) IS
780: SELECT distinct b.role_code
781: from jtf_tty_role_access a
782: , jtf_tty_terr_grp_roles b
783: , jtf_tty_role_prod_int c
784: where a.terr_group_role_id = b.terr_group_role_id
785: and b.terr_group_id = l_terr_group_id
786: and a.access_type = 'ACCOUNT'
787: and c.terr_group_role_id = b.terr_group_role_id

Line 789: from jtf_tty_role_prod_int e

785: and b.terr_group_id = l_terr_group_id
786: and a.access_type = 'ACCOUNT'
787: and c.terr_group_role_id = b.terr_group_role_id
788: and not exists ( SELECT 1
789: from jtf_tty_role_prod_int e
790: , jtf_tty_terr_grp_roles d
791: where e.terr_group_role_id (+) = d.terr_group_role_id
792: and d.terr_group_id = b.terr_group_id
793: and d.role_code = b.role_code

Line 2259: , jtf_tty_role_prod_int a

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
2263: and b.terr_group_id = TERR_GROUP.TERR_GROUP_ID