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_QUOTAS_ALL

Line 69: cn_quotas_all quota,

65: END) comm_ptd
66: INTO l_bonus_ptd,
67: l_comm_ptd
68: FROM cn_srp_period_quotas_all cspq,
69: cn_quotas_all quota,
70: cn_payruns_all pr
71: WHERE cspq.quota_id = quota.quota_id
72: AND quota.quota_id > 0
73: AND quota.org_id = cspq.org_id

Line 252: FROM cn_quotas_all q

248: WHERE ptrx.payrun_id = p_payrun_id
249: AND ptrx.credited_salesrep_id = p_salesrep_id
250: AND ptrx.incentive_type_code IN ('PMTPLN_REC', 'COMMISSION', 'BONUS')
251: AND EXISTS (SELECT 1
252: FROM cn_quotas_all q
253: WHERE q.quota_id = ptrx.quota_id
254: AND q.payment_group_code = p_payment_group_code);
255: ELSE
256: UPDATE cn_payment_transactions ptrx

Line 265: FROM cn_quotas_all q

261: WHERE ptrx.payrun_id = p_payrun_id
262: AND ptrx.credited_salesrep_id = p_salesrep_id
263: AND ptrx.incentive_type_code IN ('PMTPLN_REC', decode(p_incentive_type, 'COMMISSION', 'COMMISSION', 'BONUS', 'BONUS'))
264: AND EXISTS (SELECT 1
265: FROM cn_quotas_all q
266: WHERE q.quota_id = ptrx.quota_id
267: AND q.payment_group_code = p_payment_group_code);
268: END IF;
269: END reset_payrun_id;

Line 390: cn_quotas_all cnq

386: ) IS
387: CURSOR get_pe_pg_count(p_payment_group_code VARCHAR2) IS
388: SELECT COUNT(DISTINCT cnq.quota_id) num_pe
389: FROM cn_srp_period_quotas cspq,
390: cn_quotas_all cnq
391: WHERE cnq.payment_group_code = p_payment_group_code
392: AND cspq.quota_id = cnq.quota_id
393: AND cnq.credit_type_id = -1000
394: AND cspq.salesrep_id = p_salesrep_id

Line 416: cn_quotas_all cnq

412: AND ps.start_date <= nvl(spayee.end_date, ps.end_date));
413: CURSOR get_pe_pg(p_payment_group_code VARCHAR2) IS
414: SELECT DISTINCT cnq.quota_id quota_id
415: FROM cn_srp_period_quotas cspq,
416: cn_quotas_all cnq
417: WHERE cnq.payment_group_code = p_payment_group_code
418: AND cspq.quota_id = cnq.quota_id
419: AND cnq.credit_type_id = -1000
420: AND cspq.salesrep_id = p_salesrep_id

Line 499: --Added cn_quotas_all for bug 3175375 by jjhuang.

