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_COMMISSION_LINES

Line 1445: FROM cn_commission_lines_all ccl

1441: -- 12/27/04 : Bug 4090737 Performance Issue Creating Worksheet START
1442: CURSOR get_comm_total(p_period_id NUMBER) IS
1443: SELECT
1444: nvl(SUM(nvl(commission_amount, 0)), 0)
1445: FROM cn_commission_lines_all ccl
1446: WHERE credited_salesrep_id = p_worksheet_rec.salesrep_id
1447: AND processed_period_id <= p_period_id
1448: AND credit_type_id = g_credit_type_id
1449: AND status = 'CALC'

Line 1466: SELECT /+ index(cl CN_COMMISSION_LINES_N14) /

1462: -- 12/27/04 : Bug 4090737 Performance Issue Creating Worksheet END
1463:
1464: -- Bug 3140343 : Payee Design
1465: CURSOR get_comm_total_payee(p_period_id NUMBER) IS
1466: SELECT /*+ index(cl CN_COMMISSION_LINES_N14) */
1467: nvl(SUM(nvl(commission_amount, 0)), 0)
1468: FROM cn_commission_lines cl,
1469: cn_srp_payee_assigns_all spayee
1470: WHERE cl.srp_payee_assign_id IS NOT NULL

Line 1468: FROM cn_commission_lines cl,

1464: -- Bug 3140343 : Payee Design
1465: CURSOR get_comm_total_payee(p_period_id NUMBER) IS
1466: SELECT /*+ index(cl CN_COMMISSION_LINES_N14) */
1467: nvl(SUM(nvl(commission_amount, 0)), 0)
1468: FROM cn_commission_lines cl,
1469: cn_srp_payee_assigns_all spayee
1470: WHERE cl.srp_payee_assign_id IS NOT NULL
1471: AND cl.srp_payee_assign_id = spayee.srp_payee_assign_id
1472: AND spayee.payee_id = p_worksheet_rec.salesrep_id

Line 1928: UPDATE cn_commission_lines cls

1924: IF l_pbt_profile_value = 'Y'
1925: THEN
1926: IF l_ispayee <> 1
1927: THEN
1928: UPDATE cn_commission_lines cls
1929: SET posting_status = 'POSTED',
1930: last_update_date = SYSDATE,
1931: last_updated_by = g_last_updated_by,
1932: last_update_login = g_last_update_login

Line 1942: UPDATE cn_commission_lines cls

1938: WHERE posting_batch_id = cls_posting_batch_id
1939: AND commission_line_id IS NOT NULL);
1940: ELSE
1941: --payee
1942: UPDATE cn_commission_lines cls
1943: SET posting_status = 'POSTED',
1944: last_update_date = SYSDATE,
1945: last_updated_by = g_last_updated_by,
1946: last_update_login = g_last_update_login

Line 1970: UPDATE cn_commission_lines cls

1966: IF l_ispayee <> 1
1967: THEN
1968:
1969: FORALL m IN 1..l_wk_plan_elements.COUNT
1970: UPDATE cn_commission_lines cls
1971: SET posting_status = 'POSTED',
1972: last_update_date = SYSDATE,
1973: last_updated_by = g_last_updated_by,
1974: last_update_login = g_last_update_login

Line 1985: UPDATE cn_commission_lines clk

1981: AND quota_id = l_wk_plan_elements(m) ;
1982:
1983: ELSE
1984:
1985: UPDATE cn_commission_lines clk
1986: SET posting_status = 'POSTED',
1987: last_update_date = SYSDATE,
1988: last_updated_by = g_last_updated_by,
1989: last_update_login = g_last_update_login

Line 2877: FROM cn_commission_lines cl,

2873: --R12
2874: wksht_rec.org_id,
2875: 1,
2876: cl.processed_date
2877: FROM cn_commission_lines cl,
2878: cn_quotas_all pe,
2879: cn_quota_pay_elements qp
2880: WHERE cl.credited_salesrep_id = wksht_rec.salesrep_id
2881: AND cl.processed_period_id <= wksht_rec.pay_period_id

Line 2976: FROM cn_commission_lines cl,

2972: --R12
2973: wksht_rec.org_id,
2974: 1,
2975: cl.processed_date
2976: FROM cn_commission_lines cl,
2977: cn_srp_payee_assigns_all spayee,
2978: cn_quotas_all pe,
2979: cn_quota_pay_elements_all qp
2980: WHERE cl.srp_payee_assign_id IS NOT NULL

Line 3236: UPDATE cn_commission_lines cls

3232: THEN
3233: -- Bug 3191079 by jjhuang.
3234: IF l_ispayee <> 1
3235: THEN
3236: UPDATE cn_commission_lines cls
3237: SET posting_status = 'POSTED',
3238: last_update_date = SYSDATE,
3239: last_updated_by = g_last_updated_by,
3240: last_update_login = g_last_update_login

Line 3250: UPDATE cn_commission_lines cls

3246: WHERE posting_batch_id = l_posting_batch_id);
3247:
3248: ELSE
3249: -- payee
3250: UPDATE cn_commission_lines cls
3251: SET posting_status = 'POSTED',
3252: last_update_date = SYSDATE,
3253: last_updated_by = g_last_updated_by,
3254: last_update_login = g_last_update_login

Line 3276: UPDATE cn_commission_lines cls

3272: IF l_ispayee <> 1
3273: THEN
3274:
3275: FORALL m IN 1..l_wk_plan_elements.COUNT
3276: UPDATE cn_commission_lines cls
3277: SET posting_status = 'POSTED',
3278: last_update_date = SYSDATE,
3279: last_updated_by = g_last_updated_by,
3280: last_update_login = g_last_update_login

Line 3292: UPDATE cn_commission_lines clk

3288: AND credited_salesrep_id = wksht_rec.salesrep_id
3289: AND quota_id = l_wk_plan_elements(m);
3290:
3291: ELSE
3292: UPDATE cn_commission_lines clk
3293: SET posting_status = 'POSTED',
3294: last_update_date = SYSDATE,
3295: last_updated_by = g_last_updated_by,
3296: last_update_login = g_last_update_login

Line 3595: -- Bug 2760379 : Do not reset cn_commission_lines

3591: WHERE payrun_id = wksht.payrun_id
3592: AND credited_salesrep_id = wksht.salesrep_id
3593: AND incentive_type_code = 'PMTPLN_REC';
3594:
3595: -- Bug 2760379 : Do not reset cn_commission_lines
3596: DELETE FROM cn_payment_transactions
3597: WHERE incentive_type_code IN ('PMTPLN', 'MANUAL_PAY_ADJ')
3598: AND payrun_id = wksht.payrun_id
3599: AND credited_salesrep_id = wksht.salesrep_id;