295:
296: TYPE PayGroup_assign_rec IS RECORD
297: ( employee_type cn_salesreps.type%TYPE,
298: employee_number cn_salesreps.employee_number%TYPE,
299: assignment_start_date cn_srp_pay_groups.start_date%TYPE,
300: assignment_end_date cn_srp_pay_groups.end_date%TYPE,
301: attribute_category cn_srp_pay_groups.attribute_category%TYPE := NULL,
302: attribute1 cn_srp_pay_groups.attribute1%TYPE := NULL,
303: attribute2 cn_srp_pay_groups.attribute2%TYPE := NULL,
296: TYPE PayGroup_assign_rec IS RECORD
297: ( employee_type cn_salesreps.type%TYPE,
298: employee_number cn_salesreps.employee_number%TYPE,
299: assignment_start_date cn_srp_pay_groups.start_date%TYPE,
300: assignment_end_date cn_srp_pay_groups.end_date%TYPE,
301: attribute_category cn_srp_pay_groups.attribute_category%TYPE := NULL,
302: attribute1 cn_srp_pay_groups.attribute1%TYPE := NULL,
303: attribute2 cn_srp_pay_groups.attribute2%TYPE := NULL,
304: attribute3 cn_srp_pay_groups.attribute3%TYPE := NULL,
297: ( employee_type cn_salesreps.type%TYPE,
298: employee_number cn_salesreps.employee_number%TYPE,
299: assignment_start_date cn_srp_pay_groups.start_date%TYPE,
300: assignment_end_date cn_srp_pay_groups.end_date%TYPE,
301: attribute_category cn_srp_pay_groups.attribute_category%TYPE := NULL,
302: attribute1 cn_srp_pay_groups.attribute1%TYPE := NULL,
303: attribute2 cn_srp_pay_groups.attribute2%TYPE := NULL,
304: attribute3 cn_srp_pay_groups.attribute3%TYPE := NULL,
305: attribute4 cn_srp_pay_groups.attribute4%TYPE := NULL,
298: employee_number cn_salesreps.employee_number%TYPE,
299: assignment_start_date cn_srp_pay_groups.start_date%TYPE,
300: assignment_end_date cn_srp_pay_groups.end_date%TYPE,
301: attribute_category cn_srp_pay_groups.attribute_category%TYPE := NULL,
302: attribute1 cn_srp_pay_groups.attribute1%TYPE := NULL,
303: attribute2 cn_srp_pay_groups.attribute2%TYPE := NULL,
304: attribute3 cn_srp_pay_groups.attribute3%TYPE := NULL,
305: attribute4 cn_srp_pay_groups.attribute4%TYPE := NULL,
306: attribute5 cn_srp_pay_groups.attribute5%TYPE := NULL,
299: assignment_start_date cn_srp_pay_groups.start_date%TYPE,
300: assignment_end_date cn_srp_pay_groups.end_date%TYPE,
301: attribute_category cn_srp_pay_groups.attribute_category%TYPE := NULL,
302: attribute1 cn_srp_pay_groups.attribute1%TYPE := NULL,
303: attribute2 cn_srp_pay_groups.attribute2%TYPE := NULL,
304: attribute3 cn_srp_pay_groups.attribute3%TYPE := NULL,
305: attribute4 cn_srp_pay_groups.attribute4%TYPE := NULL,
306: attribute5 cn_srp_pay_groups.attribute5%TYPE := NULL,
307: attribute6 cn_srp_pay_groups.attribute6%TYPE := NULL,
300: assignment_end_date cn_srp_pay_groups.end_date%TYPE,
301: attribute_category cn_srp_pay_groups.attribute_category%TYPE := NULL,
302: attribute1 cn_srp_pay_groups.attribute1%TYPE := NULL,
303: attribute2 cn_srp_pay_groups.attribute2%TYPE := NULL,
304: attribute3 cn_srp_pay_groups.attribute3%TYPE := NULL,
305: attribute4 cn_srp_pay_groups.attribute4%TYPE := NULL,
306: attribute5 cn_srp_pay_groups.attribute5%TYPE := NULL,
307: attribute6 cn_srp_pay_groups.attribute6%TYPE := NULL,
308: attribute7 cn_srp_pay_groups.attribute7%TYPE := NULL,
301: attribute_category cn_srp_pay_groups.attribute_category%TYPE := NULL,
302: attribute1 cn_srp_pay_groups.attribute1%TYPE := NULL,
303: attribute2 cn_srp_pay_groups.attribute2%TYPE := NULL,
304: attribute3 cn_srp_pay_groups.attribute3%TYPE := NULL,
305: attribute4 cn_srp_pay_groups.attribute4%TYPE := NULL,
306: attribute5 cn_srp_pay_groups.attribute5%TYPE := NULL,
307: attribute6 cn_srp_pay_groups.attribute6%TYPE := NULL,
308: attribute7 cn_srp_pay_groups.attribute7%TYPE := NULL,
309: attribute8 cn_srp_pay_groups.attribute8%TYPE := NULL,
302: attribute1 cn_srp_pay_groups.attribute1%TYPE := NULL,
303: attribute2 cn_srp_pay_groups.attribute2%TYPE := NULL,
304: attribute3 cn_srp_pay_groups.attribute3%TYPE := NULL,
305: attribute4 cn_srp_pay_groups.attribute4%TYPE := NULL,
306: attribute5 cn_srp_pay_groups.attribute5%TYPE := NULL,
307: attribute6 cn_srp_pay_groups.attribute6%TYPE := NULL,
308: attribute7 cn_srp_pay_groups.attribute7%TYPE := NULL,
309: attribute8 cn_srp_pay_groups.attribute8%TYPE := NULL,
310: attribute9 cn_srp_pay_groups.attribute9%TYPE := NULL,
303: attribute2 cn_srp_pay_groups.attribute2%TYPE := NULL,
304: attribute3 cn_srp_pay_groups.attribute3%TYPE := NULL,
305: attribute4 cn_srp_pay_groups.attribute4%TYPE := NULL,
306: attribute5 cn_srp_pay_groups.attribute5%TYPE := NULL,
307: attribute6 cn_srp_pay_groups.attribute6%TYPE := NULL,
308: attribute7 cn_srp_pay_groups.attribute7%TYPE := NULL,
309: attribute8 cn_srp_pay_groups.attribute8%TYPE := NULL,
310: attribute9 cn_srp_pay_groups.attribute9%TYPE := NULL,
311: attribute10 cn_srp_pay_groups.attribute10%TYPE := NULL,
304: attribute3 cn_srp_pay_groups.attribute3%TYPE := NULL,
305: attribute4 cn_srp_pay_groups.attribute4%TYPE := NULL,
306: attribute5 cn_srp_pay_groups.attribute5%TYPE := NULL,
307: attribute6 cn_srp_pay_groups.attribute6%TYPE := NULL,
308: attribute7 cn_srp_pay_groups.attribute7%TYPE := NULL,
309: attribute8 cn_srp_pay_groups.attribute8%TYPE := NULL,
310: attribute9 cn_srp_pay_groups.attribute9%TYPE := NULL,
311: attribute10 cn_srp_pay_groups.attribute10%TYPE := NULL,
312: attribute11 cn_srp_pay_groups.attribute11%TYPE := NULL,
305: attribute4 cn_srp_pay_groups.attribute4%TYPE := NULL,
306: attribute5 cn_srp_pay_groups.attribute5%TYPE := NULL,
307: attribute6 cn_srp_pay_groups.attribute6%TYPE := NULL,
308: attribute7 cn_srp_pay_groups.attribute7%TYPE := NULL,
309: attribute8 cn_srp_pay_groups.attribute8%TYPE := NULL,
310: attribute9 cn_srp_pay_groups.attribute9%TYPE := NULL,
311: attribute10 cn_srp_pay_groups.attribute10%TYPE := NULL,
312: attribute11 cn_srp_pay_groups.attribute11%TYPE := NULL,
313: attribute12 cn_srp_pay_groups.attribute12%TYPE := NULL,
306: attribute5 cn_srp_pay_groups.attribute5%TYPE := NULL,
307: attribute6 cn_srp_pay_groups.attribute6%TYPE := NULL,
308: attribute7 cn_srp_pay_groups.attribute7%TYPE := NULL,
309: attribute8 cn_srp_pay_groups.attribute8%TYPE := NULL,
310: attribute9 cn_srp_pay_groups.attribute9%TYPE := NULL,
311: attribute10 cn_srp_pay_groups.attribute10%TYPE := NULL,
312: attribute11 cn_srp_pay_groups.attribute11%TYPE := NULL,
313: attribute12 cn_srp_pay_groups.attribute12%TYPE := NULL,
314: attribute13 cn_srp_pay_groups.attribute13%TYPE := NULL,
307: attribute6 cn_srp_pay_groups.attribute6%TYPE := NULL,
308: attribute7 cn_srp_pay_groups.attribute7%TYPE := NULL,
309: attribute8 cn_srp_pay_groups.attribute8%TYPE := NULL,
310: attribute9 cn_srp_pay_groups.attribute9%TYPE := NULL,
311: attribute10 cn_srp_pay_groups.attribute10%TYPE := NULL,
312: attribute11 cn_srp_pay_groups.attribute11%TYPE := NULL,
313: attribute12 cn_srp_pay_groups.attribute12%TYPE := NULL,
314: attribute13 cn_srp_pay_groups.attribute13%TYPE := NULL,
315: attribute14 cn_srp_pay_groups.attribute14%TYPE := NULL,
308: attribute7 cn_srp_pay_groups.attribute7%TYPE := NULL,
309: attribute8 cn_srp_pay_groups.attribute8%TYPE := NULL,
310: attribute9 cn_srp_pay_groups.attribute9%TYPE := NULL,
311: attribute10 cn_srp_pay_groups.attribute10%TYPE := NULL,
312: attribute11 cn_srp_pay_groups.attribute11%TYPE := NULL,
313: attribute12 cn_srp_pay_groups.attribute12%TYPE := NULL,
314: attribute13 cn_srp_pay_groups.attribute13%TYPE := NULL,
315: attribute14 cn_srp_pay_groups.attribute14%TYPE := NULL,
316: attribute15 cn_srp_pay_groups.attribute15%TYPE := NULL );
309: attribute8 cn_srp_pay_groups.attribute8%TYPE := NULL,
310: attribute9 cn_srp_pay_groups.attribute9%TYPE := NULL,
311: attribute10 cn_srp_pay_groups.attribute10%TYPE := NULL,
312: attribute11 cn_srp_pay_groups.attribute11%TYPE := NULL,
313: attribute12 cn_srp_pay_groups.attribute12%TYPE := NULL,
314: attribute13 cn_srp_pay_groups.attribute13%TYPE := NULL,
315: attribute14 cn_srp_pay_groups.attribute14%TYPE := NULL,
316: attribute15 cn_srp_pay_groups.attribute15%TYPE := NULL );
317:
310: attribute9 cn_srp_pay_groups.attribute9%TYPE := NULL,
311: attribute10 cn_srp_pay_groups.attribute10%TYPE := NULL,
312: attribute11 cn_srp_pay_groups.attribute11%TYPE := NULL,
313: attribute12 cn_srp_pay_groups.attribute12%TYPE := NULL,
314: attribute13 cn_srp_pay_groups.attribute13%TYPE := NULL,
315: attribute14 cn_srp_pay_groups.attribute14%TYPE := NULL,
316: attribute15 cn_srp_pay_groups.attribute15%TYPE := NULL );
317:
318: END CN_PAYGROUP_PUB ;
311: attribute10 cn_srp_pay_groups.attribute10%TYPE := NULL,
312: attribute11 cn_srp_pay_groups.attribute11%TYPE := NULL,
313: attribute12 cn_srp_pay_groups.attribute12%TYPE := NULL,
314: attribute13 cn_srp_pay_groups.attribute13%TYPE := NULL,
315: attribute14 cn_srp_pay_groups.attribute14%TYPE := NULL,
316: attribute15 cn_srp_pay_groups.attribute15%TYPE := NULL );
317:
318: END CN_PAYGROUP_PUB ;
312: attribute11 cn_srp_pay_groups.attribute11%TYPE := NULL,
313: attribute12 cn_srp_pay_groups.attribute12%TYPE := NULL,
314: attribute13 cn_srp_pay_groups.attribute13%TYPE := NULL,
315: attribute14 cn_srp_pay_groups.attribute14%TYPE := NULL,
316: attribute15 cn_srp_pay_groups.attribute15%TYPE := NULL );
317:
318: END CN_PAYGROUP_PUB ;