21: Employee Address
22: Contact Person Address
23:
24: Notes
25: Referenced By: Package pay_us_reporting_utils_pkg
26:
27: Notes
28:
29: History
269: EXIT WHEN get_phone_fax%NOTFOUND;
270:
271: IF l_phone_type = 'W1' THEN -- Work Phone
272: p_contact_prsn_phone :=
273: replace(pay_us_reporting_utils_pkg.Character_check(l_phone),'-');
274: hr_utility.trace('Contact person PHONE Found.'||p_contact_prsn_phone);
275: ELSIF l_phone_type = 'WF' THEN -- Work Fax
276: p_contact_prsn_fax :=
277: replace(pay_us_reporting_utils_pkg.Character_check(l_phone),'-');
273: replace(pay_us_reporting_utils_pkg.Character_check(l_phone),'-');
274: hr_utility.trace('Contact person PHONE Found.'||p_contact_prsn_phone);
275: ELSIF l_phone_type = 'WF' THEN -- Work Fax
276: p_contact_prsn_fax :=
277: replace(pay_us_reporting_utils_pkg.Character_check(l_phone),'-');
278: hr_utility.trace('Contact Person Fax found.'||p_contact_prsn_fax);
279: END IF;
280:
281: END LOOP; /* get_phone_fax */