APPS.OKS_SETUP_UTIL_PUB dependencies on OKS_K_SALES_CREDITS

Line 1263: FROM oks_k_sales_credits

1259: ctc_id,
1260: sales_group_id,
1261: sales_credit_type_id1,
1262: sales_credit_type_id2
1263: FROM oks_k_sales_credits
1264: WHERE chr_id = p_chr_id
1265: AND cle_id IS NULL;
1266:
1267: BEGIN

Line 1361: FROM oks_k_sales_credits

1357: ctc_id,
1358: sales_group_id,
1359: sales_credit_type_id1,
1360: sales_credit_type_id2
1361: FROM oks_k_sales_credits
1362: WHERE cle_id = p_cle_id;
1363:
1364: -- Added for dup sales credit bug
1365: l_exist number;

Line 1369: FROM oks_k_sales_credits

1365: l_exist number;
1366:
1367: CURSOR sales_credit_exist_csr (p_new_cle_id NUMBER) IS
1368: SELECT percent
1369: FROM oks_k_sales_credits
1370: WHERE cle_id = p_new_cle_id;
1371: -------
1372:
1373: BEGIN

Line 5246: --delete all OKS_K_SALES_CREDITS records

5242: --delete all OKS_K_LINES_B records
5243: FORALL i IN l_id_tbl.first..l_id_tbl.last
5244: DELETE FROM oks_k_lines_b WHERE cle_id = l_id_tbl(i);
5245:
5246: --delete all OKS_K_SALES_CREDITS records
5247: FORALL i IN l_id_tbl.first..l_id_tbl.last
5248: DELETE FROM oks_k_sales_credits WHERE cle_id = l_id_tbl(i);
5249:
5250: --delete all OKS_REV_DISTRIBUTIONS records

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

5244: DELETE FROM oks_k_lines_b WHERE cle_id = l_id_tbl(i);
5245:
5246: --delete all OKS_K_SALES_CREDITS records
5247: FORALL i IN l_id_tbl.first..l_id_tbl.last
5248: DELETE FROM oks_k_sales_credits WHERE cle_id = l_id_tbl(i);
5249:
5250: --delete all OKS_REV_DISTRIBUTIONS records
5251: FORALL i IN l_id_tbl.first..l_id_tbl.last
5252: DELETE FROM oks_rev_distributions WHERE cle_id = l_id_tbl(i);