DBA Data[Home] [Help]

APPS.JTF_TTY_MAINTAIN_NA_PVT dependencies on HZ_LOCATIONS

Line 462: HZ_LOCATIONS H1,

458: INTO l_business_name,
459: l_trade_name,
460: l_postal_code
461: FROM HZ_PARTIES H3,
462: HZ_LOCATIONS H1,
463: HZ_PARTY_SITES H2
464: WHERE h3.party_id = h2.party_id
465: AND h2.location_id = h1.location_id
466: AND h3.party_id = p_party_id