[Home] [Help]
147: hlc.address_line_2 address_line2,
148: hlc.address_line_3 address_line3,
149: hlc.postal_code postcode,
150: hlc.town_or_city city,
151: pay_nl_general.get_country_name(hlc.country) country,
152: hlc.style add_style
153: from hr_locations hlc,
154: hr_organization_units hou
155: where hou.business_group_id = p_bg_id
164: pad.address_line2 address_line2,
165: pad.address_line3 address_line3,
166: pad.postal_code postcode,
167: pad.town_or_city city,
168: pay_nl_general.get_country_name(pad.country) country,
169: pad.style add_style
170: from per_addresses pad
171: where pad.person_id = p_person_id
172: and p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time)
352: CLOSE csr_org_glb_address;
353:
354: IF l_add_style_er = 'NL' THEN
355:
356: l_return_value := pay_nl_general.get_org_address(p_employer_id
357: ,p_bg_id
358: ,l_house_number_er
359: ,l_house_add_no_er
360: ,l_street_name_er
478: CLOSE csr_org_glb_address;
479:
480: IF l_add_style_er = 'NL' THEN
481:
482: l_return_value := pay_nl_general.get_org_address(l_leg_emp_id
483: ,p_bg_id
484: ,l_house_number_er
485: ,l_house_add_no_er
486: ,l_street_name_er
547: CLOSE csr_org_glb_address;
548:
549: IF l_add_style_er = 'NL' THEN
550:
551: l_return_value := pay_nl_general.get_org_address(p_employer_id
552: ,p_bg_id
553: ,l_house_number_er
554: ,l_house_add_no_er
555: ,l_street_name_er
878: CLOSE csr_emp_glb_address;
879:
880: IF l_add_style_ee = 'NL' THEN
881:
882: l_return_value1 := pay_nl_general.get_emp_address(l_person_id
883: ,fnd_date.canonical_to_date(p_year)
884: ,l_house_number_ee
885: ,l_house_add_no_ee
886: ,l_street_name_ee
1239: CLOSE csr_emp_glb_address;
1240:
1241: IF l_add_style_ee = 'NL' THEN
1242:
1243: l_return_value1 := pay_nl_general.get_emp_address(l_person_id
1244: ,fnd_date.canonical_to_date(p_year)
1245: ,l_house_number_ee
1246: ,l_house_add_no_ee
1247: ,l_street_name_ee
1775: hlc.address_line_2 address_line2,
1776: hlc.address_line_3 address_line3,
1777: hlc.postal_code postcode,
1778: hlc.town_or_city city,
1779: pay_nl_general.get_country_name(hlc.country) country,
1780: hlc.style add_style
1781: from hr_locations hlc,
1782: hr_organization_units hou
1783: where hou.business_group_id = p_bg_id
1792: pad.address_line2 address_line2,
1793: pad.address_line3 address_line3,
1794: pad.postal_code postcode,
1795: pad.town_or_city city,
1796: pay_nl_general.get_country_name(pad.country) country,
1797: pad.style add_style
1798: from per_addresses pad
1799: where pad.person_id = p_person_id
1800: and p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time)
1980: CLOSE csr_org_glb_address;
1981:
1982: IF l_add_style_er = 'NL' THEN
1983:
1984: l_return_value := pay_nl_general.get_org_address(p_employer_id
1985: ,p_bg_id
1986: ,l_house_number_er
1987: ,l_house_add_no_er
1988: ,l_street_name_er
2106: CLOSE csr_org_glb_address;
2107:
2108: IF l_add_style_er = 'NL' THEN
2109:
2110: l_return_value := pay_nl_general.get_org_address(l_leg_emp_id
2111: ,p_bg_id
2112: ,l_house_number_er
2113: ,l_house_add_no_er
2114: ,l_street_name_er
2175: CLOSE csr_org_glb_address;
2176:
2177: IF l_add_style_er = 'NL' THEN
2178:
2179: l_return_value := pay_nl_general.get_org_address(p_employer_id
2180: ,p_bg_id
2181: ,l_house_number_er
2182: ,l_house_add_no_er
2183: ,l_street_name_er
2506: CLOSE csr_emp_glb_address;
2507:
2508: IF l_add_style_ee = 'NL' THEN
2509:
2510: l_return_value1 := pay_nl_general.get_emp_address(l_person_id
2511: ,fnd_date.canonical_to_date(p_year)
2512: ,l_house_number_ee
2513: ,l_house_add_no_ee
2514: ,l_street_name_ee
2867: CLOSE csr_emp_glb_address;
2868:
2869: IF l_add_style_ee = 'NL' THEN
2870:
2871: l_return_value1 := pay_nl_general.get_emp_address(l_person_id
2872: ,fnd_date.canonical_to_date(p_year)
2873: ,l_house_number_ee
2874: ,l_house_add_no_ee
2875: ,l_street_name_ee