331: FROM cn_commission_lines_all cl,
332: -- cn_srp_plan_assigns srcp,
333: --cn_srp_payee_assigns srpa, removed for payee assigns bug #2495614
334: -- cn_role_plans rcp,
335: cn_quotas_all pe
336: WHERE cl.commission_line_id = p_commission_line_id
337: AND cl.quota_id = pe.quota_id
338: AND cl.srp_payee_assign_id IS NULL)
339: UNION --this is added for assign payees for fixing bug#2495614
391: FROM cn_commission_lines_all cl,
392: -- cn_srp_plan_assigns srcp,
393: cn_srp_payee_assigns_all payee,
394: -- cn_role_plans rcp,
395: cn_quotas_all pe
396: WHERE cl.commission_line_id = p_commission_line_id
397: AND cl.quota_id = pe.quota_id
398: AND cl.srp_payee_assign_id IS NOT NULL
399: AND payee.srp_payee_assign_id = cl.srp_payee_assign_id);