APPS.POS_HZ_PARTY_SITE_BO_TBL_PKG dependencies on HZ_PARTY_SITES

Line 70: Party Site Y N HZ_PARTY_SITES

66:
67: Embedded TCA Entity Mandatory Multiple TCA Table Entities
68:
69: Location Y N HZ_LOCATIONS
70: Party Site Y N HZ_PARTY_SITES
71: Party Site Use N Y HZ_PARTY_SITE_USES
72: Contact Preference N Y HZ_CONTACT_PREFERENCES
73: */
74:

Line 131: FROM hz_party_sites ps

127: ps.party_site_id,
128: NULL,
129: 'SUPP_ADDR_LEVEL')) BULK COLLECT
130: INTO x_party_site_objs
131: FROM hz_party_sites ps
132: WHERE party_id = p_party_id;
133:
134: --Commented by BVAMSI on 07/Oct/2010 as it is already handled in the above Select query
135: /*