APPS.OKL_SSC_WF dependencies on HZ_PARTY_SITES

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

1275: FOR csr_3 in okl_loc_csr(l_id1_id, l_id2_id)
1276: loop
1277: l_instance_rec_type.LOCATION_ID := TO_NUMBER(csr_3.LOCATION_ID);
1278: l_instance_rec_type.INSTALL_LOCATION_ID := TO_NUMBER(csr_3.PARTY_SITE_ID);
1279: l_instance_rec_type.INSTALL_LOCATION_TYPE_CODE := 'HZ_PARTY_SITES';
1280: end loop;
1281:
1282: select object_version_number into l_object_version_number from
1283: csi_item_instances

Line 2145: hz_party_sites ps,

2141: L.ADDRESS4,L.CITY,L.COUNTY,L.STATE,L.PROVINCE,L.POSTAL_CODE,NULL,L.COUNTRY,NULL,
2142: NULL,NULL,NULL,NULL,NULL,NULL,'N','N',300,1,1) bill_to_address
2143: FROM hz_cust_site_uses_all cs,
2144: hz_cust_acct_sites_all ca,
2145: hz_party_sites ps,
2146: hz_locations l,
2147: okc_k_headers_all_b contract
2148: WHERE cs.cust_acct_site_id = ca.cust_acct_site_id
2149: AND ca.party_site_id = ps.party_site_id

Line 2190: HZ_PARTY_SITES PS,

2186: L.ADDRESS4,L.CITY,L.COUNTY,L.STATE,L.PROVINCE,L.POSTAL_CODE,NULL,L.COUNTRY,NULL,
2187: NULL,NULL,NULL,NULL,NULL,NULL,'N','N',300,1,1) BILL_TO_ADDRESS
2188: FROM HZ_CUST_SITE_USES_ALL CS,
2189: HZ_CUST_ACCT_SITES_ALL CA,
2190: HZ_PARTY_SITES PS,
2191: HZ_LOCATIONS L
2192: WHERE CS.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
2193: AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID
2194: AND PS.LOCATION_ID = L.LOCATION_ID