APPS.CN_MARK_EVENTS_PKG dependencies on CN_COMP_TEAMS

Line 4845: t_team_name cn_comp_teams.NAME%TYPE;

4841: , p_org_id IN NUMBER
4842: ) IS
4843: l_event_log_id NUMBER;
4844: l_action_link_id NUMBER;
4845: t_team_name cn_comp_teams.NAME%TYPE;
4846: t_start_date_active cn_comp_teams.start_date_active%TYPE;
4847: t_end_date_active cn_comp_teams.end_date_active%TYPE;
4848: l_revert_state VARCHAR2(30);
4849: l_action VARCHAR2(30);

Line 4846: t_start_date_active cn_comp_teams.start_date_active%TYPE;

4842: ) IS
4843: l_event_log_id NUMBER;
4844: l_action_link_id NUMBER;
4845: t_team_name cn_comp_teams.NAME%TYPE;
4846: t_start_date_active cn_comp_teams.start_date_active%TYPE;
4847: t_end_date_active cn_comp_teams.end_date_active%TYPE;
4848: l_revert_state VARCHAR2(30);
4849: l_action VARCHAR2(30);
4850:

Line 4847: t_end_date_active cn_comp_teams.end_date_active%TYPE;

4843: l_event_log_id NUMBER;
4844: l_action_link_id NUMBER;
4845: t_team_name cn_comp_teams.NAME%TYPE;
4846: t_start_date_active cn_comp_teams.start_date_active%TYPE;
4847: t_end_date_active cn_comp_teams.end_date_active%TYPE;
4848: l_revert_state VARCHAR2(30);
4849: l_action VARCHAR2(30);
4850:
4851: -- get all the reps in this team

Line 4862: FROM cn_comp_teams

4858: CURSOR c_team_info(p_team_id NUMBER) IS
4859: SELECT NAME
4860: , start_date_active
4861: , end_date_active
4862: FROM cn_comp_teams
4863: WHERE comp_team_id = p_team_id;
4864:
4865: -- cursor to find all periods in the date range for each srp
4866: CURSOR periods(