APPS.HZ_UTILITY_V2PUB dependencies on HZ_PARTY_SITE_USES

Line 1917: hz_party_site_uses psu,

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
1921: psu.party_site_id = ps.party_site_id and

Line 1980: hz_party_site_uses psu,

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
1984: psu.party_site_id = ps.party_site_id and

Line 2950: from hz_party_site_uses psu

2946: l_bill_to_primary VARCHAR2(1000);
2947: l_primary VARCHAR2(10);
2948: cursor c_site_bill_to (l_party_site_id IN NUMBER) is
2949: select psu.primary_per_type
2950: from hz_party_site_uses psu
2951: where
2952: psu.party_site_id = l_party_site_id and
2953: psu.status = 'A' and
2954: psu.site_use_type = 'BILL_TO' and

Line 3005: from hz_party_site_uses psu

3001: l_ship_to_primary VARCHAR2(1000);
3002: l_primary VARCHAR2(10);
3003: cursor c_site_ship_to (l_party_site_id IN NUMBER) is
3004: select psu.primary_per_type
3005: from hz_party_site_uses psu
3006: where
3007: psu.party_site_id = l_party_site_id and
3008: psu.status = 'A' and
3009: psu.site_use_type = 'SHIP_TO' and