DBA Data[Home] [Help]

APPS.OKS_BILL_UTIL_PUB dependencies on OKS_STREAM_LEVELS_B

Line 895: FROM oks_stream_levels_b str

891: le.sequence_number sequence_number,
892: str.uom_code advance_period,
893: str.uom_per_period tuom_per_period,
894: str.start_date tp_start_date
895: FROM oks_stream_levels_b str
896: ,oks_level_elements le
897: WHERE le.cle_id = p_id
898: AND le.rul_id = str.id
899: AND le.date_completed IS NULL

Line 1083: DELETE FROM oks_stream_levels_b

1079: DELETE from OKS_LEVEL_ELEMENTS
1080: where rul_id = p_rul_id ;
1081:
1082: --DELETE SLL
1083: DELETE FROM oks_stream_levels_b
1084: WHERE id = p_rul_id;
1085:
1086: ExceptioN
1087: When Others then

Line 1181: From Oks_stream_levels_b

1177:
1178:
1179: Cursor l_get_line_sll_csr IS
1180: Select id, cle_id , sequence_no
1181: From Oks_stream_levels_b
1182: where id = p_rule_id;
1183:
1184:
1185: /*** This cursor will get the line_id for all sub lines of Top Line for which Rule id was passed, in

Line 1199: From oks_stream_levels_b

1195: /** This cursor gets the rule id for covered products ****/
1196:
1197: Cursor l_get_cp_sll_csr(p_cp_line_id Number, l_seq_no NUMBER) IS
1198: Select id , sequence_no
1199: From oks_stream_levels_b
1200: Where cle_id = p_cp_line_id
1201: And sequence_no = l_seq_no;
1202:
1203: CURSOR l_bill_type_csr(p_line_id NUMBER) IS

Line 1447: DELETE FROM oks_stream_levels_b where cle_id = P_CLE_ID;

1443:
1444: UPDATE oks_k_lines_b SET billing_schedule_type = NULL
1445: WHERE cle_id =p_cle_id;
1446:
1447: DELETE FROM oks_stream_levels_b where cle_id = P_CLE_ID;
1448:
1449: EXCEPTION
1450:
1451: WHEN OTHERS THEN

Line 1670: FROM oks_stream_levels_b

1666: where id = p_cle_id;
1667:
1668: cursor l_sll_csr IS
1669: SELECT *
1670: FROM oks_stream_levels_b
1671: WHERE cle_id = p_cle_id;
1672:
1673: CURSOR l_bill_type_csr IS
1674: SELECT nvl(billing_schedule_type,'T') billing_schedule_type