APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_K_SALES_CREDITS

Line 1381: FROM oks_k_sales_credits sc, oe_sales_credit_types sct

1377: CURSOR sales_credit_csr (l_line_id NUMBER)
1378: IS
1379: SELECT PERCENT, sc.sales_credit_type_id1, sct.quota_flag,
1380: sc.ctc_id sales_person_id, sc.sales_group_id
1381: FROM oks_k_sales_credits sc, oe_sales_credit_types sct
1382: WHERE sc.sales_credit_type_id1 = sct.sales_credit_type_id
1383: AND sc.cle_id = l_line_id;
1384:
1385: CURSOR target_sales_credit_csr (

Line 1396: FROM oks_k_sales_credits sc, oe_sales_credit_types sct

1392: )
1393: IS
1394: SELECT PERCENT, sc.sales_credit_type_id1, sct.quota_flag,
1395: sc.ctc_id sales_person_id, sc.sales_group_id
1396: FROM oks_k_sales_credits sc, oe_sales_credit_types sct
1397: WHERE sc.sales_credit_type_id1 = sct.sales_credit_type_id
1398: AND sc.cle_id = l_line_id
1399: AND PERCENT = l_percent
1400: AND sc.sales_credit_type_id1 = l_sales_credit_type_id1

Line 1408: FROM oks_k_sales_credits

1404:
1405: CURSOR sales_credit_count_csr (l_line_id NUMBER)
1406: IS
1407: SELECT COUNT (*)
1408: FROM oks_k_sales_credits
1409: WHERE cle_id = l_line_id;
1410:
1411: l_source_rec source_line%ROWTYPE;
1412: l_target_rentype target_line%ROWTYPE;

Line 9856: FROM oks_k_sales_credits_v

9852:
9853: CURSOR l_sales_credit_hdr_csr (p_chr_id NUMBER)
9854: IS
9855: SELECT ctc_id, sales_credit_type_id1, PERCENT, sales_group_id
9856: FROM oks_k_sales_credits_v
9857: WHERE chr_id = p_chr_id AND cle_id IS NULL;
9858: BEGIN
9859: x_return_status := okc_api.g_ret_sts_success;
9860:

Line 10329: FROM oks_k_sales_credits_v

10325:
10326: CURSOR l_sales_credit_csr (p_cle_id NUMBER)
10327: IS
10328: SELECT ctc_id, sales_credit_type_id1, PERCENT, sales_group_id
10329: FROM oks_k_sales_credits_v
10330: WHERE cle_id = p_cle_id;
10331:
10332: l_sc_ctr NUMBER;
10333: l_salescredit_tbl oks_extwarprgm_pvt.salescredit_tbl;