APPS.HR_US_W2_REP dependencies on PER_ADDRESSES

Line 768: l_postal_code per_addresses.postal_code%type;

764:
765: FUNCTION get_w2_postal_code(w2_person_id in number, w2_effective_date in date)
766: RETURN VARCHAR2 IS
767:
768: l_postal_code per_addresses.postal_code%type;
769:
770: BEGIN
771: -- pay_us_balance_view_pkg.debug_msg('FUNCTION : get_w2_postal_code ');
772: -- pay_us_balance_view_pkg.debug_msg('Person Id : '||to_char(w2_person_id));

Line 776: from per_addresses pa

772: -- pay_us_balance_view_pkg.debug_msg('Person Id : '||to_char(w2_person_id));
773: -- pay_us_balance_view_pkg.debug_msg('Effective Date : '|| to_char(w2_effective_date,'DD-MM-YYYY'));
774: select pa.postal_code
775: into l_postal_code
776: from per_addresses pa
777: where pa.person_id = w2_person_id
778: and pa.primary_flag = 'Y'
779: and w2_effective_date between pa.date_from
780: and nvl(pa.date_to,w2_effective_date);