APPS.JTF_TTY_NA_GEO_TERR_PVT dependencies on JTF_TTY_ACCT_QUAL_MAPS

Line 578: , jtf_tty_acct_qual_maps b

574: CURSOR catchall_cust(l_terr_group_id number) IS
575: SELECT distinct b.comparison_operator
576: ,b.value1_char
577: from jtf_tty_terr_grp_accts a
578: , jtf_tty_acct_qual_maps b
579: where a.named_account_id = b.named_account_id
580: and a.terr_group_id = l_terr_group_id
581: and b.qual_usg_id = -1012
582: order by b.comparison_operator,b.value1_char;

Line 639: from jtf_tty_acct_qual_maps d

635: and a.status = 'A'
636: and exists (
637: /* Named Account has at least 1 Mapping Rule */
638: SELECT 1
639: from jtf_tty_acct_qual_maps d
640: where d.named_account_id = c.named_account_id )
641: AND EXISTS (
642: /* Salesperson exists for this Named Account */
643: SELECT NULL

Line 693: from jtf_tty_acct_qual_maps d

689: and a.status = 'A'
690: and exists (
691: /* Named Account has at least 1 Mapping Rule */
692: SELECT 1
693: from jtf_tty_acct_qual_maps d
694: where d.named_account_id = c.named_account_id )
695: AND EXISTS (
696: /* Salesperson, with Role that has a Product
697: ** Interest defined, exists for this Named Account */

Line 719: FROM jtf_tty_acct_qual_maps b

715: SELECT b.qual_usg_id
716: , b.comparison_operator
717: , b.value1_char
718: , b.value2_char
719: FROM jtf_tty_acct_qual_maps b
720: WHERE b.qual_usg_id IN (-1007, -1012)
721: AND b.named_account_id = l_na_id
722: ORDER BY b.qual_usg_id;
723: