APPS.OKS_IBINT_PUB dependencies on OKC_K_HEADERS_V

Line 405: From OKC_K_REL_OBJS RO, OkC_K_HEADERS_V OH

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

Line 415: From OKC_K_HEADERS_V

411:
412:
413: Cursor l_hdr_scs_csr(p_chr_id Number) Is
414: Select scs_code
415: From OKC_K_HEADERS_V
416: Where id = p_chr_id;
417:
418: Cursor l_rel_csr(p_ordlineid Number, p_serv_ordline_id Number,p_item_id Number) Is
419: Select rel.cle_id