495: -- to take care srp with no transaction but want to apply pmt plan
496: -- Bug 3140343 : Payee Design.
497: -- Bug 3198445 by jjhuang: Added payment_group_code for cursor get_srp_pe
498: CURSOR get_srp_pe IS
499: --Added cn_quotas_all for bug 3175375 by jjhuang.
500: SELECT DISTINCT v.quota_id,
501: v.payment_group_code
502: FROM (SELECT cnpt.quota_id,
503: cq.payment_group_code

Line 505: cn_quotas_all cq

501: v.payment_group_code
502: FROM (SELECT cnpt.quota_id,
503: cq.payment_group_code
504: FROM cn_payment_transactions cnpt,
505: cn_quotas_all cq
506: WHERE cnpt.credit_type_id = g_credit_type_id
507: AND cnpt.credited_salesrep_id = p_salesrep_id
508: AND cnpt.payrun_id = p_payrun_id
509: AND ((cnpt.incentive_type_code NOT IN ('COMMISSION', 'BONUS')) OR

Line 517: cn_quotas_all cnq,

513: UNION ALL
514: SELECT cnsp.quota_id,
515: cnq.payment_group_code
516: FROM cn_srp_period_quotas cnsp,
517: cn_quotas_all cnq,
518: cn_payruns cnp
519: WHERE cnsp.salesrep_id = p_salesrep_id
520: AND cnq.credit_type_id = g_credit_type_id
521: AND cnq.incentive_type_code = nvl(p_incentive_type, cnq.incentive_type_code)

Line 549: --Added cn_quotas_all for bug 3175375 by jjhuang.

545: AND cnsp.quota_id = spayee.quota_id
546: AND ps.start_date <= nvl(spayee.end_date, ps.end_date))) v;
547:
548: -- Bug 3198445 by jjhuang: get distinct payment group code count.
549: --Added cn_quotas_all for bug 3175375 by jjhuang.
550: CURSOR get_pgc_count IS
551: SELECT COUNT(DISTINCT v.payment_group_code) pgc_count
552: FROM (SELECT cnpt.quota_id,
553: cq.payment_group_code

Line 555: cn_quotas_all cq

551: SELECT COUNT(DISTINCT v.payment_group_code) pgc_count
552: FROM (SELECT cnpt.quota_id,
553: cq.payment_group_code
554: FROM cn_payment_transactions cnpt,
555: cn_quotas_all cq
556: WHERE cnpt.credit_type_id = g_credit_type_id
557: AND cnpt.credited_salesrep_id = p_salesrep_id
558: AND cnpt.payrun_id = p_payrun_id
559: AND ((cnpt.incentive_type_code NOT IN ('COMMISSION', 'BONUS')) OR

Line 567: cn_quotas_all cnq,

563: UNION ALL
564: SELECT cnsp.quota_id,
565: cnq.payment_group_code
566: FROM cn_srp_period_quotas cnsp,
567: cn_quotas_all cnq,
568: cn_payruns cnp
569: WHERE cnsp.salesrep_id = p_salesrep_id
570: AND cnq.credit_type_id = g_credit_type_id
571: AND cnq.incentive_type_code = nvl(p_incentive_type, cnq.incentive_type_code)

Line 598: -- remove join to cn_quotas_all since can get quota_id from cnpt

594: AND ps.org_id = p_org_id
595: AND cnsp.quota_id = spayee.quota_id
596: AND ps.start_date <= nvl(spayee.end_date, ps.end_date))) v;
597:
598: -- remove join to cn_quotas_all since can get quota_id from cnpt
599: -- 03/24/03 -9999 is used in cnupsp2.sql, change to -9990
600: CURSOR get_earnings_total_by_pe(p_quota_id NUMBER) IS
601: -- earnings to populate pmt_amount_calc
602: SELECT nvl(SUM(nvl(cnpt.amount, 0)), 0) pmt_amount_calc,

Line 905: cn_quotas_all cnq

901: ) IS
902: CURSOR get_earnings_total(p_payment_group_code VARCHAR2) IS
903: SELECT SUM(cnpt.payment_amount) payment_amount
904: FROM cn_payment_transactions cnpt,
905: cn_quotas_all cnq
906: WHERE cnpt.credited_salesrep_id = p_salesrep_id
907: AND cnpt.payrun_id = p_payrun_id
908: AND cnpt.quota_id = cnq.quota_id
909: AND nvl(hold_flag, 'N') = 'N'

Line 976: cn_quotas_all q,

972: -- get the amount paid at the payment group code level
973: CURSOR get_itd_amount_paid(p_period_set_id NUMBER, p_period_type_id NUMBER, p_interval_sdate DATE, p_interval_edate DATE, p_pg_code cn_pmt_plans.payment_group_code%TYPE) IS
974: SELECT nvl(SUM(balance1_dtd - balance1_ctd), 0) payment
975: FROM cn_srp_periods csp,
976: cn_quotas_all q,
977: cn_period_statuses ps
978: WHERE csp.period_id = ps.period_id
979: AND ps.period_set_id = p_period_set_id
980: AND ps.period_type_id = p_period_type_id

Line 1057: ' FROM cn_srp_period_quotas cspq, cn_quotas_all cq' || ' WHERE decode(:p_incentive_type,''ALL'', cq.incentive_type_code,' ||

1053: ' AND NVL(NVL(cspp.end_date, cnpp.end_date),cnps.start_date) >= cnps.start_date ' || ' AND cspp.org_id = cnpp.org_id ' || --R12
1054: ' AND cnpp.org_id = cnps.org_id ' || --R12
1055: ' AND cnps.org_id = :p_org_id ' || --R12
1056: ' ) v ' || ' WHERE row_nums = 1' || ' AND EXISTS' || ' (' || ' SELECT ''x''' ||
1057: ' FROM cn_srp_period_quotas cspq, cn_quotas_all cq' || ' WHERE decode(:p_incentive_type,''ALL'', cq.incentive_type_code,' ||
1058: ' NULL, cq.incentive_type_code,' || ' :p_incentive_type) = cq.incentive_type_code' ||
1059: ' AND v.credit_type_id = cq.credit_type_id' || ' AND v.payment_group_code = cq.payment_group_code' ||
1060: ' AND v.salesrep_id = cspq.salesrep_id' || ' AND cspq.quota_id = cq.quota_id' || ' AND cspq.org_id = cq.org_id' ||
1061: ' AND v.period_id = cspq.period_id ' || ' AND cspq.org_id = cq.org_id ' || --R12

Line 2659: cn_quotas_all q,

2655: srp.salesrep_id,
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

Line 2924: cn_quotas_all pe,

2920: wksht_rec.org_id,
2921: 1,
2922: cl.processed_date
2923: FROM cn_commission_lines cl,
2924: cn_quotas_all pe,
2925: cn_quota_pay_elements qp
2926: WHERE cl.credited_salesrep_id = wksht_rec.salesrep_id
2927: AND cl.processed_period_id <= wksht_rec.pay_period_id
2928: AND cl.processed_date <= wksht_rec.pay_date

Line 3024: cn_quotas_all pe,

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
3028: AND spayee.payee_id = wksht_rec.salesrep_id