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_PAYMENT_TRANSACTIONS

Line 242: CURSOR get_assign_id (p_org_id cn_payment_transactions.org_id%TYPE ) IS

238:
239: --
240: -- get the assignment id and business group id
241: --
242: CURSOR get_assign_id (p_org_id cn_payment_transactions.org_id%TYPE ) IS
243: SELECT p.assignment_id assignment_id,
244: p.assignment_number assignment_number,
245: rre.source_business_grp_id source_business_grp_id,
246: rs.status status

Line 350: ||' AND CN_PAYMENT_TRANSACTIONS.QUOTA_ID = :B3'

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'
354: ||' AND CN_PAYMENT_TRANSACTIONS.PAY_ELEMENT_TYPE_ID IS NOT NULL';

Line 351: ||' AND CN_PAYMENT_TRANSACTIONS.PAYRUN_ID = CN_PAYRUNS.PAYRUN_ID'

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'
354: ||' AND CN_PAYMENT_TRANSACTIONS.PAY_ELEMENT_TYPE_ID IS NOT NULL';
355:

Line 352: ||' AND CN_PAYMENT_TRANSACTIONS.INCENTIVE_TYPE_CODE = :B4 '

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

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 354: ||' AND CN_PAYMENT_TRANSACTIONS.PAY_ELEMENT_TYPE_ID IS NOT NULL';

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:
358: l_select VARCHAR2(32000) ;

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 477: IF tab_columns.table_name = 'CN_PAYMENT_TRANSACTIONS' and

473: -- sum of all pmt trx with same quota_id,srp_id,incentive_type,
474: -- pay_element_type_id but the dynamic sql statement here cannot do a
475: -- group by so should use original payment_amount
476:
477: IF tab_columns.table_name = 'CN_PAYMENT_TRANSACTIONS' and
478: tab_columns.column_name = 'PAYMENT_AMOUNT' THEN
479: l_select := l_select || tab_columns.table_name
480: ||'.'||tab_columns.column_name -- nvl(p_amount,0)
481: || ' C_'||l_count|| ',';

Line 485: -- l_where := l_where || ' AND CN_PAYMENT_TRANSACTIONS.PAYRUN_ID = CN_PAYRUNS.PAYRUN_ID ' ;

481: || ' C_'||l_count|| ',';
482: --Commented by Sundar Venkat for bug fix 2660893
483: --IF l_flag_payment_transactions = 'N' THEN
484: -- l_from := l_from || ', ' || tab_columns.table_name ;
485: -- l_where := l_where || ' AND CN_PAYMENT_TRANSACTIONS.PAYRUN_ID = CN_PAYRUNS.PAYRUN_ID ' ;
486: -- l_flag_payment_transactions := 'Y';
487: --END IF ;
488:
489: ELSIF tab_columns.table_name iS NOT NULL THEN

Line 495: -- IF l_flag_payment_transactions = 'N' AND tab_columns.table_name = 'CN_PAYMENT_TRANSACTIONS' THEN

491: l_select := l_select || tab_columns.table_name
492: ||'.'||tab_columns.column_name
493: || ' C_'||l_count|| ',';
494: --Commented by Sundar Venkat for bug fix 2660893
495: -- IF l_flag_payment_transactions = 'N' AND tab_columns.table_name = 'CN_PAYMENT_TRANSACTIONS' THEN
496: -- l_from := l_from || ', ' || tab_columns.table_name ;
497: -- l_where := l_where || ' AND CN_PAYMENT_TRANSACTIONS.PAYRUN_ID= CN_PAYRUNS.PAYRUN_ID ' ;
498: -- l_flag_payment_transactions := 'Y';
499: -- END IF ;

Line 497: -- l_where := l_where || ' AND CN_PAYMENT_TRANSACTIONS.PAYRUN_ID= CN_PAYRUNS.PAYRUN_ID ' ;

493: || ' C_'||l_count|| ',';
494: --Commented by Sundar Venkat for bug fix 2660893
495: -- IF l_flag_payment_transactions = 'N' AND tab_columns.table_name = 'CN_PAYMENT_TRANSACTIONS' THEN
496: -- l_from := l_from || ', ' || tab_columns.table_name ;
497: -- l_where := l_where || ' AND CN_PAYMENT_TRANSACTIONS.PAYRUN_ID= CN_PAYRUNS.PAYRUN_ID ' ;
498: -- l_flag_payment_transactions := 'Y';
499: -- END IF ;
500:
501:

Line 726: FROM cn_payment_transactions pt

722: pt.credited_salesrep_id,
723: pt.pay_element_type_id,
724: pt.quota_id,
725: pt.incentive_type_code
726: FROM cn_payment_transactions pt
727: WHERE pt.payrun_id = p_payrun_id
728: AND nvl(waive_flag,'N') = 'N'
729: AND nvl(hold_flag, 'N') = 'N'
730: GROUP BY pt.quota_id,

Line 1493: CURSOR get_vendors(p_source_id IN cn_payment_transactions.credited_salesrep_id%TYPE) IS

1489: AND cns.type = 'SUPPLIER_CONTACT'
1490: AND cns.source_id IS NOT NULL;
1491:
1492:
1493: CURSOR get_vendors(p_source_id IN cn_payment_transactions.credited_salesrep_id%TYPE) IS
1494: SELECT pvs.vendor_id supplier_id,
1495: pvc.vendor_site_id supplier_site_id
1496: FROM
1497: po_vendor_sites pvs,

