APPS.OKS_SETUP_UTIL_PUB dependencies on OKS_REV_DISTRIBUTIONS

Line 1148: FROM oks_rev_distributions

1144: CURSOR get_revenue_dist_rule_csr (p_cle_id NUMBER)
1145: IS
1146: SELECT account_class,code_combination_id,percent,object_version_number
1147: security_group_id
1148: FROM oks_rev_distributions
1149: WHERE cle_id = p_cle_id;
1150:
1151: CURSOR rev_exist(cleId number, chrId number) is
1152: SELECT id

Line 1153: FROM oks_rev_distributions

1149: WHERE cle_id = p_cle_id;
1150:
1151: CURSOR rev_exist(cleId number, chrId number) is
1152: SELECT id
1153: FROM oks_rev_distributions
1154: WHERE cle_id = cleId and chr_id = chrId;
1155:
1156: BEGIN
1157: l_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 5250: --delete all OKS_REV_DISTRIBUTIONS records

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);
5253:
5254: --delete all OKS_QUALIFIERS records

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

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);
5253:
5254: --delete all OKS_QUALIFIERS records
5255: FORALL i IN l_id_tbl.first..l_id_tbl.last
5256: DELETE FROM OKS_QUALIFIERS WHERE list_line_id = l_id_tbl(i);