DBA Data[Home] [Help]

APPS.JTF_TTY_WEBADI_SALSTEAM_UPDATE dependencies on JTF_TTY_ALIGN_PTERR

Line 687: from jtf_tty_align_pterr pt,

683: AND al.alignment_id = l_align_id;
684:
685: CURSOR c_align_res_list(l_terr_grp_acct_id number)
686: IS select pt.RESOURCE_ID, pt.RSC_GROUP_ID , pt.RSC_ROLE_CODE
687: from jtf_tty_align_pterr pt,
688: jtf_tty_pterr_accts pa,
689: jtf_tty_align_accts aa
690: where pt.align_proposed_terr_id = pa.align_proposed_terr_id
691: and pa.align_acct_id = aa.align_acct_id

Line 2139: from jtf_tty_align_pterr pt,

2135: loop
2136: begin
2137: select 'x'
2138: into l_whether_exist
2139: from jtf_tty_align_pterr pt,
2140: jtf_tty_pterr_accts pa,
2141: jtf_tty_align_accts aa
2142: where aa.terr_group_account_id = l_terr_grp_acct_id
2143: and aa.alignment_id = p_alignment_id