APPS.OKS_OCINT_PUB dependencies on OKS_LEVEL_ELEMENTS

Line 59: FROM oks_stream_levels_v sll, oks_level_elements lvl

55: IS
56: CURSOR l_billsll_csr (p_cle_id IN NUMBER)
57: IS
58: SELECT 'x'
59: FROM oks_stream_levels_v sll, oks_level_elements lvl
60: WHERE lvl.rul_id = sll.ID AND sll.cle_id = p_cle_id;
61:
62: v_flag BOOLEAN := FALSE;
63: v_temp VARCHAR2 (5);

Line 2766: SELECT date_end INTO l_date_end FROM oks_level_elements WHERE cle_id=l_lineid and date_start =l_k_line_rec.srv_sdt;

2762:
2763: /* Modified for CLOUD ER*/
2764: IF l_bill_option ='FPOM' AND l_bill_profile_id IS NOT NULL THEN
2765:
2766: SELECT date_end INTO l_date_end FROM oks_level_elements WHERE cle_id=l_lineid and date_start =l_k_line_rec.srv_sdt;
2767:
2768: oks_bill_util_pub.create_bcl_for_om_oks_billing
2769: (p_line_id => l_lineid,
2770: p_date_to => l_date_end,