APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_K_SALES_CREDITS

Line 1341: FROM oks_k_sales_credits sc, oe_sales_credit_types sct

1337: CURSOR sales_credit_csr (l_line_id NUMBER)
1338: IS
1339: SELECT PERCENT, sc.sales_credit_type_id1, sct.quota_flag,
1340: sc.ctc_id sales_person_id, sc.sales_group_id
1341: FROM oks_k_sales_credits sc, oe_sales_credit_types sct
1342: WHERE sc.sales_credit_type_id1 = sct.sales_credit_type_id
1343: AND sc.cle_id = l_line_id;
1344:
1345: CURSOR target_sales_credit_csr (

Line 1356: FROM oks_k_sales_credits sc, oe_sales_credit_types sct

1352: )
1353: IS
1354: SELECT PERCENT, sc.sales_credit_type_id1, sct.quota_flag,
1355: sc.ctc_id sales_person_id, sc.sales_group_id
1356: FROM oks_k_sales_credits sc, oe_sales_credit_types sct
1357: WHERE sc.sales_credit_type_id1 = sct.sales_credit_type_id
1358: AND sc.cle_id = l_line_id
1359: AND PERCENT = l_percent
1360: AND sc.sales_credit_type_id1 = l_sales_credit_type_id1

Line 1368: FROM oks_k_sales_credits

1364:
1365: CURSOR sales_credit_count_csr (l_line_id NUMBER)
1366: IS
1367: SELECT COUNT (*)
1368: FROM oks_k_sales_credits
1369: WHERE cle_id = l_line_id;
1370:
1371: l_source_rec source_line%ROWTYPE;
1372: l_target_rentype target_line%ROWTYPE;

Line 9612: FROM oks_k_sales_credits_v

9608:
9609: CURSOR l_sales_credit_hdr_csr (p_chr_id NUMBER)
9610: IS
9611: SELECT ctc_id, sales_credit_type_id1, PERCENT, sales_group_id
9612: FROM oks_k_sales_credits_v
9613: WHERE chr_id = p_chr_id AND cle_id IS NULL;
9614: BEGIN
9615: x_return_status := okc_api.g_ret_sts_success;
9616:

Line 10081: FROM oks_k_sales_credits_v

10077:
10078: CURSOR l_sales_credit_csr (p_cle_id NUMBER)
10079: IS
10080: SELECT ctc_id, sales_credit_type_id1, PERCENT, sales_group_id
10081: FROM oks_k_sales_credits_v
10082: WHERE cle_id = p_cle_id;
10083:
10084: l_sc_ctr NUMBER;
10085: l_salescredit_tbl oks_extwarprgm_pvt.salescredit_tbl;