1515: l_FraisGarde NUMBER;
1516: l_DeductionForce NUMBER;
1517:
1518: l_person_id per_people_f.person_id%TYPE;
1519: l_address_line1 per_addresses.address_line1%TYPE;
1520: l_address_line2 per_addresses.address_line2%TYPE;
1521: l_address_line3 per_addresses.address_line3%TYPE;
1522: l_combined_addr VARCHAR2(500);
1523: l_city per_addresses.town_or_city%TYPE;
1516: l_DeductionForce NUMBER;
1517:
1518: l_person_id per_people_f.person_id%TYPE;
1519: l_address_line1 per_addresses.address_line1%TYPE;
1520: l_address_line2 per_addresses.address_line2%TYPE;
1521: l_address_line3 per_addresses.address_line3%TYPE;
1522: l_combined_addr VARCHAR2(500);
1523: l_city per_addresses.town_or_city%TYPE;
1524: l_postal_code per_addresses.postal_code%TYPE;
1517:
1518: l_person_id per_people_f.person_id%TYPE;
1519: l_address_line1 per_addresses.address_line1%TYPE;
1520: l_address_line2 per_addresses.address_line2%TYPE;
1521: l_address_line3 per_addresses.address_line3%TYPE;
1522: l_combined_addr VARCHAR2(500);
1523: l_city per_addresses.town_or_city%TYPE;
1524: l_postal_code per_addresses.postal_code%TYPE;
1525: l_country VARCHAR2(60);
1519: l_address_line1 per_addresses.address_line1%TYPE;
1520: l_address_line2 per_addresses.address_line2%TYPE;
1521: l_address_line3 per_addresses.address_line3%TYPE;
1522: l_combined_addr VARCHAR2(500);
1523: l_city per_addresses.town_or_city%TYPE;
1524: l_postal_code per_addresses.postal_code%TYPE;
1525: l_country VARCHAR2(60);
1526: l_emp_province per_addresses.region_1%TYPE;
1527: EOL VARCHAR2(5);
1520: l_address_line2 per_addresses.address_line2%TYPE;
1521: l_address_line3 per_addresses.address_line3%TYPE;
1522: l_combined_addr VARCHAR2(500);
1523: l_city per_addresses.town_or_city%TYPE;
1524: l_postal_code per_addresses.postal_code%TYPE;
1525: l_country VARCHAR2(60);
1526: l_emp_province per_addresses.region_1%TYPE;
1527: EOL VARCHAR2(5);
1528: l_taxation_year VARCHAR2(5);
1522: l_combined_addr VARCHAR2(500);
1523: l_city per_addresses.town_or_city%TYPE;
1524: l_postal_code per_addresses.postal_code%TYPE;
1525: l_country VARCHAR2(60);
1526: l_emp_province per_addresses.region_1%TYPE;
1527: EOL VARCHAR2(5);
1528: l_taxation_year VARCHAR2(5);
1529: l_name VARCHAR2(200);
1530: l_box VARCHAR2(20);