APPS.JTF_TTY_WEBADI_SALSTEAM_UPDATE dependencies on JTF_TTY_NAMED_ACCT_RSC

Line 164: jtf_tty_named_acct_rsc nar

160: LOOP
161: BEGIN
162: SELECT 'VALID' INTO l_select
163: FROM jtf_tty_terr_grp_accts tga,
164: jtf_tty_named_acct_rsc nar
165: WHERE nar.terr_group_account_id = tga.terr_group_account_id
166: AND nar.rsc_role_code = X_ROLE_CODE
167: AND nar.resource_id = l_res_tbl(i)
168: AND nar.rsc_group_id = X_GROUP_ID

Line 663: from jtf_tty_named_acct_rsc

659: P_ALIGNMENT_ID in varchar2) is
660:
661: CURSOR c_res_list(l_terr_grp_acct_id number)
662: IS select RESOURCE_ID, RSC_GROUP_ID , RSC_ROLE_CODE
663: from jtf_tty_named_acct_rsc
664: where TERR_GROUP_ACCOUNT_ID = l_terr_grp_acct_id;
665:
666: CURSOR c_res_list_for_align(c_terr_grp_acct_id number, c_user_id number)
667: IS SELECT narsc.resource_id resource_id,

Line 670: FROM jtf_tty_named_acct_rsc narsc

666: CURSOR c_res_list_for_align(c_terr_grp_acct_id number, c_user_id number)
667: IS SELECT narsc.resource_id resource_id,
668: narsc.rsc_group_id rsc_group_id,
669: narsc.rsc_role_code rsc_role_code
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

Line 839: from jtf_tty_named_acct_rsc narsc,

835: /* check if the salesperson(by user_id) is able to change the named account(by tgid).
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

Line 849: FROM jtf_tty_named_acct_rsc narsc

845: and rownum < 2;
846: */
847: SELECT narsc.resource_id
848: INTO l_resource_id
849: FROM jtf_tty_named_acct_rsc narsc
850: WHERE narsc.terr_group_account_id = l_terr_grp_acct_id
851: AND EXISTS (
852: SELECT 'Y'
853: FROM jtf_rs_group_members grpmemo ,

Line 2035: from jtf_tty_named_acct_rsc

2031: loop
2032: begin
2033: select ASSIGNED_FLAG
2034: into l_assign_flag
2035: from jtf_tty_named_acct_rsc
2036: where TERR_GROUP_ACCOUNT_ID = l_terr_grp_acct_id
2037: and RESOURCE_ID = l_added_rscs_tbl(j).Resource_id
2038: and RSC_GROUP_ID = l_added_rscs_tbl(j).group_id
2039: and RSC_ROLE_CODE = l_added_rscs_tbl(j).role_code