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 2966: from hz_party_site_uses psu

2962: l_bill_to_primary VARCHAR2(1000);
2963: l_primary VARCHAR2(10);
2964: cursor c_site_bill_to (l_party_site_id IN NUMBER) is
2965: select psu.primary_per_type
2966: from hz_party_site_uses psu
2967: where
2968: psu.party_site_id = l_party_site_id and
2969: psu.status = 'A' and
2970: psu.site_use_type = 'BILL_TO' and

Line 3021: from hz_party_site_uses psu

3017: l_ship_to_primary VARCHAR2(1000);
3018: l_primary VARCHAR2(10);
3019: cursor c_site_ship_to (l_party_site_id IN NUMBER) is
3020: select psu.primary_per_type
3021: from hz_party_site_uses psu
3022: where
3023: psu.party_site_id = l_party_site_id and
3024: psu.status = 'A' and
3025: psu.site_use_type = 'SHIP_TO' and