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_PAYRUN_PVT dependencies on CN_SALESREPS

Line 348: ||' AND CN_SALESREPS.SALESREP_ID = :B2 '

344: --Modified by Sundar Venkat for bug fix 2660893
345: -- AC 04/09/03 2892822 : need to join with p_Incentive_type_code
346: l_where VARCHAR2(2000) :=
347: ' CN_PAYRUNS.PAYRUN_ID = :B1 '
348: ||' AND CN_SALESREPS.SALESREP_ID = :B2 '
349: ||' AND CN_PAYRUNS.ORG_ID = CN_SALESREPS.ORG_ID '
350: ||' AND CN_PAYMENT_TRANSACTIONS.QUOTA_ID = :B3'
351: ||' AND CN_PAYMENT_TRANSACTIONS.PAYRUN_ID = CN_PAYRUNS.PAYRUN_ID'
352: ||' AND CN_PAYMENT_TRANSACTIONS.INCENTIVE_TYPE_CODE = :B4 '

Line 349: ||' AND CN_PAYRUNS.ORG_ID = CN_SALESREPS.ORG_ID '

345: -- AC 04/09/03 2892822 : need to join with p_Incentive_type_code
346: l_where VARCHAR2(2000) :=
347: ' CN_PAYRUNS.PAYRUN_ID = :B1 '
348: ||' AND CN_SALESREPS.SALESREP_ID = :B2 '
349: ||' AND CN_PAYRUNS.ORG_ID = CN_SALESREPS.ORG_ID '
350: ||' AND CN_PAYMENT_TRANSACTIONS.QUOTA_ID = :B3'
351: ||' AND CN_PAYMENT_TRANSACTIONS.PAYRUN_ID = CN_PAYRUNS.PAYRUN_ID'
352: ||' AND CN_PAYMENT_TRANSACTIONS.INCENTIVE_TYPE_CODE = :B4 '
353: ||' AND CN_PAYMENT_TRANSACTIONS.CREDITED_SALESREP_ID = CN_SALESREPS.SALESREP_ID'

Line 353: ||' AND CN_PAYMENT_TRANSACTIONS.CREDITED_SALESREP_ID = CN_SALESREPS.SALESREP_ID'

349: ||' AND CN_PAYRUNS.ORG_ID = CN_SALESREPS.ORG_ID '
350: ||' AND CN_PAYMENT_TRANSACTIONS.QUOTA_ID = :B3'
351: ||' AND CN_PAYMENT_TRANSACTIONS.PAYRUN_ID = CN_PAYRUNS.PAYRUN_ID'
352: ||' AND CN_PAYMENT_TRANSACTIONS.INCENTIVE_TYPE_CODE = :B4 '
353: ||' AND CN_PAYMENT_TRANSACTIONS.CREDITED_SALESREP_ID = CN_SALESREPS.SALESREP_ID'
354: ||' AND CN_PAYMENT_TRANSACTIONS.PAY_ELEMENT_TYPE_ID IS NOT NULL';
355:
356: l_from VARCHAR2(2000) := ' CN_PAYRUNS, CN_SALESREPS, CN_PAYMENT_TRANSACTIONS ';
357:

Line 356: l_from VARCHAR2(2000) := ' CN_PAYRUNS, CN_SALESREPS, CN_PAYMENT_TRANSACTIONS ';

352: ||' AND CN_PAYMENT_TRANSACTIONS.INCENTIVE_TYPE_CODE = :B4 '
353: ||' AND CN_PAYMENT_TRANSACTIONS.CREDITED_SALESREP_ID = CN_SALESREPS.SALESREP_ID'
354: ||' AND CN_PAYMENT_TRANSACTIONS.PAY_ELEMENT_TYPE_ID IS NOT NULL';
355:
356: l_from VARCHAR2(2000) := ' CN_PAYRUNS, CN_SALESREPS, CN_PAYMENT_TRANSACTIONS ';
357:
358: l_select VARCHAR2(32000) ;
359:
360: -- Total Input Values Defined

Line 831: cn_quotas q,cn_salesreps cns

827:
828: CURSOR get_quotas(p_payrun cn_payruns.payrun_id%TYPE) IS
829: select distinct w.quota_id,q.name
830: from cn_payment_worksheets w,
831: cn_quotas q,cn_salesreps cns
832: where payrun_id=p_payrun
833: and w.quota_id is not null
834: and w.quota_id=q.quota_id
835: and w.salesrep_id=cns.salesrep_id

Line 1464: FROM cn_salesreps cns,

1460: CURSOR get_vendors IS
1461: SELECT cns.salesrep_id, pvs.vendor_id supplier_id,
1462: pvc.vendor_site_id supplier_site_id,
1463: currency_code
1464: FROM cn_salesreps cns,
1465: cn_payment_worksheets cnpw,
1466: po_vendor_sites pvs,
1467: po_vendor_contacts pvc
1468: WHERE cnpw.payrun_id = p_payrun_id

Line 1483: FROM cn_salesreps cns,

1479:
1480:
1481: CURSOR get_salesreps IS
1482: SELECT cns.salesrep_id,cns.currency_code,cns.source_id
1483: FROM cn_salesreps cns,
1484: cn_payment_worksheets cnpw
1485: WHERE cnpw.payrun_id = p_payrun_id
1486: AND cnpw.org_id=cns.org_id
1487: AND cnpw.salesrep_id = cns.salesrep_id

Line 1698: FROM cn_salesreps cns,

1694: l_api_name CONSTANT VARCHAR2(30) := 'populate_ccids';
1695:
1696: CURSOR get_vendors IS
1697: SELECT cns.salesrep_id
1698: FROM cn_salesreps cns,
1699: cn_payruns cnr
1700: WHERE
1701: cns.type = 'SUPPLIER_CONTACT'
1702: AND cns.salesrep_id = p_salesrep_id