APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_SRP_PAYEE_ASSIGNS

Line 402: FROM cn_srp_payee_assigns spayee,

398: AND cnq.incentive_type_code =
399: decode(nvl(p_incentive_type, cnq.incentive_type_code), 'COMMISSION', 'COMMISSION', 'BONUS', 'BONUS', cnq.incentive_type_code)
400: -- BUG 3140343 Payee design
401: AND cspq.quota_id NOT IN (SELECT spayee.quota_id
402: FROM cn_srp_payee_assigns spayee,
403: cn_period_statuses ps
404: WHERE (spayee.salesrep_id = p_salesrep_id OR spayee.payee_id = p_salesrep_id)
405: AND ps.period_id = p_period_id
406: AND ps.end_date >= spayee.start_date

Line 428: FROM cn_srp_payee_assigns spayee,

424: AND cnq.incentive_type_code =
425: decode(nvl(p_incentive_type, cnq.incentive_type_code), 'COMMISSION', 'COMMISSION', 'BONUS', 'BONUS', cnq.incentive_type_code)
426: -- BUG 3140343 Payee design
427: AND cspq.quota_id NOT IN (SELECT spayee.quota_id
428: FROM cn_srp_payee_assigns spayee,
429: cn_period_statuses ps
430: WHERE (spayee.salesrep_id = p_salesrep_id OR spayee.payee_id = p_salesrep_id)
431: AND ps.period_id = p_period_id
432: AND ps.end_date >= spayee.start_date

Line 527: FROM cn_srp_payee_assigns_all spayee,

523: AND cnq.payment_group_code = nvl(p_payment_group_code, cnq.payment_group_code)
524: AND NOT EXISTS (
525: -- separate queries for performance reasons. merge cartesian reported
526: SELECT 1
527: FROM cn_srp_payee_assigns_all spayee,
528: cn_period_statuses_all ps
529: WHERE (spayee.salesrep_id = p_salesrep_id)
530: AND ps.period_id = cnp.pay_period_id
531: AND ps.end_date >= spayee.start_date

Line 537: FROM cn_srp_payee_assigns_all spayee,

533: AND cnsp.quota_id = spayee.quota_id
534: AND ps.start_date <= nvl(spayee.end_date, ps.end_date)
535: UNION ALL
536: SELECT 1
537: FROM cn_srp_payee_assigns_all spayee,
538: cn_period_statuses_all ps
539: WHERE spayee.payee_id = p_salesrep_id
540: AND ps.period_id = cnp.pay_period_id
541: AND ps.end_date >= spayee.start_date

Line 577: FROM cn_srp_payee_assigns_all spayee,

573: AND cnq.payment_group_code = nvl(p_payment_group_code, cnq.payment_group_code)
574: AND NOT EXISTS (
575: -- separate queries for performance reasons. merge cartesian reported
576: SELECT 1
577: FROM cn_srp_payee_assigns_all spayee,
578: cn_period_statuses_all ps
579: WHERE (spayee.salesrep_id = p_salesrep_id)
580: AND ps.period_id = cnp.pay_period_id
581: AND ps.end_date >= spayee.start_date

Line 587: FROM cn_srp_payee_assigns_all spayee,

583: AND cnsp.quota_id = spayee.quota_id
584: AND ps.start_date <= nvl(spayee.end_date, ps.end_date)
585: UNION ALL
586: SELECT 1
587: FROM cn_srp_payee_assigns_all spayee,
588: cn_period_statuses_all ps
589: WHERE spayee.payee_id = p_salesrep_id
590: AND ps.period_id = cnp.pay_period_id
591: AND ps.end_date >= spayee.start_date

Line 1061: ' AND cspq.quota_id NOT IN ' || ' ( SELECT spayee.quota_id ' || ' FROM cn_srp_payee_assigns spayee' ||

1057: ' AND v.credit_type_id = cq.credit_type_id' || ' AND v.payment_group_code = cq.payment_group_code' ||
1058: ' AND v.salesrep_id = cspq.salesrep_id' || ' AND cspq.quota_id = cq.quota_id' || ' AND cspq.org_id = cq.org_id' ||
1059: ' AND v.period_id = cspq.period_id ' || ' AND cspq.org_id = cq.org_id ' || --R12
1060: ' AND cq.org_id = :p_org_id ' || --R12
1061: ' AND cspq.quota_id NOT IN ' || ' ( SELECT spayee.quota_id ' || ' FROM cn_srp_payee_assigns spayee' ||
1062: ' WHERE (spayee.salesrep_id = v.salesrep_id OR ' || ' spayee.payee_id = v.salesrep_id)' || ' AND v.prd_end_date >= spayee.start_date' ||
1063: ' AND spayee.org_id = :p_org_id' || --R12
1064: ' AND v.prd_start_date <= Nvl(spayee.end_date, v.prd_end_date) )' || ' )';
1065: -- Bug 3140343 : Payee Design. Check if this salesrep is a Payee

Line 1469: cn_srp_payee_assigns_all spayee

1465: CURSOR get_comm_total_payee(p_period_id NUMBER) IS
1466: SELECT /*+ index(cl CN_COMMISSION_LINES_N14) */
1467: nvl(SUM(nvl(commission_amount, 0)), 0)
1468: FROM cn_commission_lines cl,
1469: cn_srp_payee_assigns_all spayee
1470: WHERE cl.srp_payee_assign_id IS NOT NULL
1471: AND cl.srp_payee_assign_id = spayee.srp_payee_assign_id
1472: AND spayee.payee_id = p_worksheet_rec.salesrep_id
1473: AND cl.credited_salesrep_id = spayee.salesrep_id

Line 1997: FROM cn_srp_payee_assigns_all spayee,

1993: AND posting_status <> 'POSTED'
1994: AND org_id = p_worksheet_rec.org_id
1995: AND clk.srp_payee_assign_id IS NOT NULL
1996: AND EXISTS (SELECT 1
1997: FROM cn_srp_payee_assigns_all spayee,
1998: cn_payment_worksheets wksht
1999: WHERE clk.srp_payee_assign_id = spayee.srp_payee_assign_id
2000: AND spayee.quota_id = wksht.quota_id
2001: AND spayee.payee_id = p_worksheet_rec.salesrep_id

Line 2274: FROM cn_srp_payee_assigns cnspa

2270: FROM cn_payment_worksheets_all cnpw
2271: WHERE cnpw.salesrep_id = cnspg.salesrep_id
2272: AND cnp.payrun_id = cnpw.payrun_id)
2273: AND (EXISTS (SELECT 1
2274: FROM cn_srp_payee_assigns cnspa
2275: WHERE ((cnspa.start_date <= cnps.end_date) AND (cnps.start_date <= nvl(cnspa.end_date, cnps.start_date)))
2276: AND cnspa.payee_id = cnspg.salesrep_id
2277: --R12
2278: AND cnspa.org_id = cnp.org_id) OR EXISTS

Line 2977: cn_srp_payee_assigns_all spayee,

2973: wksht_rec.org_id,
2974: 1,
2975: cl.processed_date
2976: FROM cn_commission_lines cl,
2977: cn_srp_payee_assigns_all spayee,
2978: cn_quotas_all pe,
2979: cn_quota_pay_elements_all qp
2980: WHERE cl.srp_payee_assign_id IS NOT NULL
2981: AND cl.srp_payee_assign_id = spayee.srp_payee_assign_id

Line 3304: FROM cn_srp_payee_assigns_all spayee,

3300: AND posting_status <> 'POSTED'
3301: AND org_id = wksht_rec.org_id
3302: AND clk.srp_payee_assign_id IS NOT NULL
3303: AND EXISTS (SELECT 1
3304: FROM cn_srp_payee_assigns_all spayee,
3305: cn_payment_worksheets wksht
3306: WHERE clk.srp_payee_assign_id = spayee.srp_payee_assign_id
3307: AND spayee.quota_id = wksht.quota_id
3308: AND spayee.payee_id = wksht_rec.salesrep_id