APPS.JTF_TTY_NA_TERRGP dependencies on JTF_TTY_MY_RESOURCES_V

Line 1675: FROM jtf_tty_my_resources_v mdv,

1671: CURSOR all_managers_c
1672: IS SELECT mdv.resource_id,
1673: mdv.group_id,
1674: mdv.dir_user_id
1675: FROM jtf_tty_my_resources_v mdv,
1676: jtf_rs_group_members mem,
1677: jtf_rs_roles_b rol,
1678: jtf_rs_role_relations rlt
1679: WHERE rlt.role_resource_type = 'RS_GROUP_MEMBER'

Line 1696: FROM jtf_tty_my_resources_v sdv,

1692: CURSOR all_salesreps_c
1693: IS SELECT DISTINCT sdv.resource_id,
1694: sdv.group_id,
1695: sdv.dir_user_id
1696: FROM jtf_tty_my_resources_v sdv,
1697: jtf_rs_group_members mem,
1698: jtf_rs_roles_b rol,
1699: jtf_rs_role_relations rlt
1700: WHERE rlt.role_resource_type = 'RS_GROUP_MEMBER'

Line 1733: jtf_tty_my_resources_v repdn,

1729: SELECT COUNT(DISTINCT na.named_account_id) num_accounts
1730: FROM
1731: jtf_tty_named_accts na,
1732: jtf_tty_terr_grp_accts ga,
1733: jtf_tty_my_resources_v repdn,
1734: jtf_tty_named_acct_rsc narsc,
1735: jtf_rs_resource_extns rs,
1736: jtf_rs_group_members mem,
1737: jtf_tty_terr_groups ttygrp

Line 1757: jtf_tty_my_resources_v repdn,

1753: SELECT COUNT(DISTINCT na.named_account_id) num_accounts
1754: FROM
1755: jtf_tty_named_accts na,
1756: jtf_tty_terr_grp_accts ga,
1757: jtf_tty_my_resources_v repdn,
1758: jtf_tty_named_acct_rsc narsc,
1759: jtf_rs_resource_extns rs,
1760: jtf_rs_group_members mem,
1761: jtf_tty_terr_groups ttygrp