APPS.CN_MARK_EVENTS_PKG dependencies on CN_COMP_TEAMS

Line 4850: t_team_name cn_comp_teams.NAME%TYPE;

4846: , p_org_id IN NUMBER
4847: ) IS
4848: l_event_log_id NUMBER;
4849: l_action_link_id NUMBER;
4850: t_team_name cn_comp_teams.NAME%TYPE;
4851: t_start_date_active cn_comp_teams.start_date_active%TYPE;
4852: t_end_date_active cn_comp_teams.end_date_active%TYPE;
4853: l_revert_state VARCHAR2(30);
4854: l_action VARCHAR2(30);

Line 4851: t_start_date_active cn_comp_teams.start_date_active%TYPE;

4847: ) IS
4848: l_event_log_id NUMBER;
4849: l_action_link_id NUMBER;
4850: t_team_name cn_comp_teams.NAME%TYPE;
4851: t_start_date_active cn_comp_teams.start_date_active%TYPE;
4852: t_end_date_active cn_comp_teams.end_date_active%TYPE;
4853: l_revert_state VARCHAR2(30);
4854: l_action VARCHAR2(30);
4855:

Line 4852: t_end_date_active cn_comp_teams.end_date_active%TYPE;

4848: l_event_log_id NUMBER;
4849: l_action_link_id NUMBER;
4850: t_team_name cn_comp_teams.NAME%TYPE;
4851: t_start_date_active cn_comp_teams.start_date_active%TYPE;
4852: t_end_date_active cn_comp_teams.end_date_active%TYPE;
4853: l_revert_state VARCHAR2(30);
4854: l_action VARCHAR2(30);
4855:
4856: -- get all the reps in this team

Line 4867: FROM cn_comp_teams

4863: CURSOR c_team_info(p_team_id NUMBER) IS
4864: SELECT NAME
4865: , start_date_active
4866: , end_date_active
4867: FROM cn_comp_teams
4868: WHERE comp_team_id = p_team_id;
4869:
4870: -- cursor to find all periods in the date range for each srp
4871: CURSOR periods(