APPS.OKS_IBINT_PUB dependencies on OKC_K_HEADERS_V

Line 409: From OKC_K_REL_OBJS RO, OkC_K_HEADERS_V OH

405: -- cursor to get chr_id of existing warranty contract for an order. vigandhi
406:
407: Cursor get_chr_id_csr(p_object_id NUmber) IS
408: Select Chr_id
409: From OKC_K_REL_OBJS RO, OkC_K_HEADERS_V OH
410: Where RO.OBJECT1_ID1 = to_char(P_Object_id)
411: And RO.jtot_object1_code = 'OKX_ORDERHEAD'
412: And RO.rty_code = 'CONTRACTWARRANTYORDER'
413: And RO.chr_id = OH.id

Line 419: From OKC_K_HEADERS_V

415:
416:
417: Cursor l_hdr_scs_csr(p_chr_id Number) Is
418: Select scs_code
419: From OKC_K_HEADERS_V
420: Where id = p_chr_id;
421:
422: Cursor l_rel_csr(p_ordlineid Number, p_serv_ordline_id Number,p_item_id Number) Is
423: Select rel.cle_id