APPS.OKS_BILL_MIGRATION dependencies on OKS_BILL_SUB_LINES

Line 742: FROM oks_bill_sub_lines

738: --Bill sub lines
739: CURSOR bill_sub_csr (p_cle_id NUMBER) IS
740: SELECT cle_id,
741: amount
742: FROM oks_bill_sub_lines
743: WHERE cle_id = p_cle_id;
744:
745:
746:

Line 1035: FROM oks_bill_sub_lines

1031: l_bill_count := 0;
1032:
1033: SELECT COUNT(cle_id)
1034: INTO l_bill_count
1035: FROM oks_bill_sub_lines
1036: WHERE cle_id = line_grp_rec.id;
1037:
1038:
1039: IF l_bill_count > 0 THEN

Line 1507: FROM oks_bill_sub_lines

1503: --Bill sub lines
1504: CURSOR bill_sub_csr (p_cle_id NUMBER) IS
1505: SELECT cle_id,
1506: amount
1507: FROM oks_bill_sub_lines
1508: WHERE cle_id = p_cle_id;
1509:
1510: l_lvl_element_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;
1511: l_lvl_element_tbl_out oks_bill_level_elements_pvt.letv_tbl_type;

Line 1933: FROM oks_bill_sub_lines

1929: l_bill_count := 0;
1930:
1931: SELECT COUNT(ID)
1932: INTO l_bill_count
1933: FROM oks_bill_sub_lines
1934: WHERE cle_id = line_grp_rec.id;
1935:
1936:
1937: IF l_bill_count > 0 THEN

Line 2199: insert into oks_bill_sub_lines

2195:
2196: L_LINE_AMOUNT :=L_LINE_AMOUNT + NVL( L_SUB_LINES_REC.PRICE_NEGOTIATED , 0 ) ;
2197: lin_id := get_seq_id;
2198:
2199: insert into oks_bill_sub_lines
2200: (id, cle_id, bcl_id, date_billed_from, date_billed_to, amount, object_version_number,
2201: created_by, creation_date, last_updated_by, last_update_date)
2202: values
2203: (lin_id, L_SUB_LINES_REC.ID, bcl_id_sub, L_sub_LINES_REC.START_DATE, L_sub_LINES_REC.END_DATE,