APPS.HR_US_W2_REP dependencies on PER_ADDRESSES

Line 863: l_postal_code per_addresses.postal_code%type;

859:
860: FUNCTION get_w2_postal_code(w2_person_id in number, w2_effective_date in date)
861: RETURN VARCHAR2 IS
862:
863: l_postal_code per_addresses.postal_code%type;
864:
865: BEGIN
866: -- pay_us_balance_view_pkg.debug_msg('FUNCTION : get_w2_postal_code ');
867: -- pay_us_balance_view_pkg.debug_msg('Person Id : '||to_char(w2_person_id));

Line 871: from per_addresses pa

867: -- pay_us_balance_view_pkg.debug_msg('Person Id : '||to_char(w2_person_id));
868: -- pay_us_balance_view_pkg.debug_msg('Effective Date : '|| to_char(w2_effective_date,'DD-MM-YYYY'));
869: select pa.postal_code
870: into l_postal_code
871: from per_addresses pa
872: where pa.person_id = w2_person_id
873: and pa.primary_flag = 'Y'
874: and w2_effective_date between pa.date_from
875: and nvl(pa.date_to,w2_effective_date);