APPS.IBE_CUSTOMER_ACCT_PVT dependencies on HZ_PARTY_SITE_USES

Line 67: WHERE ( NOT EXISTS (SELECT 1 FROM hz_party_site_uses psu

63: AND hr.org_information_context = c_hr_type
64: AND rownum = 1
65: )
66: ) o
67: WHERE ( NOT EXISTS (SELECT 1 FROM hz_party_site_uses psu
68: WHERE psu.party_site_id = o.party_site_id
69: AND psu.site_use_type = o.site_use_type
70: ) OR
71: EXISTS (SELECT 1 FROM hz_party_site_uses psu

Line 71: EXISTS (SELECT 1 FROM hz_party_site_uses psu

67: WHERE ( NOT EXISTS (SELECT 1 FROM hz_party_site_uses psu
68: WHERE psu.party_site_id = o.party_site_id
69: AND psu.site_use_type = o.site_use_type
70: ) OR
71: EXISTS (SELECT 1 FROM hz_party_site_uses psu
72: WHERE psu.party_site_id = o.party_site_id
73: AND psu.site_use_type = o.site_use_type
74: AND psu.status = 'A')
75: )

Line 753: FROM hz_party_site_uses

749: AND site_use_code = Site_type;
750:
751: CURSOR c_party_site_use(l_party_site_id NUMBER, Site_type VARCHAR2) IS
752: SELECT party_site_use_id
753: FROM hz_party_site_uses
754: WHERE party_site_id = l_party_site_id
755: AND site_use_type = Site_type;
756:
757: CURSOR c_location(l_party_site_id NUMBER) IS