DBA Data[Home] [Help]

APPS.OKS_BILL_UTIL_PUB dependencies on OKS_STREAM_LEVELS_B

Line 929: FROM oks_stream_levels_b str

925: le.sequence_number sequence_number,
926: str.uom_code advance_period,
927: str.uom_per_period tuom_per_period,
928: str.start_date tp_start_date
929: FROM oks_stream_levels_b str
930: ,oks_level_elements le
931: WHERE le.cle_id = p_id
932: AND le.rul_id = str.id
933: AND le.date_completed IS NULL

Line 1117: DELETE FROM oks_stream_levels_b

1113: DELETE from OKS_LEVEL_ELEMENTS
1114: where rul_id = p_rul_id ;
1115:
1116: --DELETE SLL
1117: DELETE FROM oks_stream_levels_b
1118: WHERE id = p_rul_id;
1119:
1120: ExceptioN
1121: When Others then

Line 1215: From Oks_stream_levels_b

1211:
1212:
1213: Cursor l_get_line_sll_csr IS
1214: Select id, cle_id , sequence_no
1215: From Oks_stream_levels_b
1216: where id = p_rule_id;
1217:
1218:
1219: /*** This cursor will get the line_id for all sub lines of Top Line for which Rule id was passed, in

Line 1233: From oks_stream_levels_b

1229: /** This cursor gets the rule id for covered products ****/
1230:
1231: Cursor l_get_cp_sll_csr(p_cp_line_id Number, l_seq_no NUMBER) IS
1232: Select id , sequence_no
1233: From oks_stream_levels_b
1234: Where cle_id = p_cp_line_id
1235: And sequence_no = l_seq_no;
1236:
1237: CURSOR l_bill_type_csr(p_line_id NUMBER) IS

Line 1481: DELETE FROM oks_stream_levels_b where cle_id = P_CLE_ID;

1477:
1478: UPDATE oks_k_lines_b SET billing_schedule_type = NULL
1479: WHERE cle_id =p_cle_id;
1480:
1481: DELETE FROM oks_stream_levels_b where cle_id = P_CLE_ID;
1482:
1483: EXCEPTION
1484:
1485: WHEN OTHERS THEN

Line 1704: FROM oks_stream_levels_b

1700: where id = p_cle_id;
1701:
1702: cursor l_sll_csr IS
1703: SELECT *
1704: FROM oks_stream_levels_b
1705: WHERE cle_id = p_cle_id;
1706:
1707: CURSOR l_bill_type_csr IS
1708: SELECT nvl(billing_schedule_type,'T') billing_schedule_type