APPS.OKS_SUBSCRIPTION_PVT dependencies on OKS_SUBSCR_ELEMENTS

Line 449: From oks_subscr_elements

445: Where cle_id = p_cle_id;
446:
447: Cursor unitprice_cur Is
448: Select NVL(amount,0)/quantity unitprice, uom_code
449: From oks_subscr_elements
450: Where dnz_cle_id = p_cle_id
451: And rownum < 2;
452:
453: Cursor ptrn_cur Is

Line 461: From oks_subscr_elements

457:
458: Cursor elem_cur Is
459: Select id, start_date, end_date, quantity, uom_code,
460: om_interface_date, order_header_id, object_version_number
461: From oks_subscr_elements
462: Where dnz_cle_id = p_cle_id;
463:
464: Cursor tot_qty_cur Is
465: Select Sum(NVL(quantity,0))

Line 466: From oks_subscr_elements

462: Where dnz_cle_id = p_cle_id;
463:
464: Cursor tot_qty_cur Is
465: Select Sum(NVL(quantity,0))
466: From oks_subscr_elements
467: Where dnz_cle_id = p_cle_id;
468:
469: l_ptrns_tbl_in OKS_SUBSCR_PTRNS_PVT.scpv_tbl_type;
470: l_ptrns_tbl_out OKS_SUBSCR_PTRNS_PVT.scpv_tbl_type;

Line 1403: From oks_subscr_elements

1399:
1400: Procedure delete_ose Is
1401: Cursor scev_cur Is
1402: Select id
1403: From oks_subscr_elements
1404: Where dnz_cle_id = p_cle_id;
1405: l_scev_tbl OKS_SUBSCR_ELEMS_PUB.scev_tbl_type;
1406: i Number := 0;
1407: Begin

Line 1672: From oks_subscr_elements

1668: From oks_subscr_header_b
1669: Where cle_id = p_cle_id;
1670: Cursor subs_qty Is
1671: Select sum(quantity)
1672: From oks_subscr_elements
1673: Where dnz_cle_id = p_cle_id;
1674: Cursor k_line_cur Is
1675: Select start_date, end_date
1676: From okc_k_lines_b

Line 1868: From oks_subscr_elements

1864: From oks_subscr_header_b
1865: Where cle_id = p_cle_id;
1866: Cursor trmn_amt_cur Is
1867: Select sum(amount)
1868: From oks_subscr_elements
1869: Where dnz_cle_id = p_cle_id
1870: And (start_date < p_termn_date Or order_header_id Is Not Null);
1871: CURSOR l_get_hdrid_csr IS
1872: SELECT dnz_chr_id