APPS.IBE_CUSTOMER_ACCT_PVT dependencies on HZ_CUST_ACCT_SITES

Line 76: AND ( NOT EXISTS (SELECT 1 FROM hz_cust_acct_sites cas

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: )
76: AND ( NOT EXISTS (SELECT 1 FROM hz_cust_acct_sites cas
77: WHERE cas.party_site_id = o.party_site_id
78: ) OR
79: (EXISTS (SELECT 1 FROM hz_cust_acct_sites cas
80: where cas.party_site_id = o.party_site_id

Line 79: (EXISTS (SELECT 1 FROM hz_cust_acct_sites cas

75: )
76: AND ( NOT EXISTS (SELECT 1 FROM hz_cust_acct_sites cas
77: WHERE cas.party_site_id = o.party_site_id
78: ) OR
79: (EXISTS (SELECT 1 FROM hz_cust_acct_sites cas
80: where cas.party_site_id = o.party_site_id
81: and cas.status = 'A')
82: AND
83: ( NOT EXISTS (SELECT 1 FROM hz_cust_acct_sites cas, hz_cust_site_uses_all csu

Line 83: ( NOT EXISTS (SELECT 1 FROM hz_cust_acct_sites cas, hz_cust_site_uses_all csu

79: (EXISTS (SELECT 1 FROM hz_cust_acct_sites cas
80: where cas.party_site_id = o.party_site_id
81: and cas.status = 'A')
82: AND
83: ( NOT EXISTS (SELECT 1 FROM hz_cust_acct_sites cas, hz_cust_site_uses_all csu
84: WHERE csu.cust_acct_site_id = cas.cust_acct_site_id
85: AND cas.party_site_id = o.party_site_id
86: AND cas.org_id = csu.org_id
87: AND csu.site_use_code = o.site_use_type)

Line 90: FROM hz_cust_acct_sites_all cas, hz_cust_site_uses_all csu

86: AND cas.org_id = csu.org_id
87: AND csu.site_use_code = o.site_use_type)
88: OR
89: EXISTS ( SELECT 1
90: FROM hz_cust_acct_sites_all cas, hz_cust_site_uses_all csu
91: WHERE cas.party_site_id = o.party_site_id
92: AND cas.org_id = csu.org_id
93: AND csu.cust_acct_site_id = cas.cust_acct_site_id
94: AND csu.status = 'A'

Line 570: FROM hz_cust_acct_sites

566: IS
567:
568: CURSOR c_acct_site (account_id NUMBER, site_id NUMBER) IS
569: SELECT cust_acct_site_id
570: FROM hz_cust_acct_sites
571: WHERE cust_account_id = account_id
572: AND party_site_id = site_id;
573:
574: p_acct_site_rec HZ_CUST_ACCOUNT_SITE_V2PUB.cust_acct_site_rec_type;

Line 981: from hz_cust_acct_sites

977: c_party_site_id NUMBER)
978: IS
979:
980: select cust_acct_site_id,status
981: from hz_cust_acct_sites
982: where cust_account_id = c_cust_acct_id
983: AND party_site_id = c_party_site_id;
984:
985: -- changed for bug 4922991

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

Line 1286: --, hz_cust_acct_sites_all c

1282:
1283: cursor c_cust_role(lin_party_id number,lin_custacct_site_id number,lin_custacct_id number) is
1284: select a.cust_account_role_id, a.status
1285: from hz_cust_account_roles a
1286: --, hz_cust_acct_sites_all c
1287: where
1288: a.role_type = 'CONTACT'
1289: and a.party_id = lin_party_id
1290: and a.cust_account_id = lin_custacct_id

Line 1465: from hz_cust_site_uses hcs,hz_cust_acct_sites hca

1461: IS
1462:
1463: CURSOR c_cust_acct_det(lc_inv_to_org_id NUMBER) IS
1464: select hca.cust_account_id, hca.party_site_id, hcs.status
1465: from hz_cust_site_uses hcs,hz_cust_acct_sites hca
1466: where hcs.site_use_id = lc_inv_to_org_id and
1467: hcs.cust_acct_site_id = hca.cust_acct_site_id;
1468:
1469: lc_cust_acct_det c_cust_acct_det%rowtype;