APPS.IBE_CUSTOMER_ACCT_PVT dependencies on HZ_PARTY_SITE_USES

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

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

Line 74: EXISTS (SELECT 1 FROM hz_party_site_uses psu

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

Line 756: FROM hz_party_site_uses

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