APPS.JTF_TTY_OVERLAP_WEBADI_PKG dependencies on JTF_TTY_NAMED_ACCTS

Line 98: from jtf_tty_named_accts NA

94: and trunc(nvl(TG.active_to_date, sysdate)) >= trunc(sysdate) ;
95:
96: cursor c_NA_for_DUNS is
97: select distinct named_account_id
98: from jtf_tty_named_accts NA
99: ,hz_parties HZP
100: where HZP.party_id = NA.party_id
101: and HZP.duns_number_c = p_DUNS;
102:

Line 357: jtf_tty_named_Accts NA

353: , l_PARENT19
354: , l_TG20
355: , l_PARENT20
356: from
357: jtf_tty_named_Accts NA
358: ,hz_parties HZP
359: ,fnd_lookups LKP
360: where NA.named_account_id = NA_rec.named_Account_id
361: and NA.party_id = HZP.party_id

Line 649: jtf_tty_named_Accts NA

645: , l_PARENT19
646: , l_TG20
647: , l_PARENT20
648: from
649: jtf_tty_named_Accts NA
650: ,hz_parties HZP
651: ,fnd_lookups LKP
652: where NA.named_account_id = p_named_account_id
653: and NA.party_id = HZP.party_id

Line 903: jtf_tty_named_Accts NA

899: , l_TG20
900: , l_PARENT20
901:
902: from
903: jtf_tty_named_Accts NA
904: ,hz_parties HZP
905: ,fnd_lookups LKP
906: where NA.named_account_id = DUNS_NA_rec.named_account_id
907: and NA.party_id = HZP.party_id