eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_SRP_PAYEE_ASSIGNS_ALL

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