APPS.OKL_JTOT_CONTACT_EXTRACT_PVT dependencies on OKX_ORGANIZATION_DEFS_V
Line 58: FROM okx_organization_defs_v ord
54: SELECT ord.id1,
55: ord.id2,
56: ord.name,
57: ord.description 58: FROM okx_organization_defs_v ord 59: WHERE ord.organization_type = 'OPERATING_UNIT'
60: AND ord.information_type = 'Operating Unit Information'
61: AND ord.name = NVL(p_name,ord.name)
62: AND ord.id1 = NVL(p_id1,ord.id1)