Line 1507: CURSOR get_invoice_lines (p_salesrep_id IN cn_payment_transactions.credited_salesrep_id%TYPE) IS

1503:
1504:
1505:
1506: --Bug 2922190 by Julia Huang.
1507: CURSOR get_invoice_lines (p_salesrep_id IN cn_payment_transactions.credited_salesrep_id%TYPE) IS
1508: SELECT payment_transaction_id,
1509: ROUND(payment_amount,2) payment_amount,
1510: liability_ccid,
1511: expense_ccid

Line 1512: FROM cn_payment_transactions

1508: SELECT payment_transaction_id,
1509: ROUND(payment_amount,2) payment_amount,
1510: liability_ccid,
1511: expense_ccid
1512: FROM cn_payment_transactions
1513: WHERE payrun_id = p_payrun_id
1514: AND credited_salesrep_id = p_salesrep_id
1515: AND nvl(hold_flag,'N') = 'N';
1516:

Line 1689: p_pmt_tran_id IN cn_payment_transactions.payment_transaction_id%TYPE DEFAULT NULL,

1685: p_salesrep_id IN cn_payment_worksheets.salesrep_id%TYPE,
1686: --p_start_date IN DATE,
1687: --p_end_date IN DATE,
1688: -- Bug 3866089 (the same as 11.5.8 bug 3841926, 11.5.10 3866116) by jjhuang on 11/1/04
1689: p_pmt_tran_id IN cn_payment_transactions.payment_transaction_id%TYPE DEFAULT NULL,
1690: p_loading_status OUT NOCOPY VARCHAR2,
1691: x_loading_status OUT NOCOPY VARCHAR2
1692: ) RETURN VARCHAR2 IS
1693:

Line 1709: FROM cn_payment_transactions

1705:
1706:
1707: CURSOR get_invoice_lines IS
1708: SELECT payment_transaction_id
1709: FROM cn_payment_transactions
1710: WHERE payrun_id = p_payrun_id
1711: AND credited_salesrep_id = p_salesrep_id
1712: AND nvl(paid_flag, 'N') = 'N' -- is null -- Bug 2822874
1713: AND payee_salesrep_id = p_salesrep_id

Line 2899: FROM cn_payment_transactions

2895: CURSOR get_control_pmt(p_salesrep_id NUMBER,
2896: p_quota_id NUMBER,
2897: p_org_id cn_payruns.org_id%TYPE) IS
2898: SELECT nvl(sum(nvl(payment_amount,0) - nvl(amount,0)),0) control_payment
2899: FROM cn_payment_transactions
2900: WHERE payrun_id = p_payrun_id
2901: AND credited_salesrep_id = p_salesrep_id
2902: AND credit_type_id = l_credit_type_id
2903: AND (quota_id = p_quota_id

Line 2912: FROM cn_payment_transactions

2908:
2909: CURSOR get_hold_pmt(p_salesrep_id NUMBER,
2910: p_quota_id NUMBER) IS
2911: SELECT nvl(sum(nvl(amount,0)),0) hold_payment
2912: FROM cn_payment_transactions
2913: WHERE payrun_id = p_payrun_id
2914: AND credited_salesrep_id = p_salesrep_id
2915: AND credit_type_id = l_credit_type_id
2916: AND (quota_id = p_quota_id

Line 2928: FROM cn_payment_transactions

2924: CURSOR get_man_pay_adj(p_salesrep_id NUMBER,
2925: p_quota_id NUMBER,
2926: p_org_id cn_payruns.org_id%TYPE) IS
2927: SELECT nvl(sum(nvl(amount,0)),0) man_pay_adj, recoverable_flag
2928: FROM cn_payment_transactions
2929: WHERE payrun_id = p_payrun_id
2930: AND credited_salesrep_id = p_salesrep_id
2931: AND credit_type_id = l_credit_type_id
2932: AND quota_id = p_quota_id

Line 2955: FROM cn_payment_transactions

2951: CURSOR get_waive_rec(p_salesrep_id NUMBER,
2952: p_quota_id NUMBER,
2953: p_org_id cn_payruns.org_id%TYPE) IS
2954: SELECT -nvl(sum(nvl(payment_amount,0)),0)
2955: FROM cn_payment_transactions
2956: WHERE payrun_id = p_payrun_id
2957: AND credited_salesrep_id = p_salesrep_id
2958: AND credit_type_id = l_credit_type_id
2959: AND incentive_type_code = 'PMTPLN_REC'

Line 3104: UPDATE cn_payment_transactions

3100: END IF;
3101: END IF;
3102:
3103: -- process hold transactions
3104: UPDATE cn_payment_transactions
3105: SET payrun_id = '',
3106: LAST_UPDATE_DATE = Sysdate,
3107: LAST_UPDATED_BY = G_LAST_UPDATED_BY,
3108: LAST_UPDATE_LOGIN = G_LAST_UPDATE_LOGIN

Line 3115: UPDATE cn_payment_transactions

3111: --R12
3112: AND org_id = l_payrun_rec.org_id;
3113:
3114: -- set transactions to paid for this payrun
3115: UPDATE cn_payment_transactions
3116: SET paid_flag = 'Y',
3117: LAST_UPDATE_DATE = Sysdate,
3118: LAST_UPDATED_BY = G_LAST_UPDATED_BY,
3119: LAST_UPDATE_LOGIN = G_LAST_UPDATE_LOGIN