APPS.IBE_CUSTOMER_ACCT_PVT dependencies on HZ_CUST_SITE_USES

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

29: SELECT NVL(TO_NUMBER(DECODE(l_orgId1,' ',NULL,l_orgId2)),-99) orgId from dual;
30:
31: l_orgId NUMBER;
32:
33: -- 4922991. CHECK FOR HZ_CUST_SITE_USES.STATUS='I' MAY NOT BE CORRECT IN SOME CASES
34: CURSOR C_address(c_party_id NUMBER,
35: c_site_use_type VARCHAR2,
36: c_hr_type VARCHAR2,
37: c_org_id NUMBER)

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

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

Line 989: from hz_cust_site_uses

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

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