DBA Data[Home] [Help]

APPS.OKI_DBI_LOAD_CLEB_PVT dependencies on OKC_CONTACTS

Line 993: FROM okc_contacts srep

989: ELSE NVL(srep.end_date,sysdate) -
990: g_0001_date
991: END)
992: END ASC , srep.last_update_date DESC, srep.id ASC) sales_group_id
993: FROM okc_contacts srep
994: , okc_k_headers_all_b h
995: WHERE 1 = 1
996: AND h.id = srep.dnz_chr_id
997: AND srep.cro_code = l_salesperson_code

Line 1468: FROM okc_contacts srep

1464: ELSE NVL(srep.end_date,l_sysdate) -
1465: g_0001_date
1466: END)
1467: END ASC , srep.last_update_date DESC , srep.id ASC),-1)
1468: FROM okc_contacts srep
1469: WHERE 1 = 1
1470: AND srep.cro_code = l_salesperson_code
1471: AND NVL (srep.primary_yn, 'Y') = 'Y'
1472: AND h.id = srep.dnz_chr_id