DBA Data[Home] [Help]

APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on OKC_CONTACTS

Line 822: okc_contacts ct,

818:
819: CURSOR csr_k_salesrep IS
820: SELECT res.resource_name AS salesrep_name
821: FROM okc_k_headers_all_b khr,
822: okc_contacts ct,
823: jtf_rs_salesreps srp,
824: jtf_rs_resource_extns_vl res
825: WHERE khr.ID = ct.dnz_chr_id
826: AND ct.object1_id1 = srp.salesrep_id

Line 3599: okc_contacts ct,

3595: CURSOR csr_k_salesrep IS
3596: SELECT srp.email_address AS email_address,
3597: res.user_name AS username
3598: FROM okc_k_headers_all_b khr,
3599: okc_contacts ct,
3600: jtf_rs_salesreps srp,
3601: jtf_rs_resource_extns res
3602: WHERE khr.ID = ct.dnz_chr_id
3603: AND ct.object1_id1 = srp.salesrep_id