[Home] [Help]
144: --check whether the payee start date and end date
145: --fall between the start and end date of plan element
146: SELECT count(1)
147: INTO l_count
148: FROM cn_quotas_all
149: WHERE quota_id = p_quota_id
150: AND p_start_date >= start_date
151: AND Nvl(p_end_date, l_end_of_time) <=
152: Nvl(end_date, l_end_of_time);
226: x_loading_status IN OUT NOCOPY VARCHAR2
227: ) IS
228:
229: l_api_name CONSTANT VARCHAR2(30) := 'Valid_Srp_Payee_Assigns';
230: l_payee_assign_flag cn_quotas.payee_assign_flag%TYPE;
231: l_count NUMBER;
232: l_daycount NUMBER;
233: l_sd DATE;
234: l_ed DATE;
236: l_end_date DATE := nvl(p_end_date, l_end_of_time);
237: l_srp_name cn_salesreps.name%TYPE;
238: l_payee_name cn_salesreps.name%TYPE;
239: l_emp_num cn_salesreps.employee_number%TYPE;
240: l_pe_name cn_quotas.name%TYPE;
241: l_quota_id NUMBER;
242:
243: CURSOR get_pgs is
244: SELECT start_date, nvl(end_date,l_end_of_time) end_date
317:
318: -- Check wheather the payee can be assigned to this plan Element
319: SELECT payee_assign_flag, q.name, q.quota_id
320: INTO l_payee_assign_flag, l_pe_name, l_quota_id
321: FROM cn_quotas_all q, cn_srp_quota_assigns_all sqa
322: WHERE sqa.srp_quota_assign_id = p_srp_quota_assign_id
323: AND q.quota_id = sqa.quota_id;
324:
325: IF Nvl(l_payee_assign_flag,'N') <> 'Y' THEN