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 1447: FROM cn_commission_lines_all ccl

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

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

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

Line 1470: FROM cn_commission_lines cl,

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

Line 1930: UPDATE cn_commission_lines cls

1926: IF l_pbt_profile_value = 'Y'
1927: THEN
1928: IF l_ispayee <> 1
1929: THEN
1930: UPDATE cn_commission_lines cls
1931: SET posting_status = 'POSTED',
1932: last_update_date = SYSDATE,
1933: last_updated_by = fnd_global.user_id,
1934: last_update_login = fnd_global.login_id

Line 1944: UPDATE cn_commission_lines cls

1940: WHERE posting_batch_id = cls_posting_batch_id
1941: AND commission_line_id IS NOT NULL);
1942: ELSE
1943: --payee
1944: UPDATE cn_commission_lines cls
1945: SET posting_status = 'POSTED',
1946: last_update_date = SYSDATE,
1947: last_updated_by = fnd_global.user_id,
1948: last_update_login = fnd_global.login_id

Line 1972: UPDATE cn_commission_lines cls

1968: IF l_ispayee <> 1
1969: THEN
1970:
1971: FORALL m IN 1..l_wk_plan_elements.COUNT
1972: UPDATE cn_commission_lines cls
1973: SET posting_status = 'POSTED',
1974: last_update_date = SYSDATE,
1975: last_updated_by = fnd_global.user_id,
1976: last_update_login = fnd_global.login_id

Line 1987: UPDATE cn_commission_lines clk

1983: AND quota_id = l_wk_plan_elements(m) ;
1984:
1985: ELSE
1986:
1987: UPDATE cn_commission_lines clk
1988: SET posting_status = 'POSTED',
1989: last_update_date = SYSDATE,
1990: last_updated_by = fnd_global.user_id,
1991: last_update_login = fnd_global.login_id

Line 2923: FROM cn_commission_lines cl,

2919: --R12
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

Line 3022: FROM cn_commission_lines cl,

3018: --R12
3019: wksht_rec.org_id,
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

Line 3282: UPDATE cn_commission_lines cls

3278: THEN
3279: -- Bug 3191079 by jjhuang.
3280: IF l_ispayee <> 1
3281: THEN
3282: UPDATE cn_commission_lines cls
3283: SET posting_status = 'POSTED',
3284: last_update_date = SYSDATE,
3285: last_updated_by = fnd_global.user_id,
3286: last_update_login = fnd_global.login_id

Line 3296: UPDATE cn_commission_lines cls

3292: WHERE posting_batch_id = l_posting_batch_id);
3293:
3294: ELSE
3295: -- payee
3296: UPDATE cn_commission_lines cls
3297: SET posting_status = 'POSTED',
3298: last_update_date = SYSDATE,
3299: last_updated_by = fnd_global.user_id,
3300: last_update_login = fnd_global.login_id

Line 3322: UPDATE cn_commission_lines cls

3318: IF l_ispayee <> 1
3319: THEN
3320:
3321: FORALL m IN 1..l_wk_plan_elements.COUNT
3322: UPDATE cn_commission_lines cls
3323: SET posting_status = 'POSTED',
3324: last_update_date = SYSDATE,
3325: last_updated_by = fnd_global.user_id,
3326: last_update_login = fnd_global.login_id

Line 3338: UPDATE cn_commission_lines clk

3334: AND credited_salesrep_id = wksht_rec.salesrep_id
3335: AND quota_id = l_wk_plan_elements(m);
3336:
3337: ELSE
3338: UPDATE cn_commission_lines clk
3339: SET posting_status = 'POSTED',
3340: last_update_date = SYSDATE,
3341: last_updated_by = fnd_global.user_id,
3342: last_update_login = fnd_global.login_id

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

3637: WHERE payrun_id = wksht.payrun_id
3638: AND credited_salesrep_id = wksht.salesrep_id
3639: AND incentive_type_code = 'PMTPLN_REC';
3640:
3641: -- Bug 2760379 : Do not reset cn_commission_lines
3642: DELETE FROM cn_payment_transactions
3643: WHERE incentive_type_code IN ('PMTPLN', 'MANUAL_PAY_ADJ')
3644: AND payrun_id = wksht.payrun_id
3645: AND credited_salesrep_id = wksht.salesrep_id;