[Home] [Help]
131: hlc.address_line_2 address_line2,
132: hlc.address_line_3 address_line3,
133: hlc.postal_code postcode,
134: hlc.town_or_city city,
135: pay_nl_general.get_country_name(hlc.country) country,
136: hlc.style add_style
137: from hr_locations hlc,
138: hr_organization_units hou
139: where hou.business_group_id = p_bg_id
148: pad.address_line2 address_line2,
149: pad.address_line3 address_line3,
150: pad.postal_code postcode,
151: pad.town_or_city city,
152: pay_nl_general.get_country_name(pad.country) country,
153: pad.style add_style
154: from per_addresses pad
155: where pad.person_id = p_person_id
156: and p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time)
336: CLOSE csr_org_glb_address;
337:
338: IF l_add_style_er = 'NL' THEN
339:
340: l_return_value := pay_nl_general.get_org_address(p_employer_id
341: ,p_bg_id
342: ,l_house_number_er
343: ,l_house_add_no_er
344: ,l_street_name_er
462: CLOSE csr_org_glb_address;
463:
464: IF l_add_style_er = 'NL' THEN
465:
466: l_return_value := pay_nl_general.get_org_address(l_leg_emp_id
467: ,p_bg_id
468: ,l_house_number_er
469: ,l_house_add_no_er
470: ,l_street_name_er
531: CLOSE csr_org_glb_address;
532:
533: IF l_add_style_er = 'NL' THEN
534:
535: l_return_value := pay_nl_general.get_org_address(p_employer_id
536: ,p_bg_id
537: ,l_house_number_er
538: ,l_house_add_no_er
539: ,l_street_name_er
857: CLOSE csr_emp_glb_address;
858:
859: IF l_add_style_ee = 'NL' THEN
860:
861: l_return_value1 := pay_nl_general.get_emp_address(l_person_id
862: ,fnd_date.canonical_to_date(p_year)
863: ,l_house_number_ee
864: ,l_house_add_no_ee
865: ,l_street_name_ee
1218: CLOSE csr_emp_glb_address;
1219:
1220: IF l_add_style_ee = 'NL' THEN
1221:
1222: l_return_value1 := pay_nl_general.get_emp_address(l_person_id
1223: ,fnd_date.canonical_to_date(p_year)
1224: ,l_house_number_ee
1225: ,l_house_add_no_ee
1226: ,l_street_name_ee
1728: hlc.address_line_2 address_line2,
1729: hlc.address_line_3 address_line3,
1730: hlc.postal_code postcode,
1731: hlc.town_or_city city,
1732: pay_nl_general.get_country_name(hlc.country) country,
1733: hlc.style add_style
1734: from hr_locations hlc,
1735: hr_organization_units hou
1736: where hou.business_group_id = p_bg_id
1745: pad.address_line2 address_line2,
1746: pad.address_line3 address_line3,
1747: pad.postal_code postcode,
1748: pad.town_or_city city,
1749: pay_nl_general.get_country_name(pad.country) country,
1750: pad.style add_style
1751: from per_addresses pad
1752: where pad.person_id = p_person_id
1753: and p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time)
1933: CLOSE csr_org_glb_address;
1934:
1935: IF l_add_style_er = 'NL' THEN
1936:
1937: l_return_value := pay_nl_general.get_org_address(p_employer_id
1938: ,p_bg_id
1939: ,l_house_number_er
1940: ,l_house_add_no_er
1941: ,l_street_name_er
2059: CLOSE csr_org_glb_address;
2060:
2061: IF l_add_style_er = 'NL' THEN
2062:
2063: l_return_value := pay_nl_general.get_org_address(l_leg_emp_id
2064: ,p_bg_id
2065: ,l_house_number_er
2066: ,l_house_add_no_er
2067: ,l_street_name_er
2128: CLOSE csr_org_glb_address;
2129:
2130: IF l_add_style_er = 'NL' THEN
2131:
2132: l_return_value := pay_nl_general.get_org_address(p_employer_id
2133: ,p_bg_id
2134: ,l_house_number_er
2135: ,l_house_add_no_er
2136: ,l_street_name_er
2454: CLOSE csr_emp_glb_address;
2455:
2456: IF l_add_style_ee = 'NL' THEN
2457:
2458: l_return_value1 := pay_nl_general.get_emp_address(l_person_id
2459: ,fnd_date.canonical_to_date(p_year)
2460: ,l_house_number_ee
2461: ,l_house_add_no_ee
2462: ,l_street_name_ee
2815: CLOSE csr_emp_glb_address;
2816:
2817: IF l_add_style_ee = 'NL' THEN
2818:
2819: l_return_value1 := pay_nl_general.get_emp_address(l_person_id
2820: ,fnd_date.canonical_to_date(p_year)
2821: ,l_house_number_ee
2822: ,l_house_add_no_ee
2823: ,l_street_name_ee