APPS.CN_SRP_PAYEE_ASSIGNS_PVT dependencies on CN_QUOTAS_ALL

Line 148: FROM cn_quotas_all

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);

Line 321: FROM cn_quotas_all q, cn_srp_quota_assigns_all sqa

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