APPS.OKL_SSC_WF dependencies on HZ_PARTY_SITES

Line 1365: l_instance_rec_type.INSTALL_LOCATION_TYPE_CODE := 'HZ_PARTY_SITES';

1361: FOR csr_3 in okl_loc_csr(l_id1_id, l_id2_id)
1362: loop
1363: l_instance_rec_type.LOCATION_ID := TO_NUMBER(csr_3.LOCATION_ID);
1364: l_instance_rec_type.INSTALL_LOCATION_ID := TO_NUMBER(csr_3.PARTY_SITE_ID);
1365: l_instance_rec_type.INSTALL_LOCATION_TYPE_CODE := 'HZ_PARTY_SITES';
1366: end loop;
1367:
1368: select object_version_number into l_object_version_number from
1369: csi_item_instances

Line 2231: hz_party_sites ps,

2227: L.ADDRESS4,L.CITY,L.COUNTY,L.STATE,L.PROVINCE,L.POSTAL_CODE,NULL,L.COUNTRY,NULL,
2228: NULL,NULL,NULL,NULL,NULL,NULL,'N','N',300,1,1) bill_to_address
2229: FROM hz_cust_site_uses_all cs,
2230: hz_cust_acct_sites_all ca,
2231: hz_party_sites ps,
2232: hz_locations l,
2233: okc_k_headers_all_b contract
2234: WHERE cs.cust_acct_site_id = ca.cust_acct_site_id
2235: AND ca.party_site_id = ps.party_site_id

Line 2276: HZ_PARTY_SITES PS,

2272: L.ADDRESS4,L.CITY,L.COUNTY,L.STATE,L.PROVINCE,L.POSTAL_CODE,NULL,L.COUNTRY,NULL,
2273: NULL,NULL,NULL,NULL,NULL,NULL,'N','N',300,1,1) BILL_TO_ADDRESS
2274: FROM HZ_CUST_SITE_USES_ALL CS,
2275: HZ_CUST_ACCT_SITES_ALL CA,
2276: HZ_PARTY_SITES PS,
2277: HZ_LOCATIONS L
2278: WHERE CS.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
2279: AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID
2280: AND PS.LOCATION_ID = L.LOCATION_ID