APPS.CN_SRP_PRD_QUOTA_PUB dependencies on CN_COMP_PLANS

Line 15: p_cp_name IN CN_COMP_PLANS.NAME%TYPE,

11: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
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,

Line 37: l_comp_plan_id CN_COMP_PLANS.comp_plan_id%TYPE;

33:
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:

Line 92: from cn_comp_plans

88: where name = p_role_name;
89:
90: CURSOR l_comp_plan_id_cr (p_comp_plan_name VARCHAR2) IS
91: SELECT *
92: from cn_comp_plans
93: where name = p_comp_plan_name
94: AND org_id = l_org_id;
95:
96: CURSOR l_srp_plan_assign_id_cr (p_salesrep_id NUMBER,

Line 144: f_comp_plan_id_rec CN_COMP_PLANS%ROWTYPE;

140: f_quota_row_rec CN_QUOTAS%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;