227: --Assignment Number
228: l_assignment_number per_assignments_f.assignment_number%TYPE;
229:
230: -- Address details
231: l_address_line1 per_addresses.address_line1%TYPE;
232: l_address_line2 per_addresses.address_line2%TYPE;
233: l_address_line3 per_addresses.address_line3%TYPE;
234: l_address_line4 per_addresses.address_line3%TYPE;
235: l_town_or_city per_addresses.town_or_city%TYPE;
228: l_assignment_number per_assignments_f.assignment_number%TYPE;
229:
230: -- Address details
231: l_address_line1 per_addresses.address_line1%TYPE;
232: l_address_line2 per_addresses.address_line2%TYPE;
233: l_address_line3 per_addresses.address_line3%TYPE;
234: l_address_line4 per_addresses.address_line3%TYPE;
235: l_town_or_city per_addresses.town_or_city%TYPE;
236: l_postal_code per_addresses.postal_code%TYPE;
229:
230: -- Address details
231: l_address_line1 per_addresses.address_line1%TYPE;
232: l_address_line2 per_addresses.address_line2%TYPE;
233: l_address_line3 per_addresses.address_line3%TYPE;
234: l_address_line4 per_addresses.address_line3%TYPE;
235: l_town_or_city per_addresses.town_or_city%TYPE;
236: l_postal_code per_addresses.postal_code%TYPE;
237: l_country per_addresses.country%TYPE;
230: -- Address details
231: l_address_line1 per_addresses.address_line1%TYPE;
232: l_address_line2 per_addresses.address_line2%TYPE;
233: l_address_line3 per_addresses.address_line3%TYPE;
234: l_address_line4 per_addresses.address_line3%TYPE;
235: l_town_or_city per_addresses.town_or_city%TYPE;
236: l_postal_code per_addresses.postal_code%TYPE;
237: l_country per_addresses.country%TYPE;
238:
231: l_address_line1 per_addresses.address_line1%TYPE;
232: l_address_line2 per_addresses.address_line2%TYPE;
233: l_address_line3 per_addresses.address_line3%TYPE;
234: l_address_line4 per_addresses.address_line3%TYPE;
235: l_town_or_city per_addresses.town_or_city%TYPE;
236: l_postal_code per_addresses.postal_code%TYPE;
237: l_country per_addresses.country%TYPE;
238:
239: -- Person details
232: l_address_line2 per_addresses.address_line2%TYPE;
233: l_address_line3 per_addresses.address_line3%TYPE;
234: l_address_line4 per_addresses.address_line3%TYPE;
235: l_town_or_city per_addresses.town_or_city%TYPE;
236: l_postal_code per_addresses.postal_code%TYPE;
237: l_country per_addresses.country%TYPE;
238:
239: -- Person details
240: l_last_name per_people_f.last_name%TYPE;
233: l_address_line3 per_addresses.address_line3%TYPE;
234: l_address_line4 per_addresses.address_line3%TYPE;
235: l_town_or_city per_addresses.town_or_city%TYPE;
236: l_postal_code per_addresses.postal_code%TYPE;
237: l_country per_addresses.country%TYPE;
238:
239: -- Person details
240: l_last_name per_people_f.last_name%TYPE;
241: l_first_name per_people_f.first_name%TYPE;
499: --Assignment Number
500: l_assignment_number per_assignments_f.assignment_number%TYPE;
501:
502: -- Address details
503: l_address_line1 per_addresses.address_line1%TYPE;
504: l_address_line2 per_addresses.address_line2%TYPE;
505: l_address_line3 per_addresses.address_line3%TYPE;
506: l_address_line4 per_addresses.address_line3%TYPE;
507: l_town_or_city per_addresses.town_or_city%TYPE;
500: l_assignment_number per_assignments_f.assignment_number%TYPE;
501:
502: -- Address details
503: l_address_line1 per_addresses.address_line1%TYPE;
504: l_address_line2 per_addresses.address_line2%TYPE;
505: l_address_line3 per_addresses.address_line3%TYPE;
506: l_address_line4 per_addresses.address_line3%TYPE;
507: l_town_or_city per_addresses.town_or_city%TYPE;
508: l_postal_code per_addresses.postal_code%TYPE;
501:
502: -- Address details
503: l_address_line1 per_addresses.address_line1%TYPE;
504: l_address_line2 per_addresses.address_line2%TYPE;
505: l_address_line3 per_addresses.address_line3%TYPE;
506: l_address_line4 per_addresses.address_line3%TYPE;
507: l_town_or_city per_addresses.town_or_city%TYPE;
508: l_postal_code per_addresses.postal_code%TYPE;
509: l_country per_addresses.country%TYPE;
502: -- Address details
503: l_address_line1 per_addresses.address_line1%TYPE;
504: l_address_line2 per_addresses.address_line2%TYPE;
505: l_address_line3 per_addresses.address_line3%TYPE;
506: l_address_line4 per_addresses.address_line3%TYPE;
507: l_town_or_city per_addresses.town_or_city%TYPE;
508: l_postal_code per_addresses.postal_code%TYPE;
509: l_country per_addresses.country%TYPE;
510:
503: l_address_line1 per_addresses.address_line1%TYPE;
504: l_address_line2 per_addresses.address_line2%TYPE;
505: l_address_line3 per_addresses.address_line3%TYPE;
506: l_address_line4 per_addresses.address_line3%TYPE;
507: l_town_or_city per_addresses.town_or_city%TYPE;
508: l_postal_code per_addresses.postal_code%TYPE;
509: l_country per_addresses.country%TYPE;
510:
511: -- Person details
504: l_address_line2 per_addresses.address_line2%TYPE;
505: l_address_line3 per_addresses.address_line3%TYPE;
506: l_address_line4 per_addresses.address_line3%TYPE;
507: l_town_or_city per_addresses.town_or_city%TYPE;
508: l_postal_code per_addresses.postal_code%TYPE;
509: l_country per_addresses.country%TYPE;
510:
511: -- Person details
512: l_last_name per_people_f.last_name%TYPE;
505: l_address_line3 per_addresses.address_line3%TYPE;
506: l_address_line4 per_addresses.address_line3%TYPE;
507: l_town_or_city per_addresses.town_or_city%TYPE;
508: l_postal_code per_addresses.postal_code%TYPE;
509: l_country per_addresses.country%TYPE;
510:
511: -- Person details
512: l_last_name per_people_f.last_name%TYPE;
513: l_first_name per_people_f.first_name%TYPE;