APPS.CN_SRP_PRD_QUOTA_PUB dependencies on CN_SRP_PLAN_ASSIGNS

Line 16: p_srp_plan_start_date IN CN_SRP_PLAN_ASSIGNS.START_DATE%TYPE,

12: p_salesrep_name IN CN_SALESREPS.NAME%TYPE,
13: p_employee_number IN CN_SALESREPS.EMPLOYEE_NUMBER%TYPE,
14: p_role_name IN CN_ROLES.NAME%TYPE,
15: p_cp_name IN CN_COMP_PLANS.NAME%TYPE,
16: p_srp_plan_start_date IN CN_SRP_PLAN_ASSIGNS.START_DATE%TYPE,
17: p_srp_plan_end_date IN CN_SRP_PLAN_ASSIGNS.END_DATE%TYPE,
18: p_pe_name IN CN_QUOTAS.NAME%TYPE,
19: p_target_amount IN CN_SRP_QUOTA_ASSIGNS.target%TYPE,
20: p_fixed_amount IN CN_SRP_QUOTA_ASSIGNS.payment_amount%TYPE,

Line 17: p_srp_plan_end_date IN CN_SRP_PLAN_ASSIGNS.END_DATE%TYPE,

13: p_employee_number IN CN_SALESREPS.EMPLOYEE_NUMBER%TYPE,
14: p_role_name IN CN_ROLES.NAME%TYPE,
15: p_cp_name IN CN_COMP_PLANS.NAME%TYPE,
16: p_srp_plan_start_date IN CN_SRP_PLAN_ASSIGNS.START_DATE%TYPE,
17: p_srp_plan_end_date IN CN_SRP_PLAN_ASSIGNS.END_DATE%TYPE,
18: p_pe_name IN CN_QUOTAS.NAME%TYPE,
19: p_target_amount IN CN_SRP_QUOTA_ASSIGNS.target%TYPE,
20: p_fixed_amount IN CN_SRP_QUOTA_ASSIGNS.payment_amount%TYPE,
21: p_performance_goal IN CN_SRP_QUOTA_ASSIGNS.performance_goal%TYPE,

Line 38: l_srp_plan_assign_id CN_SRP_PLAN_ASSIGNS.srp_plan_assign_id%TYPE;

34: l_quota_id CN_QUOTAS.quota_id%TYPE;
35: l_salesrep_id CN_SALESREPS.salesrep_id%TYPE;
36: l_role_id CN_ROLES.role_id%TYPE;
37: l_comp_plan_id CN_COMP_PLANS.comp_plan_id%TYPE;
38: l_srp_plan_assign_id CN_SRP_PLAN_ASSIGNS.srp_plan_assign_id%TYPE;
39: l_srp_quota_assign_id CN_SRP_quota_ASSIGNS.srp_quota_assign_id%TYPE;
40: l_customized_flag CN_SRP_quota_ASSIGNS.customized_flag%TYPE;
41:
42: l_period_target_unit_code CN_SRP_quota_ASSIGNS.period_target_unit_code%TYPE;

Line 102: from cn_srp_plan_assigns

98: p_comp_plan_id NUMBER,
99: p_srp_plan_sd DATE,
100: p_srp_plan_ed DATE) IS
101: SELECT *
102: from cn_srp_plan_assigns
103: where salesrep_id = p_salesrep_id
104: and role_id = p_role_id
105: and comp_plan_id = p_comp_plan_id
106: and start_date = p_srp_plan_sd

Line 145: f_srp_plan_assign_id_rec CN_SRP_PLAN_ASSIGNS%ROWTYPE;

141: f_quota_id_rec CN_QUOTAS%ROWTYPE;
142: f_salesrep_id_rec CN_SALESREPS%ROWTYPE;
143: f_role_id_rec CN_ROLES%ROWTYPE;
144: f_comp_plan_id_rec CN_COMP_PLANS%ROWTYPE;
145: f_srp_plan_assign_id_rec CN_SRP_PLAN_ASSIGNS%ROWTYPE;
146: f_srp_quota_assign_id_rec CN_SRP_QUOTA_ASSIGNS%ROWTYPE;
147: f_period_id_rec CN_PERIOD_STATUSES%ROWTYPE;
148: f_period_quota_info_rec cn_srp_period_quotas_v%ROWTYPE;
149: