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_MARK_EVENTS_PKG dependencies on CN_SRP_ROLES

Line 2615: FROM cn_srp_roles sr, cn_srp_intel_periods intel, cn_period_statuses acc

2611: , acc.period_id period_id
2612: , DECODE(acc.period_id, l_start_period_id, l_s_date, acc.start_date) start_date
2613: , DECODE(acc.period_id, l_end_period_id, NVL(l_e_date, acc.end_date), acc.end_date)
2614: end_date
2615: FROM cn_srp_roles sr, cn_srp_intel_periods intel, cn_period_statuses acc
2616: WHERE sr.role_id = l_role_id
2617: AND sr.org_id = p_org_id
2618: AND acc.period_id BETWEEN l_start_period_id AND l_end_period_id
2619: AND acc.period_status = 'O'

Line 2872: l_salesrep_id cn_srp_roles.salesrep_id%TYPE;

2868: , p_end_date DATE
2869: , p_end_date_old DATE
2870: , p_org_id NUMBER
2871: ) IS
2872: l_salesrep_id cn_srp_roles.salesrep_id%TYPE;
2873: l_event_log_id NUMBER;
2874: l_start_period_id NUMBER(15);
2875: l_end_period_id NUMBER(15);
2876: l_date_range_tbl cn_api.date_range_tbl_type;