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 529: FROM cn_srp_payee_assigns_all spayee,

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

Line 539: FROM cn_srp_payee_assigns_all spayee,

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

Line 579: FROM cn_srp_payee_assigns_all spayee,

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

Line 589: FROM cn_srp_payee_assigns_all spayee,

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

Line 1471: cn_srp_payee_assigns_all spayee

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

Line 1999: FROM cn_srp_payee_assigns_all spayee,

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

Line 3023: cn_srp_payee_assigns_all spayee,

3019: wksht_rec.org_id,
3020: 1,
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

Line 3350: FROM cn_srp_payee_assigns_all spayee,

3346: AND posting_status <> 'POSTED'
3347: AND org_id = wksht_rec.org_id
3348: AND clk.srp_payee_assign_id IS NOT NULL
3349: AND EXISTS (SELECT 1
3350: FROM cn_srp_payee_assigns_all spayee,
3351: cn_payment_worksheets wksht
3352: WHERE clk.srp_payee_assign_id = spayee.srp_payee_assign_id
3353: AND spayee.quota_id = wksht.quota_id
3354: AND spayee.payee_id = wksht_rec.salesrep_id