APPS.CN_CALC_SUBMISSION_PUB dependencies on CN_CALC_SUBMISSION_ENTRIES_ALL

Line 1667: FROM cn_calc_submission_entries_all

1663: CURSOR l_salesrep_exists_csr ( l_calc_sub_batch_id NUMBER,
1664: l_salesrep_id NUMBER )
1665: IS
1666: SELECT COUNT(*)
1667: FROM cn_calc_submission_entries_all
1668: WHERE calc_sub_batch_id = l_calc_sub_batch_id
1669: AND salesrep_id = l_salesrep_id;
1670:
1671: l_counter NUMBER;

Line 2161: DELETE cn_calc_submission_entries_all

2157: END IF;
2158: END LOOP;
2159: ELSIF p_salesrep_tbl_action = 'DELETE' THEN
2160: forall j IN 1 .. l_salesreps_id_tbl.COUNT
2161: DELETE cn_calc_submission_entries_all
2162: WHERE calc_sub_batch_id = l_calc_sub_batch_id
2163: AND salesrep_id = l_salesreps_id_tbl(j);
2164:
2165: DECLARE

Line 2168: FROM cn_calc_submission_entries_all

2164:
2165: DECLARE
2166: CURSOR l_salesrep_count_csr IS
2167: SELECT 1
2168: FROM cn_calc_submission_entries_all
2169: WHERE calc_sub_batch_id = l_calc_sub_batch_id;
2170: dummy NUMBER;
2171: BEGIN
2172: OPEN l_salesrep_count_csr;