DBA Data[Home] [Help]

APPS.JTF_TTY_OVERLAP_WEBADI_PKG dependencies on FND_LOOKUPS

Line 359: ,fnd_lookups LKP

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';

Line 651: ,fnd_lookups LKP

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';

Line 905: ,fnd_lookups LKP

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';