DBA Data[Home] [Help]

APPS.HR_US_PYZIPCHK dependencies on HR_US_FF_UDFS

Line 69: l_per_addr := hr_us_ff_udfs.addr_val (p_state_abbrev

65: --hr_utility.trace('p_city_name: '||p_city_name);
66: --hr_utility.trace('p_zip_code: '||p_zip_code);
67:
68: IF length(p_zip_code) <> 7 THEN -- US addresses
69: l_per_addr := hr_us_ff_udfs.addr_val (p_state_abbrev
70: ,p_county_name
71: ,p_city_name
72: ,p_zip_code
73: ,'Y');

Line 149: l_hr_addr := hr_us_ff_udfs.addr_val (p_state_abbrev

145: */
146:
147: begin
148: IF length(p_zip_code) <> 7 THEN
149: l_hr_addr := hr_us_ff_udfs.addr_val (p_state_abbrev
150: ,p_county_name
151: ,p_city_name
152: ,p_zip_code
153: ,'Y');