DBA Data[Home] [Help]

APPS.PAY_CA_T4_AMEND_MAG dependencies on PER_ADDRESSES

Line 1212: l_address_line1 per_addresses.address_line1%TYPE;

1208: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1209: -- l_asg_id NUMBER;
1210: l_neg_bal_exists BOOLEAN := FALSE;
1211: l_person_id per_people_f.person_id%TYPE;
1212: l_address_line1 per_addresses.address_line1%TYPE;
1213: l_address_line2 per_addresses.address_line2%TYPE;
1214: l_address_line3 per_addresses.address_line3%TYPE;
1215: l_city per_addresses.town_or_city%TYPE;
1216: l_postal_code per_addresses.postal_code%TYPE;

Line 1213: l_address_line2 per_addresses.address_line2%TYPE;

1209: -- l_asg_id NUMBER;
1210: l_neg_bal_exists BOOLEAN := FALSE;
1211: l_person_id per_people_f.person_id%TYPE;
1212: l_address_line1 per_addresses.address_line1%TYPE;
1213: l_address_line2 per_addresses.address_line2%TYPE;
1214: l_address_line3 per_addresses.address_line3%TYPE;
1215: l_city per_addresses.town_or_city%TYPE;
1216: l_postal_code per_addresses.postal_code%TYPE;
1217: l_country VARCHAR2(60);

Line 1214: l_address_line3 per_addresses.address_line3%TYPE;

1210: l_neg_bal_exists BOOLEAN := FALSE;
1211: l_person_id per_people_f.person_id%TYPE;
1212: l_address_line1 per_addresses.address_line1%TYPE;
1213: l_address_line2 per_addresses.address_line2%TYPE;
1214: l_address_line3 per_addresses.address_line3%TYPE;
1215: l_city per_addresses.town_or_city%TYPE;
1216: l_postal_code per_addresses.postal_code%TYPE;
1217: l_country VARCHAR2(60);
1218: l_emp_province per_addresses.region_1%TYPE;

Line 1215: l_city per_addresses.town_or_city%TYPE;

1211: l_person_id per_people_f.person_id%TYPE;
1212: l_address_line1 per_addresses.address_line1%TYPE;
1213: l_address_line2 per_addresses.address_line2%TYPE;
1214: l_address_line3 per_addresses.address_line3%TYPE;
1215: l_city per_addresses.town_or_city%TYPE;
1216: l_postal_code per_addresses.postal_code%TYPE;
1217: l_country VARCHAR2(60);
1218: l_emp_province per_addresses.region_1%TYPE;
1219:

Line 1216: l_postal_code per_addresses.postal_code%TYPE;

1212: l_address_line1 per_addresses.address_line1%TYPE;
1213: l_address_line2 per_addresses.address_line2%TYPE;
1214: l_address_line3 per_addresses.address_line3%TYPE;
1215: l_city per_addresses.town_or_city%TYPE;
1216: l_postal_code per_addresses.postal_code%TYPE;
1217: l_country VARCHAR2(60);
1218: l_emp_province per_addresses.region_1%TYPE;
1219:
1220: l_return ff_archive_items.value%TYPE;

Line 1218: l_emp_province per_addresses.region_1%TYPE;

1214: l_address_line3 per_addresses.address_line3%TYPE;
1215: l_city per_addresses.town_or_city%TYPE;
1216: l_postal_code per_addresses.postal_code%TYPE;
1217: l_country VARCHAR2(60);
1218: l_emp_province per_addresses.region_1%TYPE;
1219:
1220: l_return ff_archive_items.value%TYPE;
1221: l_return1 ff_archive_items.value%TYPE;
1222: l_return2 ff_archive_items.value%TYPE;