APPS.CN_SEAS_SCHEDULES_PVT dependencies on CN_SRP_ROLE_DTLS

Line 305: select COUNT(*) INTO l_srp_count from cn_srp_role_dtls t1,cn_role_quota_cates t2,cn_srp_roles t3

301: -- Initialize API return status to success
302: x_return_status := FND_API.G_RET_STS_SUCCESS;
303: -- API body
304:
305: select COUNT(*) INTO l_srp_count from cn_srp_role_dtls t1,cn_role_quota_cates t2,cn_srp_roles t3
306: where t1.srp_role_id = t3.srp_role_id
307: and t2.role_id = t3.role_id
308: and t1.status not in ('PENDING')
309: and t2.seas_schedule_id = p_seas_schedules_rec_type.seas_schedule_id;