APPS.CN_GET_COMM_SUMM_DATA dependencies on CN_PERIOD_STATUSES

Line 24: cn_period_statuses ps,

20: fnd_user u,
21: cn_salesreps rep,
22: cn_comp_plans plan,
23: cn_roles role,
24: cn_period_statuses ps,
25: jtf_rs_resource_extns re
26: WHERE re.user_id = fnd_global.user_id
27: AND re.resource_id = rep.resource_id
28: AND rep.assigned_to_user_id = u.user_id (+)

Line 54: cn_period_statuses ps

50: fnd_user u,
51: cn_salesreps rep,
52: cn_comp_plans plan,
53: cn_roles role,
54: cn_period_statuses ps
55: WHERE u.user_id = p_user_id
56: AND rep.assigned_to_user_id = u.user_id
57: AND assign.salesrep_id = rep.salesrep_id
58: AND ps.period_id = p_period_id

Line 82: cn_period_statuses ps

78: fnd_user u,
79: cn_salesreps rep,
80: cn_comp_plans plan,
81: cn_roles role,
82: cn_period_statuses ps
83: WHERE rep.assigned_to_user_id = u.user_id (+)
84: AND assign.salesrep_id = rep.salesrep_id
85: AND ps.period_id = p_period_id
86: AND ps.start_date <= nvl(assign.end_date, ps.start_date)