DBA Data[Home] [Help]

APPS.CN_PREPOST_PVT dependencies on CN_QUOTAS_ALL

Line 335: cn_quotas_all pe

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

Line 395: cn_quotas_all pe

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