APPS.OKS_AUTO_REMINDER dependencies on OKC_K_PARTY_ROLES_B

Line 111: FROM okc_k_party_roles_b r,

107: IS
108: CURSOR csr_party_dtls
109: IS
110: SELECT r.object1_id1 AS party_id
111: FROM okc_k_party_roles_b r,
112: hz_parties p
113: WHERE p.party_id = r.object1_id1
114: AND r.jtot_object1_code = 'OKX_PARTY'
115: AND r.rle_code IN

Line 123: FROM okc_k_party_roles_b okpr,

119: AND r.chr_id = p_chr_id;
120: /*
121: CURSOR l_CustPartyId_csr IS
122: SELECT distinct hp.party_id
123: FROM okc_k_party_roles_b okpr,
124: hz_parties hp,
125: --NPALEPU
126: --08-AUG-2005
127: --TCA Project