DBA Data[Home] [Help]

APPS.PAY_NZ_EDF dependencies on PER_ADDRESSES

Line 226: l_addr1 per_addresses.address_line1%TYPE;

222: PROCEDURE generate_detail_xml
223: IS
224:
225: l_proc_name VARCHAR2 (100) := g_proc_name ||'generate_detail_xml';
226: l_addr1 per_addresses.address_line1%TYPE;
227: l_addr2 per_addresses.address_line2%TYPE;
228: l_addr3 per_addresses.address_line3%TYPE;
229: l_country per_addresses.country%TYPE;
230: l_city per_addresses.town_or_city%TYPE;

Line 227: l_addr2 per_addresses.address_line2%TYPE;

223: IS
224:
225: l_proc_name VARCHAR2 (100) := g_proc_name ||'generate_detail_xml';
226: l_addr1 per_addresses.address_line1%TYPE;
227: l_addr2 per_addresses.address_line2%TYPE;
228: l_addr3 per_addresses.address_line3%TYPE;
229: l_country per_addresses.country%TYPE;
230: l_city per_addresses.town_or_city%TYPE;
231: l_postal_code per_addresses.postal_code%TYPE;

Line 228: l_addr3 per_addresses.address_line3%TYPE;

224:
225: l_proc_name VARCHAR2 (100) := g_proc_name ||'generate_detail_xml';
226: l_addr1 per_addresses.address_line1%TYPE;
227: l_addr2 per_addresses.address_line2%TYPE;
228: l_addr3 per_addresses.address_line3%TYPE;
229: l_country per_addresses.country%TYPE;
230: l_city per_addresses.town_or_city%TYPE;
231: l_postal_code per_addresses.postal_code%TYPE;
232: l_er_name hr_organization_units.name%TYPE;

Line 229: l_country per_addresses.country%TYPE;

225: l_proc_name VARCHAR2 (100) := g_proc_name ||'generate_detail_xml';
226: l_addr1 per_addresses.address_line1%TYPE;
227: l_addr2 per_addresses.address_line2%TYPE;
228: l_addr3 per_addresses.address_line3%TYPE;
229: l_country per_addresses.country%TYPE;
230: l_city per_addresses.town_or_city%TYPE;
231: l_postal_code per_addresses.postal_code%TYPE;
232: l_er_name hr_organization_units.name%TYPE;
233: l_er_ird_number hr_organization_information.org_information1%TYPE;

Line 230: l_city per_addresses.town_or_city%TYPE;

226: l_addr1 per_addresses.address_line1%TYPE;
227: l_addr2 per_addresses.address_line2%TYPE;
228: l_addr3 per_addresses.address_line3%TYPE;
229: l_country per_addresses.country%TYPE;
230: l_city per_addresses.town_or_city%TYPE;
231: l_postal_code per_addresses.postal_code%TYPE;
232: l_er_name hr_organization_units.name%TYPE;
233: l_er_ird_number hr_organization_information.org_information1%TYPE;
234: l_paye_ded pay_run_result_values.result_value%TYPE;

Line 231: l_postal_code per_addresses.postal_code%TYPE;

227: l_addr2 per_addresses.address_line2%TYPE;
228: l_addr3 per_addresses.address_line3%TYPE;
229: l_country per_addresses.country%TYPE;
230: l_city per_addresses.town_or_city%TYPE;
231: l_postal_code per_addresses.postal_code%TYPE;
232: l_er_name hr_organization_units.name%TYPE;
233: l_er_ird_number hr_organization_information.org_information1%TYPE;
234: l_paye_ded pay_run_result_values.result_value%TYPE;
235: l_child_support_ded pay_run_result_values.result_value%TYPE;