APPS.IBE_CUSTOMER_ACCT_PVT dependencies on HZ_PARTY_SITES

Line 49: FROM hz_party_sites_v ps, hr_organization_information hr

45: site_use_type,
46: primary_per_type
47: FROM (
48: SELECT party_site_id, ps.site_use_type, ps.primary_per_type
49: FROM hz_party_sites_v ps, hr_organization_information hr
50: WHERE ps.party_id = c_party_id
51: AND ps.status = 'A'
52: AND nvl(ps.end_date_active, sysdate + 1) > sysdate
53: AND hr.organization_id = c_org_id

Line 58: FROM hz_party_sites_v ps

54: AND hr.org_information_context = c_hr_type
55: AND hr.org_information1 = ps.country
56: UNION
57: SELECT party_site_id, ps.site_use_type, ps.primary_per_type
58: FROM hz_party_sites_v ps
59: WHERE ps.party_id = c_party_id
60: AND ps.status = 'A'
61: AND nvl(ps.end_date_active,sysdate + 1) > sysdate
62: AND NOT EXISTS (

Line 762: From hz_locations hzl,hz_party_sites hps

758: AND site_use_type = Site_type;
759:
760: CURSOR c_location(l_party_site_id NUMBER) IS
761: Select hzl.city
762: From hz_locations hzl,hz_party_sites hps
763: Where hps.party_site_id = p_party_site_id
764: And hzl.location_id = hps.location_id;
765:
766:

Line 1278: from hz_cust_acct_sites hca,hz_cust_site_uses hcu,hz_party_sites hps

1274:
1275: cursor c_cust_acct_id (lin_custacct_siteuse_id number, lin_siteuse_type varchar2)
1276: is
1277: select hca.cust_acct_site_id, hca.cust_account_id,hps.party_id
1278: from hz_cust_acct_sites hca,hz_cust_site_uses hcu,hz_party_sites hps
1279: where
1280: hcu.site_use_id = lin_custacct_siteuse_id
1281: and hcu.site_use_code = lin_siteuse_type
1282: and hcu.cust_acct_site_id = hca.cust_acct_site_id