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 2617: FROM cn_srp_roles sr, cn_srp_intel_periods intel, cn_period_statuses acc

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

Line 2874: l_salesrep_id cn_srp_roles.salesrep_id%TYPE;

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