APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_QUOTA_PAY_ELEMENTS_ALL

Line 2660: cn_quota_pay_elements_all qp,

2656: srp.quota_id,
2657: decode(r.payroll_flag, NULL, NULL, 'N', NULL, 'Y', qp.pay_element_type_id, NULL) pay_element_type_id
2658: FROM cn_srp_periods srp,
2659: cn_quotas_all q,
2660: cn_quota_pay_elements_all qp,
2661: cn_rs_salesreps s,
2662: cn_repositories r
2663: -- 01/03/03 gasriniv added hold flag check for bug 2710066
2664: WHERE srp.salesrep_id = wksht_rec.salesrep_id

Line 2767: cn_quota_pay_elements_all qp,

2763: SYSDATE,
2764: --R12
2765: wksht_rec.org_id
2766: FROM cn_srp_periods srp,
2767: cn_quota_pay_elements_all qp,
2768: cn_rs_salesreps s,
2769: cn_repositories r
2770: WHERE srp.salesrep_id = wksht_rec.salesrep_id
2771: AND srp.period_id = wksht_rec.pay_period_id

Line 3025: cn_quota_pay_elements_all qp

3021: cl.processed_date
3022: FROM cn_commission_lines cl,
3023: cn_srp_payee_assigns_all spayee,
3024: cn_quotas_all pe,
3025: cn_quota_pay_elements_all qp
3026: WHERE cl.srp_payee_assign_id IS NOT NULL
3027: AND cl.srp_payee_assign_id = spayee.srp_payee_assign_id
3028: AND spayee.payee_id = wksht_rec.salesrep_id
3029: AND cl.credited_salesrep_id = spayee.salesrep_id