245:
246: TYPE PayGroup_assign_rec IS RECORD
247: ( employee_type cn_salesreps.type%TYPE,
248: employee_number cn_salesreps.employee_number%TYPE,
249: assignment_start_date cn_srp_pay_groups.start_date%TYPE,
250: assignment_end_date cn_srp_pay_groups.end_date%TYPE,
251: attribute_category cn_srp_pay_groups.attribute_category%TYPE := NULL,
252: attribute1 cn_srp_pay_groups.attribute1%TYPE := NULL,
253: attribute2 cn_srp_pay_groups.attribute2%TYPE := NULL,
246: TYPE PayGroup_assign_rec IS RECORD
247: ( employee_type cn_salesreps.type%TYPE,
248: employee_number cn_salesreps.employee_number%TYPE,
249: assignment_start_date cn_srp_pay_groups.start_date%TYPE,
250: assignment_end_date cn_srp_pay_groups.end_date%TYPE,
251: attribute_category cn_srp_pay_groups.attribute_category%TYPE := NULL,
252: attribute1 cn_srp_pay_groups.attribute1%TYPE := NULL,
253: attribute2 cn_srp_pay_groups.attribute2%TYPE := NULL,
254: attribute3 cn_srp_pay_groups.attribute3%TYPE := NULL,
247: ( employee_type cn_salesreps.type%TYPE,
248: employee_number cn_salesreps.employee_number%TYPE,
249: assignment_start_date cn_srp_pay_groups.start_date%TYPE,
250: assignment_end_date cn_srp_pay_groups.end_date%TYPE,
251: attribute_category cn_srp_pay_groups.attribute_category%TYPE := NULL,
252: attribute1 cn_srp_pay_groups.attribute1%TYPE := NULL,
253: attribute2 cn_srp_pay_groups.attribute2%TYPE := NULL,
254: attribute3 cn_srp_pay_groups.attribute3%TYPE := NULL,
255: attribute4 cn_srp_pay_groups.attribute4%TYPE := NULL,
248: employee_number cn_salesreps.employee_number%TYPE,
249: assignment_start_date cn_srp_pay_groups.start_date%TYPE,
250: assignment_end_date cn_srp_pay_groups.end_date%TYPE,
251: attribute_category cn_srp_pay_groups.attribute_category%TYPE := NULL,
252: attribute1 cn_srp_pay_groups.attribute1%TYPE := NULL,
253: attribute2 cn_srp_pay_groups.attribute2%TYPE := NULL,
254: attribute3 cn_srp_pay_groups.attribute3%TYPE := NULL,
255: attribute4 cn_srp_pay_groups.attribute4%TYPE := NULL,
256: attribute5 cn_srp_pay_groups.attribute5%TYPE := NULL,
249: assignment_start_date cn_srp_pay_groups.start_date%TYPE,
250: assignment_end_date cn_srp_pay_groups.end_date%TYPE,
251: attribute_category cn_srp_pay_groups.attribute_category%TYPE := NULL,
252: attribute1 cn_srp_pay_groups.attribute1%TYPE := NULL,
253: attribute2 cn_srp_pay_groups.attribute2%TYPE := NULL,
254: attribute3 cn_srp_pay_groups.attribute3%TYPE := NULL,
255: attribute4 cn_srp_pay_groups.attribute4%TYPE := NULL,
256: attribute5 cn_srp_pay_groups.attribute5%TYPE := NULL,
257: attribute6 cn_srp_pay_groups.attribute6%TYPE := NULL,
250: assignment_end_date cn_srp_pay_groups.end_date%TYPE,
251: attribute_category cn_srp_pay_groups.attribute_category%TYPE := NULL,
252: attribute1 cn_srp_pay_groups.attribute1%TYPE := NULL,
253: attribute2 cn_srp_pay_groups.attribute2%TYPE := NULL,
254: attribute3 cn_srp_pay_groups.attribute3%TYPE := NULL,
255: attribute4 cn_srp_pay_groups.attribute4%TYPE := NULL,
256: attribute5 cn_srp_pay_groups.attribute5%TYPE := NULL,
257: attribute6 cn_srp_pay_groups.attribute6%TYPE := NULL,
258: attribute7 cn_srp_pay_groups.attribute7%TYPE := NULL,
251: attribute_category cn_srp_pay_groups.attribute_category%TYPE := NULL,
252: attribute1 cn_srp_pay_groups.attribute1%TYPE := NULL,
253: attribute2 cn_srp_pay_groups.attribute2%TYPE := NULL,
254: attribute3 cn_srp_pay_groups.attribute3%TYPE := NULL,
255: attribute4 cn_srp_pay_groups.attribute4%TYPE := NULL,
256: attribute5 cn_srp_pay_groups.attribute5%TYPE := NULL,
257: attribute6 cn_srp_pay_groups.attribute6%TYPE := NULL,
258: attribute7 cn_srp_pay_groups.attribute7%TYPE := NULL,
259: attribute8 cn_srp_pay_groups.attribute8%TYPE := NULL,
252: attribute1 cn_srp_pay_groups.attribute1%TYPE := NULL,
253: attribute2 cn_srp_pay_groups.attribute2%TYPE := NULL,
254: attribute3 cn_srp_pay_groups.attribute3%TYPE := NULL,
255: attribute4 cn_srp_pay_groups.attribute4%TYPE := NULL,
256: attribute5 cn_srp_pay_groups.attribute5%TYPE := NULL,
257: attribute6 cn_srp_pay_groups.attribute6%TYPE := NULL,
258: attribute7 cn_srp_pay_groups.attribute7%TYPE := NULL,
259: attribute8 cn_srp_pay_groups.attribute8%TYPE := NULL,
260: attribute9 cn_srp_pay_groups.attribute9%TYPE := NULL,
253: attribute2 cn_srp_pay_groups.attribute2%TYPE := NULL,
254: attribute3 cn_srp_pay_groups.attribute3%TYPE := NULL,
255: attribute4 cn_srp_pay_groups.attribute4%TYPE := NULL,
256: attribute5 cn_srp_pay_groups.attribute5%TYPE := NULL,
257: attribute6 cn_srp_pay_groups.attribute6%TYPE := NULL,
258: attribute7 cn_srp_pay_groups.attribute7%TYPE := NULL,
259: attribute8 cn_srp_pay_groups.attribute8%TYPE := NULL,
260: attribute9 cn_srp_pay_groups.attribute9%TYPE := NULL,
261: attribute10 cn_srp_pay_groups.attribute10%TYPE := NULL,
254: attribute3 cn_srp_pay_groups.attribute3%TYPE := NULL,
255: attribute4 cn_srp_pay_groups.attribute4%TYPE := NULL,
256: attribute5 cn_srp_pay_groups.attribute5%TYPE := NULL,
257: attribute6 cn_srp_pay_groups.attribute6%TYPE := NULL,
258: attribute7 cn_srp_pay_groups.attribute7%TYPE := NULL,
259: attribute8 cn_srp_pay_groups.attribute8%TYPE := NULL,
260: attribute9 cn_srp_pay_groups.attribute9%TYPE := NULL,
261: attribute10 cn_srp_pay_groups.attribute10%TYPE := NULL,
262: attribute11 cn_srp_pay_groups.attribute11%TYPE := NULL,
255: attribute4 cn_srp_pay_groups.attribute4%TYPE := NULL,
256: attribute5 cn_srp_pay_groups.attribute5%TYPE := NULL,
257: attribute6 cn_srp_pay_groups.attribute6%TYPE := NULL,
258: attribute7 cn_srp_pay_groups.attribute7%TYPE := NULL,
259: attribute8 cn_srp_pay_groups.attribute8%TYPE := NULL,
260: attribute9 cn_srp_pay_groups.attribute9%TYPE := NULL,
261: attribute10 cn_srp_pay_groups.attribute10%TYPE := NULL,
262: attribute11 cn_srp_pay_groups.attribute11%TYPE := NULL,
263: attribute12 cn_srp_pay_groups.attribute12%TYPE := NULL,
256: attribute5 cn_srp_pay_groups.attribute5%TYPE := NULL,
257: attribute6 cn_srp_pay_groups.attribute6%TYPE := NULL,
258: attribute7 cn_srp_pay_groups.attribute7%TYPE := NULL,
259: attribute8 cn_srp_pay_groups.attribute8%TYPE := NULL,
260: attribute9 cn_srp_pay_groups.attribute9%TYPE := NULL,
261: attribute10 cn_srp_pay_groups.attribute10%TYPE := NULL,
262: attribute11 cn_srp_pay_groups.attribute11%TYPE := NULL,
263: attribute12 cn_srp_pay_groups.attribute12%TYPE := NULL,
264: attribute13 cn_srp_pay_groups.attribute13%TYPE := NULL,
257: attribute6 cn_srp_pay_groups.attribute6%TYPE := NULL,
258: attribute7 cn_srp_pay_groups.attribute7%TYPE := NULL,
259: attribute8 cn_srp_pay_groups.attribute8%TYPE := NULL,
260: attribute9 cn_srp_pay_groups.attribute9%TYPE := NULL,
261: attribute10 cn_srp_pay_groups.attribute10%TYPE := NULL,
262: attribute11 cn_srp_pay_groups.attribute11%TYPE := NULL,
263: attribute12 cn_srp_pay_groups.attribute12%TYPE := NULL,
264: attribute13 cn_srp_pay_groups.attribute13%TYPE := NULL,
265: attribute14 cn_srp_pay_groups.attribute14%TYPE := NULL,
258: attribute7 cn_srp_pay_groups.attribute7%TYPE := NULL,
259: attribute8 cn_srp_pay_groups.attribute8%TYPE := NULL,
260: attribute9 cn_srp_pay_groups.attribute9%TYPE := NULL,
261: attribute10 cn_srp_pay_groups.attribute10%TYPE := NULL,
262: attribute11 cn_srp_pay_groups.attribute11%TYPE := NULL,
263: attribute12 cn_srp_pay_groups.attribute12%TYPE := NULL,
264: attribute13 cn_srp_pay_groups.attribute13%TYPE := NULL,
265: attribute14 cn_srp_pay_groups.attribute14%TYPE := NULL,
266: attribute15 cn_srp_pay_groups.attribute15%TYPE := NULL );
259: attribute8 cn_srp_pay_groups.attribute8%TYPE := NULL,
260: attribute9 cn_srp_pay_groups.attribute9%TYPE := NULL,
261: attribute10 cn_srp_pay_groups.attribute10%TYPE := NULL,
262: attribute11 cn_srp_pay_groups.attribute11%TYPE := NULL,
263: attribute12 cn_srp_pay_groups.attribute12%TYPE := NULL,
264: attribute13 cn_srp_pay_groups.attribute13%TYPE := NULL,
265: attribute14 cn_srp_pay_groups.attribute14%TYPE := NULL,
266: attribute15 cn_srp_pay_groups.attribute15%TYPE := NULL );
267:
260: attribute9 cn_srp_pay_groups.attribute9%TYPE := NULL,
261: attribute10 cn_srp_pay_groups.attribute10%TYPE := NULL,
262: attribute11 cn_srp_pay_groups.attribute11%TYPE := NULL,
263: attribute12 cn_srp_pay_groups.attribute12%TYPE := NULL,
264: attribute13 cn_srp_pay_groups.attribute13%TYPE := NULL,
265: attribute14 cn_srp_pay_groups.attribute14%TYPE := NULL,
266: attribute15 cn_srp_pay_groups.attribute15%TYPE := NULL );
267:
268: END CN_PAYGROUP_PVT ;
261: attribute10 cn_srp_pay_groups.attribute10%TYPE := NULL,
262: attribute11 cn_srp_pay_groups.attribute11%TYPE := NULL,
263: attribute12 cn_srp_pay_groups.attribute12%TYPE := NULL,
264: attribute13 cn_srp_pay_groups.attribute13%TYPE := NULL,
265: attribute14 cn_srp_pay_groups.attribute14%TYPE := NULL,
266: attribute15 cn_srp_pay_groups.attribute15%TYPE := NULL );
267:
268: END CN_PAYGROUP_PVT ;
262: attribute11 cn_srp_pay_groups.attribute11%TYPE := NULL,
263: attribute12 cn_srp_pay_groups.attribute12%TYPE := NULL,
264: attribute13 cn_srp_pay_groups.attribute13%TYPE := NULL,
265: attribute14 cn_srp_pay_groups.attribute14%TYPE := NULL,
266: attribute15 cn_srp_pay_groups.attribute15%TYPE := NULL );
267:
268: END CN_PAYGROUP_PVT ;