APPS.IBE_CUSTOMER_ACCT_PVT dependencies on HZ_CUST_SITE_USES

Line 36: -- 4922991. CHECK FOR HZ_CUST_SITE_USES.STATUS='I' MAY NOT BE CORRECT IN SOME CASES

32: */
33:
34: l_orgId NUMBER;
35:
36: -- 4922991. CHECK FOR HZ_CUST_SITE_USES.STATUS='I' MAY NOT BE CORRECT IN SOME CASES
37: CURSOR C_address(c_party_id NUMBER,
38: c_site_use_type VARCHAR2,
39: c_hr_type VARCHAR2,
40: c_org_id NUMBER)

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 750: FROM hz_cust_site_uses

746: l_api_name VARCHAR2(30) := 'CUSTACCT_CREATCUSTACCTSITEUSE';
747:
748: CURSOR c_site_use(acct_site_id NUMBER, Site_type VARCHAR2) IS
749: SELECT site_use_id
750: FROM hz_cust_site_uses
751: WHERE cust_acct_site_id = acct_site_id
752: AND site_use_code = Site_type;
753:
754: CURSOR c_party_site_use(l_party_site_id NUMBER, Site_type VARCHAR2) IS

Line 992: from hz_cust_site_uses

988: -- changed for bug 4922991
989: CURSOR c_get_custsite_use(c_acct_site_id NUMBER,c_acct_site_type VARCHAR2) IS
990: select * from
991: ( select site_use_id, status
992: from hz_cust_site_uses
993: where cust_acct_site_id = c_acct_site_id and site_use_code = c_acct_site_type
994: order by status)
995: where rownum <2 ;
996:

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 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;