APPS.JTF_TTY_WEBADI_SALSTEAM_UPDATE dependencies on JTF_TTY_SRCH_MY_RESOURCES_V

Line 386: FROM jtf_tty_srch_my_resources_v /*jtf_tty_my_resources_v*/ grv,

382: /* check salesperson for the current TG */
383: BEGIN
384: SELECT 'VALID'
385: INTO l_select
386: FROM jtf_tty_srch_my_resources_v /*jtf_tty_my_resources_v*/ grv,
387: jtf_tty_terr_grp_owners jto
388: WHERE EXISTS
389: ( SELECT NULL
390: FROM JTF_RS_GROUPS_DENORM /*jtf_rs_grp_denorm_vl*/ grpd

Line 674: from jtf_tty_srch_my_resources_v mydir

670: FROM jtf_tty_named_acct_rsc narsc
671: WHERE narsc.terr_group_account_id = c_terr_grp_acct_id
672: AND (narsc.resource_id, narsc.rsc_group_id, narsc.rsc_role_code ) IN
673: ( select /*+ NO_MERGE */ mydir.resource_id, mydir.group_id, mydir.role_code
674: from jtf_tty_srch_my_resources_v mydir
675: where mydir.current_user_id = c_user_id );
676:
677: CURSOR c_get_user_id (l_align_id number )
678: IS SELECT rsc.user_id

Line 840: jtf_tty_srch_my_resources_v repdn -- jtf_tty_my_resources_v

836: The query below was modified to consider accounts belonging to inactive reps also*/
837: /*
838: select narsc.resource_id INTO l_resource_id
839: from jtf_tty_named_acct_rsc narsc,
840: jtf_tty_srch_my_resources_v repdn -- jtf_tty_my_resources_v
841: where narsc.resource_id = repdn.resource_id
842: and narsc.rsc_group_id = repdn.group_id
843: and repdn.current_user_id = l_user_id
844: and narsc.terr_group_account_id = l_terr_grp_acct_id