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
362: and NA.site_type_code = LKP.lookup_code
363: and LKP.lookup_type = 'JTF_TTY_SITE_TYPE_CODE';
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
654: and NA.site_type_code = LKP.lookup_code
655: and LKP.lookup_type = 'JTF_TTY_SITE_TYPE_CODE';
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
908: and NA.site_type_code = LKP.lookup_code
909: and LKP.lookup_type = 'JTF_TTY_SITE_TYPE_CODE';