APPS.ASP_SVCCONTRACT_ALERT_AGENT dependencies on OKC_K_PARTY_ROLES_B

Line 81: ,okc_k_party_roles_b CPL

77: SELECT HZP.party_id customer_id
78: FROM okc_k_headers_all_b CHRB
79: ,oks_k_headers_b KHRB
80: ,okc_subclasses_v SCSV
81: ,okc_k_party_roles_b CPL
82: ,hz_parties HZP
83: WHERE CHRB.id = c_contract_header_id --
84: AND CHRB.id = CPL.dnz_chr_id
85: AND SCSV.code = CHRB.scs_code