APPS.HZ_UTILITY_V2PUB dependencies on HZ_PARTY_SITES

Line 1916: from hz_party_sites ps,

1912: cursor c_site_use_purposes (l_party_site_id IN NUMBER) is
1913: select al.MEANING
1914: -- psu.site_use_type,
1915: -- psu.primary_per_type
1916: from hz_party_sites ps,
1917: hz_party_site_uses psu,
1918: ar_lookups al
1919: where
1920: ps.party_site_id = l_party_site_id and

Line 1979: from hz_party_sites ps,

1975: l_all_site_use_purposes VARCHAR2(1000) := '';
1976:
1977: cursor c_site_use_purposes (l_party_site_id IN NUMBER) is
1978: select al.MEANING
1979: from hz_party_sites ps,
1980: hz_party_site_uses psu,
1981: ar_lookups al
1982: where
1983: ps.party_site_id = l_party_site_id and

Line 2340: IF p_desc_flex_name <> 'HZ_PARTY_SITES' THEN

2336: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17 );
2337: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18 );
2338: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19 );
2339: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20 );
2340: IF p_desc_flex_name <> 'HZ_PARTY_SITES' THEN
2341: fnd_flex_descval.set_column_value('ATTRIBUTE21', p_attribute21 );
2342: fnd_flex_descval.set_column_value('ATTRIBUTE22', p_attribute22 );
2343: fnd_flex_descval.set_column_value('ATTRIBUTE23', p_attribute23 );
2344: fnd_flex_descval.set_column_value('ATTRIBUTE24', p_attribute24 );