APPS.OKE_DTS_WSH_PKG dependencies on OKC_K_PARTY_ROLES_B

Line 31: FROM okc_k_party_roles_b R, oke_cust_site_uses_v C

27: AND D.Deliverable_ID = P_Deliverable_ID;
28:
29: CURSOR C1 ( P_ID NUMBER, p_header_id number ) IS
30: SELECT C.Location_ID
31: FROM okc_k_party_roles_b R, oke_cust_site_uses_v C
32: WHERE R.dnz_chr_id = P_header_ID
33: AND R.Cle_ID = P_ID
34: AND R.JTOT_Object1_Code = 'OKE_BILLTO'
35: AND R.Object1_ID1 = C.ID1;

Line 45: FROM okc_k_party_roles_b R, oke_cust_site_uses_v C

41: ORDER BY Level_Sequence desc;
42:
43: CURSOR C3 ( P_ID NUMBER ) IS
44: SELECT C.Location_ID
45: FROM okc_k_party_roles_b R, oke_cust_site_uses_v C
46: WHERE R.dnz_Chr_ID = P_ID
47: AND R.Chr_ID = P_ID
48: AND R.JTOT_Object1_Code = 'OKE_BILLTO'
49: AND R.Object1_ID1 = C.ID1;