DBA Data[Home] [Help]

APPS.PAY_CA_RL1_MAG dependencies on PER_ADDRESSES

Line 1656: l_address_line1 per_addresses.address_line1%TYPE;

1652: l_FraisGarde NUMBER;
1653: l_DeductionForce NUMBER;
1654:
1655: l_person_id per_people_f.person_id%TYPE;
1656: l_address_line1 per_addresses.address_line1%TYPE;
1657: l_address_line2 per_addresses.address_line2%TYPE;
1658: l_address_line3 per_addresses.address_line3%TYPE;
1659: l_combined_addr VARCHAR2(500);
1660: l_city per_addresses.town_or_city%TYPE;

Line 1657: l_address_line2 per_addresses.address_line2%TYPE;

1653: l_DeductionForce NUMBER;
1654:
1655: l_person_id per_people_f.person_id%TYPE;
1656: l_address_line1 per_addresses.address_line1%TYPE;
1657: l_address_line2 per_addresses.address_line2%TYPE;
1658: l_address_line3 per_addresses.address_line3%TYPE;
1659: l_combined_addr VARCHAR2(500);
1660: l_city per_addresses.town_or_city%TYPE;
1661: l_postal_code per_addresses.postal_code%TYPE;

Line 1658: l_address_line3 per_addresses.address_line3%TYPE;

1654:
1655: l_person_id per_people_f.person_id%TYPE;
1656: l_address_line1 per_addresses.address_line1%TYPE;
1657: l_address_line2 per_addresses.address_line2%TYPE;
1658: l_address_line3 per_addresses.address_line3%TYPE;
1659: l_combined_addr VARCHAR2(500);
1660: l_city per_addresses.town_or_city%TYPE;
1661: l_postal_code per_addresses.postal_code%TYPE;
1662: l_country VARCHAR2(60);

Line 1660: l_city per_addresses.town_or_city%TYPE;

1656: l_address_line1 per_addresses.address_line1%TYPE;
1657: l_address_line2 per_addresses.address_line2%TYPE;
1658: l_address_line3 per_addresses.address_line3%TYPE;
1659: l_combined_addr VARCHAR2(500);
1660: l_city per_addresses.town_or_city%TYPE;
1661: l_postal_code per_addresses.postal_code%TYPE;
1662: l_country VARCHAR2(60);
1663: l_emp_province per_addresses.region_1%TYPE;
1664: EOL VARCHAR2(5);

Line 1661: l_postal_code per_addresses.postal_code%TYPE;

1657: l_address_line2 per_addresses.address_line2%TYPE;
1658: l_address_line3 per_addresses.address_line3%TYPE;
1659: l_combined_addr VARCHAR2(500);
1660: l_city per_addresses.town_or_city%TYPE;
1661: l_postal_code per_addresses.postal_code%TYPE;
1662: l_country VARCHAR2(60);
1663: l_emp_province per_addresses.region_1%TYPE;
1664: EOL VARCHAR2(5);
1665: l_name VARCHAR2(200);

Line 1663: l_emp_province per_addresses.region_1%TYPE;

1659: l_combined_addr VARCHAR2(500);
1660: l_city per_addresses.town_or_city%TYPE;
1661: l_postal_code per_addresses.postal_code%TYPE;
1662: l_country VARCHAR2(60);
1663: l_emp_province per_addresses.region_1%TYPE;
1664: EOL VARCHAR2(5);
1665: l_name VARCHAR2(200);
1666: l_box VARCHAR2(20);
1667: l_boxA VARCHAR2(20);