APPS.JTF_TTY_NACCT_SALES_PUB dependencies on JTF_TTY_TERR_GRP_ACCTS

Line 149: jtf_tty_terr_grp_accts gai,

145: cursor c_subsidiaries(cl_terr_group_account_id number) is
146: select distinct gao.terr_group_account_id
147: from hz_relationships hzr,
148: jtf_tty_named_accts nai,
149: jtf_tty_terr_grp_accts gai,
150: jtf_tty_named_accts nao,
151: jtf_tty_terr_grp_accts gao
152: where gao.named_account_id = nao.named_account_id
153: and nao.party_id = hzr.object_id -- these are the subsidiary parties

Line 151: jtf_tty_terr_grp_accts gao

147: from hz_relationships hzr,
148: jtf_tty_named_accts nai,
149: jtf_tty_terr_grp_accts gai,
150: jtf_tty_named_accts nao,
151: jtf_tty_terr_grp_accts gao
152: where gao.named_account_id = nao.named_account_id
153: and nao.party_id = hzr.object_id -- these are the subsidiary parties
154: and hzr.subject_table_name = 'HZ_PARTIES'
155: and hzr.object_table_name = 'HZ_PARTIES'

Line 167: -- jtf_tty_terr_grp_accts ga

163: and exists( select 'Y'
164: from jtf_tty_named_acct_rsc narsc ,
165: jtf_tty_my_resources_v repdn
166: -- jtf_tty_named_accts na,
167: -- jtf_tty_terr_grp_accts ga
168: where narsc.terr_group_account_id = gao.terr_group_account_id
169: -- and ga.named_account_id = na.named_account_id
170: and narsc.resource_id = repdn.resource_id
171: and narsc.rsc_group_id = repdn.group_id

Line 688: **** JTF_TTY_TERR_GRP_ACCTS

684:
685: /***********************************************************
686: **** PHASE II: PROCESS OTHER TABLES
687: **** Changes made only to JTF_TTY_RSC_ACCT_SUMM
688: **** JTF_TTY_TERR_GRP_ACCTS
689: ************************************************************/
690: --dbms_output.put_line('PHASE II ');
691:
692:

Line 701: -- PROCESS JTF_TTY_TERR_GRP_ACCTS

697: IF (G_AFFECT_PARTY_TBL.last > 0) THEN
698:
699:
700: ---------------------------------------------
701: -- PROCESS JTF_TTY_TERR_GRP_ACCTS
702: ---------------------------------------------
703: FOR i in G_AFFECT_PARTY_TBL.first.. G_AFFECT_PARTY_TBL.last LOOP
704: ----dbms_output.put_line('G_AFFECT_PARTY_TBL ' || i || G_AFFECT_PARTY_TBL(j).party_id);
705:

Line 722: UPDATE JTF_TTY_TERR_GRP_ACCTS

718: else
719: l_assign_flag := 'Y';
720: end if;
721:
722: UPDATE JTF_TTY_TERR_GRP_ACCTS
723: SET DN_JNR_ASSIGNED_FLAG = l_assign_flag
724: WHERE TERR_GROUP_ACCOUNT_ID = l_terr_group_account_id;
725:
726: END LOOP; -- G_AFFECT_PARTY_TBL

Line 738: FROM jtf_tty_terr_grp_accts

734:
735: FOR i IN G_AFFECT_PARTY_TBL.first.. G_AFFECT_PARTY_TBL.last LOOP
736:
737: SELECT terr_group_id INTO l_terr_group_id
738: FROM jtf_tty_terr_grp_accts
739: WHERE terr_group_account_id = G_AFFECT_PARTY_TBL(i).terr_group_account_id;
740:
741: Jtf_Tty_Gen_Terr_Pvt.update_terr_rscs_for_na
742: (G_AFFECT_PARTY_TBL(i).terr_group_account_id,