APPS.CN_PMT_TRANS_PKG dependencies on CN_QUOTAS_ALL

Line 216: cn_quotas_all q,

212: SELECT DISTINCT q.quota_id,
213: q.incentive_type_code,
214: DECODE (r.payroll_flag, NULL, NULL, 'N', NULL, 'Y', qp.pay_element_type_id, NULL) pay_element_type_id
215: FROM cn_srp_periods srp,
216: cn_quotas_all q,
217: cn_quota_pay_elements_all qp,
218: cn_rs_salesreps s,
219: cn_repositories r
220: WHERE srp.salesrep_id = p_salesrep_id

Line 543: cn_quotas_all pe,

539: cl.org_id,
540: 1,
541: cl.processed_date
542: FROM cn_commission_lines cl,
543: cn_quotas_all pe,
544: cn_quota_pay_elements_all qp,
545: cn_srp_payee_assigns_all spayee
546: WHERE cl.srp_payee_assign_id IS NOT NULL
547: AND cl.srp_payee_assign_id = spayee.srp_payee_assign_id

Line 653: cn_quotas_all pe,

649: cl.org_id,
650: 1,
651: cl.processed_date
652: FROM cn_commission_lines cl,
653: cn_quotas_all pe,
654: cn_quota_pay_elements_all qp
655: WHERE cl.credited_salesrep_id = p_salesrep_id
656: AND cl.processed_period_id <= p_pay_period_id
657: AND cl.status = 'CALC'

Line 755: FROM cn_quotas_all cqa

751: AND payrun_id IS NULL
752: --Added by Julia Huang on 10/1/03 for 'COMMISSON' or 'BONUS' type payrun.
753: AND ptx.quota_id IN (
754: SELECT quota_id
755: FROM cn_quotas_all cqa
756: WHERE cqa.quota_id = ptx.quota_id
757: AND cqa.incentive_type_code =
758: DECODE (NVL (p_incentive_type, cqa.incentive_type_code),
759: 'COMMISSION', 'COMMISSION',