APPS.CN_COMP_PLAN_PVT dependencies on CN_SRP_PLAN_ASSIGNS

Line 63: (srp_plan_assign_id CN_SRP_PLAN_ASSIGNS.SRP_PLAN_ASSIGN_ID%TYPE,

59: TABLE OF sales_role_rec_type INDEX BY BINARY_INTEGER ;
60:
61: -- salespeople assigned
62: TYPE srp_plan_assign_rec_type IS RECORD
63: (srp_plan_assign_id CN_SRP_PLAN_ASSIGNS.SRP_PLAN_ASSIGN_ID%TYPE,
64: salesrep_id CN_SRP_PLAN_ASSIGNS.SALESREP_ID%TYPE,
65: role_id CN_SRP_PLAN_ASSIGNS.ROLE_ID%TYPE,
66: role_name CN_ROLES.NAME%TYPE,
67: salesrep_name CN_SALESREPS.NAME%TYPE,

Line 64: salesrep_id CN_SRP_PLAN_ASSIGNS.SALESREP_ID%TYPE,

60:
61: -- salespeople assigned
62: TYPE srp_plan_assign_rec_type IS RECORD
63: (srp_plan_assign_id CN_SRP_PLAN_ASSIGNS.SRP_PLAN_ASSIGN_ID%TYPE,
64: salesrep_id CN_SRP_PLAN_ASSIGNS.SALESREP_ID%TYPE,
65: role_id CN_SRP_PLAN_ASSIGNS.ROLE_ID%TYPE,
66: role_name CN_ROLES.NAME%TYPE,
67: salesrep_name CN_SALESREPS.NAME%TYPE,
68: employee_number CN_SALESREPS.EMPLOYEE_NUMBER%TYPE,

Line 65: role_id CN_SRP_PLAN_ASSIGNS.ROLE_ID%TYPE,

61: -- salespeople assigned
62: TYPE srp_plan_assign_rec_type IS RECORD
63: (srp_plan_assign_id CN_SRP_PLAN_ASSIGNS.SRP_PLAN_ASSIGN_ID%TYPE,
64: salesrep_id CN_SRP_PLAN_ASSIGNS.SALESREP_ID%TYPE,
65: role_id CN_SRP_PLAN_ASSIGNS.ROLE_ID%TYPE,
66: role_name CN_ROLES.NAME%TYPE,
67: salesrep_name CN_SALESREPS.NAME%TYPE,
68: employee_number CN_SALESREPS.EMPLOYEE_NUMBER%TYPE,
69: start_date CN_SRP_PLAN_ASSIGNS.START_DATE%TYPE,

Line 69: start_date CN_SRP_PLAN_ASSIGNS.START_DATE%TYPE,

65: role_id CN_SRP_PLAN_ASSIGNS.ROLE_ID%TYPE,
66: role_name CN_ROLES.NAME%TYPE,
67: salesrep_name CN_SALESREPS.NAME%TYPE,
68: employee_number CN_SALESREPS.EMPLOYEE_NUMBER%TYPE,
69: start_date CN_SRP_PLAN_ASSIGNS.START_DATE%TYPE,
70: end_date CN_SRP_PLAN_ASSIGNS.END_DATE%TYPE);
71:
72: TYPE srp_plan_assign_tbl_type IS
73: TABLE OF srp_plan_assign_rec_type INDEX BY BINARY_INTEGER;

Line 70: end_date CN_SRP_PLAN_ASSIGNS.END_DATE%TYPE);

66: role_name CN_ROLES.NAME%TYPE,
67: salesrep_name CN_SALESREPS.NAME%TYPE,
68: employee_number CN_SALESREPS.EMPLOYEE_NUMBER%TYPE,
69: start_date CN_SRP_PLAN_ASSIGNS.START_DATE%TYPE,
70: end_date CN_SRP_PLAN_ASSIGNS.END_DATE%TYPE);
71:
72: TYPE srp_plan_assign_tbl_type IS
73: TABLE OF srp_plan_assign_rec_type INDEX BY BINARY_INTEGER;
74: