DBA Data[Home] [Help]

APPS.CN_COMP_PLAN_PVT dependencies on CN_SRP_PLAN_ASSIGNS

Line 64: (srp_plan_assign_id CN_SRP_PLAN_ASSIGNS.SRP_PLAN_ASSIGN_ID%TYPE,

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

Line 65: salesrep_id CN_SRP_PLAN_ASSIGNS.SALESREP_ID%TYPE,

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

Line 66: role_id CN_SRP_PLAN_ASSIGNS.ROLE_ID%TYPE,

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

Line 70: start_date CN_SRP_PLAN_ASSIGNS.START_DATE%TYPE,

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

Line 71: end_date CN_SRP_PLAN_ASSIGNS.END_DATE%TYPE);

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