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

Line 253: WHERE (employee_number, type) = (SELECT employee_number, type FROM cn_salesreps WHERE salesrep_id = x_salesrep_id)

249: COMMIT;
250:
251: -- Delete transactions from CN_COMM_LINES_API, CN_NOT_TRX, CN_TRX, CN_TRX_LINES, CN_TRX_SALES_LINES
252: DELETE FROM CN_COMM_LINES_API
253: WHERE (employee_number, type) = (SELECT employee_number, type FROM cn_salesreps WHERE salesrep_id = x_salesrep_id)
254: AND processed_date between l_start_date and l_end_date;
255: COMMIT;
256:
257: DELETE FROM cn_not_trx

Line 287: WHERE direct_salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)

283: COMMIT;
284: ELSE
285: -- Delete transactions from CN_COMMISSION_HEADERS
286: DELETE FROM CN_COMMISSION_HEADERS
287: WHERE direct_salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
288: AND processed_date between l_start_date and l_end_date;
289: COMMIT;
290:
291: -- Delete transactions from CN_COMMISSION_LINES

Line 430: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)

426: balance33_dtd = 0,
427: balance33_ctd = 0,
428: balance33_bbd = 0,
429: balance33_bbc = 0
430: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
431: AND period_id between l_start_period_id and l_end_period_id;
432: COMMIT;
433:
434: -- Update CN_SRP_PERIOD_QUOTAS

Line 450: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)

446: recovery_amount_itd = (recovery_amount_itd - nvl(recovery_amount_ptd,0)),
447: recovery_amount_ptd = 0,
448: performance_goal_itd = (performance_goal_itd - nvl(performance_goal_ptd,0)),
449: performance_goal_ptd = 0
450: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
451: AND period_id between l_start_period_id and l_end_period_id;
452:
453: COMMIT;
454:

Line 460: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)

456: UPDATE cn_srp_per_quota_rc SET
457: year_to_date = 0,
458: quarter_to_date = 0,
459: period_to_date = 0
460: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
461: AND period_id between l_start_period_id and l_end_period_id;
462: COMMIT;
463:
464: -- Delete Payment from CN_PAYMENT_WORKSHEETS, CN_PAYMENT_API

Line 466: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)

462: COMMIT;
463:
464: -- Delete Payment from CN_PAYMENT_WORKSHEETS, CN_PAYMENT_API
465: DELETE FROM CN_PAYMENT_WORKSHEETS
466: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
467: AND payrun_id IN (SELECT payrun_id FROM CN_PAYRUNS
468: WHERE accounting_period_id between l_start_period_id and l_end_period_id);
469: COMMIT;
470:

Line 472: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)

468: WHERE accounting_period_id between l_start_period_id and l_end_period_id);
469: COMMIT;
470:
471: DELETE FROM CN_PAYMENT_API
472: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
473: AND period_id between l_start_period_id and l_end_period_id
474: AND payrun_id IN (SELECT payrun_id FROM CN_PAYRUNS
475: WHERE accounting_period_id between l_start_period_id and l_end_period_id);
476: COMMIT;

Line 481: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)

477:
478: -- Delete journal entries from CN_LEDGER_JOURNAL_ENTRIES
479: DELETE FROM CN_LEDGER_JOURNAL_ENTRIES
480: WHERE srp_period_id IN (SELECT srp_period_id FROM CN_SRP_PERIODS
481: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
482: AND period_id between l_start_period_id and l_end_period_id);
483: COMMIT;
484:
485: -- Delete transactions from CN_COMM_LINES_API, CN_NOT_TRX, CN_TRX, CN_TRX_LINES, CN_TRX_SALES_LINES

Line 487: WHERE (employee_number, TYPE) IN (SELECT employee_number, TYPE FROM cn_salesreps)

483: COMMIT;
484:
485: -- Delete transactions from CN_COMM_LINES_API, CN_NOT_TRX, CN_TRX, CN_TRX_LINES, CN_TRX_SALES_LINES
486: DELETE FROM CN_COMM_LINES_API
487: WHERE (employee_number, TYPE) IN (SELECT employee_number, TYPE FROM cn_salesreps)
488: AND processed_date between l_start_date and l_end_date;
489: COMMIT;
490:
491: DELETE FROM cn_not_trx

Line 496: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)

492: WHERE source_trx_id IN (SELECT source_trx_id
493: FROM cn_trx
494: WHERE trx_id IN (SELECT trx_id
495: FROM cn_trx_sales_lines
496: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
497: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id));
498: COMMIT;
499:
500: DELETE FROM cn_trx

Line 503: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)

499:
500: DELETE FROM cn_trx
501: WHERE trx_id IN (SELECT trx_id
502: FROM cn_trx_sales_lines
503: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
504: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id);
505: COMMIT;
506:
507: DELETE FROM cn_trx_lines

Line 510: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)

506:
507: DELETE FROM cn_trx_lines
508: WHERE trx_line_id IN (SELECT trx_line_id
509: FROM cn_trx_sales_lines
510: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
511: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id);
512: COMMIT;
513:
514: DELETE FROM CN_TRX_SALES_LINES

Line 515: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)

511: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id);
512: COMMIT;
513:
514: DELETE FROM CN_TRX_SALES_LINES
515: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
516: AND processed_period_id between l_start_period_id and l_end_period_id;
517: COMMIT;
518: END IF;
519: