DBA Data[Home] [Help]

APPS.JTF_TTY_WEBADI_SALSTEAM_UPDATE dependencies on JTF_TTY_ALIGN_ACCTS

Line 689: jtf_tty_align_accts aa

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
692: and aa.terr_group_account_id = l_terr_grp_acct_id
693: and aa.alignment_id = p_alignment_id;

Line 2141: jtf_tty_align_accts aa

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
2144: and aa.align_acct_id = pa.align_acct_id
2145: and pa.align_proposed_terr_id = pt.align_proposed_terr_id