APPS.IBE_CUSTOMER_ACCT_PVT dependencies on HZ_PARTY_SITES

Line 46: FROM hz_party_sites_v ps, hr_organization_information hr

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

Line 55: FROM hz_party_sites_v ps

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

Line 759: From hz_locations hzl,hz_party_sites hps

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

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

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