APPS.OKS_OC_INT_KTO_PVT dependencies on OKS_SUBSCR_ELEMENTS

Line 1375: from oks_subscr_elements sub ,

1371: sub.dnz_cle_id,
1372: sub.start_date,
1373: sub.end_date,
1374: sub.om_interface_date
1375: from oks_subscr_elements sub ,
1376: okc_k_lines_b line,
1377: okc_statuses_b sts
1378: where sub.dnz_chr_id = nvl(p_contract_id ,sub.dnz_chr_id)
1379: and sub.dnz_chr_id between nvl(nvl(p_contract_id,p_contract_hdr_id_lo),sub.dnz_chr_id)

Line 1400: from oks_subscr_elements sub,

1396: sub.start_date,
1397: sub.end_date,
1398: sub.om_interface_date,
1399: hdr.contract_number
1400: from oks_subscr_elements sub,
1401: okc_k_headers_b hdr,
1402: okc_k_party_roles_b pr,
1403: okc_statuses_b st
1404: where sub.dnz_chr_id = nvl(p_contract_id ,sub.dnz_chr_id)

Line 1705: update oks_subscr_elements

1701:
1702: IF lx_order_line_tbl.first IS NOT NULL THEN
1703: FOR i IN lx_order_line_tbl.first..lx_order_line_tbl.last LOOP
1704:
1705: update oks_subscr_elements
1706: set order_header_id = lx_order_line_tbl(i).order_header_id
1707: ,order_line_id = lx_order_line_tbl(i).order_line_id
1708: where id= get_elements_rec.id;
1709: