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_PERIOD_QUOTAS

Line 68: FROM cn_srp_period_quotas_all cspq,

64: 0
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

Line 389: FROM cn_srp_period_quotas cspq,

385: p_org_id IN cn_payruns.org_id%TYPE
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

Line 415: FROM cn_srp_period_quotas cspq,

411: AND spayee.org_id = p_org_id
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

Line 516: FROM cn_srp_period_quotas cnsp,

512: AND cq.payment_group_code = nvl(p_payment_group_code, cq.payment_group_code)
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

Line 566: FROM cn_srp_period_quotas cnsp,

562: AND cq.payment_group_code = nvl(p_payment_group_code, cq.payment_group_code)
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

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