APPS.OKS_SETUP_UTIL_PUB dependencies on OKS_K_SALES_CREDITS

Line 1255: FROM oks_k_sales_credits

1251: ctc_id,
1252: sales_group_id,
1253: sales_credit_type_id1,
1254: sales_credit_type_id2
1255: FROM oks_k_sales_credits
1256: WHERE chr_id = p_chr_id
1257: AND cle_id IS NULL;
1258:
1259: BEGIN

Line 1353: FROM oks_k_sales_credits

1349: ctc_id,
1350: sales_group_id,
1351: sales_credit_type_id1,
1352: sales_credit_type_id2
1353: FROM oks_k_sales_credits
1354: WHERE cle_id = p_cle_id;
1355:
1356: -- Added for dup sales credit bug
1357: l_exist number;

Line 1361: FROM oks_k_sales_credits

1357: l_exist number;
1358:
1359: CURSOR sales_credit_exist_csr (p_new_cle_id NUMBER) IS
1360: SELECT percent
1361: FROM oks_k_sales_credits
1362: WHERE cle_id = p_new_cle_id;
1363: -------
1364:
1365: BEGIN

Line 5237: --delete all OKS_K_SALES_CREDITS records

5233: --delete all OKS_K_LINES_B records
5234: FORALL i IN l_id_tbl.first..l_id_tbl.last
5235: DELETE FROM oks_k_lines_b WHERE cle_id = l_id_tbl(i);
5236:
5237: --delete all OKS_K_SALES_CREDITS records
5238: FORALL i IN l_id_tbl.first..l_id_tbl.last
5239: DELETE FROM oks_k_sales_credits WHERE cle_id = l_id_tbl(i);
5240:
5241: --delete all OKS_REV_DISTRIBUTIONS records

Line 5239: DELETE FROM oks_k_sales_credits WHERE cle_id = l_id_tbl(i);

5235: DELETE FROM oks_k_lines_b WHERE cle_id = l_id_tbl(i);
5236:
5237: --delete all OKS_K_SALES_CREDITS records
5238: FORALL i IN l_id_tbl.first..l_id_tbl.last
5239: DELETE FROM oks_k_sales_credits WHERE cle_id = l_id_tbl(i);
5240:
5241: --delete all OKS_REV_DISTRIBUTIONS records
5242: FORALL i IN l_id_tbl.first..l_id_tbl.last
5243: DELETE FROM oks_rev_distributions WHERE cle_id = l_id_tbl(i);