APPS.OKS_SETUP_UTIL_PUB dependencies on OKS_REV_DISTRIBUTIONS

Line 1140: FROM oks_rev_distributions

1136: CURSOR get_revenue_dist_rule_csr (p_cle_id NUMBER)
1137: IS
1138: SELECT account_class,code_combination_id,percent,object_version_number
1139: security_group_id
1140: FROM oks_rev_distributions
1141: WHERE cle_id = p_cle_id;
1142:
1143: CURSOR rev_exist(cleId number, chrId number) is
1144: SELECT id

Line 1145: FROM oks_rev_distributions

1141: WHERE cle_id = p_cle_id;
1142:
1143: CURSOR rev_exist(cleId number, chrId number) is
1144: SELECT id
1145: FROM oks_rev_distributions
1146: WHERE cle_id = cleId and chr_id = chrId;
1147:
1148: BEGIN
1149: l_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 5241: --delete all OKS_REV_DISTRIBUTIONS records

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);
5244:
5245: --delete all OKS_QUALIFIERS records

Line 5243: DELETE FROM oks_rev_distributions WHERE cle_id = l_id_tbl(i);

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);
5244:
5245: --delete all OKS_QUALIFIERS records
5246: FORALL i IN l_id_tbl.first..l_id_tbl.last
5247: DELETE FROM OKS_QUALIFIERS WHERE list_line_id = l_id_tbl(i);