DBA Data[Home] [Help]

APPS.PAY_CA_T4_CANCEL_MAG dependencies on PER_ADDRESSES

Line 1158: l_address_line1 per_addresses.address_line1%TYPE;

1154: l_arch_report_type pay_payroll_actions.report_type%TYPE;
1155: -- l_asg_id NUMBER;
1156: l_neg_bal_exists BOOLEAN := FALSE;
1157: l_person_id per_people_f.person_id%TYPE;
1158: l_address_line1 per_addresses.address_line1%TYPE;
1159: l_address_line2 per_addresses.address_line2%TYPE;
1160: l_address_line3 per_addresses.address_line3%TYPE;
1161: l_city per_addresses.town_or_city%TYPE;
1162: l_postal_code per_addresses.postal_code%TYPE;

Line 1159: l_address_line2 per_addresses.address_line2%TYPE;

1155: -- l_asg_id NUMBER;
1156: l_neg_bal_exists BOOLEAN := FALSE;
1157: l_person_id per_people_f.person_id%TYPE;
1158: l_address_line1 per_addresses.address_line1%TYPE;
1159: l_address_line2 per_addresses.address_line2%TYPE;
1160: l_address_line3 per_addresses.address_line3%TYPE;
1161: l_city per_addresses.town_or_city%TYPE;
1162: l_postal_code per_addresses.postal_code%TYPE;
1163: l_country VARCHAR2(60);

Line 1160: l_address_line3 per_addresses.address_line3%TYPE;

1156: l_neg_bal_exists BOOLEAN := FALSE;
1157: l_person_id per_people_f.person_id%TYPE;
1158: l_address_line1 per_addresses.address_line1%TYPE;
1159: l_address_line2 per_addresses.address_line2%TYPE;
1160: l_address_line3 per_addresses.address_line3%TYPE;
1161: l_city per_addresses.town_or_city%TYPE;
1162: l_postal_code per_addresses.postal_code%TYPE;
1163: l_country VARCHAR2(60);
1164: l_emp_province per_addresses.region_1%TYPE;

Line 1161: l_city per_addresses.town_or_city%TYPE;

1157: l_person_id per_people_f.person_id%TYPE;
1158: l_address_line1 per_addresses.address_line1%TYPE;
1159: l_address_line2 per_addresses.address_line2%TYPE;
1160: l_address_line3 per_addresses.address_line3%TYPE;
1161: l_city per_addresses.town_or_city%TYPE;
1162: l_postal_code per_addresses.postal_code%TYPE;
1163: l_country VARCHAR2(60);
1164: l_emp_province per_addresses.region_1%TYPE;
1165:

Line 1162: l_postal_code per_addresses.postal_code%TYPE;

1158: l_address_line1 per_addresses.address_line1%TYPE;
1159: l_address_line2 per_addresses.address_line2%TYPE;
1160: l_address_line3 per_addresses.address_line3%TYPE;
1161: l_city per_addresses.town_or_city%TYPE;
1162: l_postal_code per_addresses.postal_code%TYPE;
1163: l_country VARCHAR2(60);
1164: l_emp_province per_addresses.region_1%TYPE;
1165:
1166: l_return ff_archive_items.value%TYPE;

Line 1164: l_emp_province per_addresses.region_1%TYPE;

1160: l_address_line3 per_addresses.address_line3%TYPE;
1161: l_city per_addresses.town_or_city%TYPE;
1162: l_postal_code per_addresses.postal_code%TYPE;
1163: l_country VARCHAR2(60);
1164: l_emp_province per_addresses.region_1%TYPE;
1165:
1166: l_return ff_archive_items.value%TYPE;
1167: l_return1 ff_archive_items.value%TYPE;
1168: l_return2 ff_archive_items.value%TYPE;