APPS.IBE_CUSTOMER_ACCT_PVT dependencies on HZ_CUST_ACCT_SITES

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

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

Line 82: (EXISTS (SELECT 1 FROM hz_cust_acct_sites cas

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

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

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

Line 93: FROM hz_cust_acct_sites_all cas, hz_cust_site_uses_all csu

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

Line 573: FROM hz_cust_acct_sites

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

Line 984: from hz_cust_acct_sites

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

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

Line 1289: --, hz_cust_acct_sites_all c

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

Line 1468: from hz_cust_site_uses hcs,hz_cust_acct_sites hca

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