APPS.HR_JP_GENERAL_PKG dependencies on PER_ADDRESSES

Line 82: from per_addresses pad

78: IS
79: l_address VARCHAR2(180);
80: CURSOR cur_address IS
81: select pad.address_line1 || pad.address_line2 || pad.address_line3
82: from per_addresses pad
83: where pad.person_id=p_person_id
84: and pad.address_type=p_address_type
85: and p_effective_date
86: between pad.date_from and nvl(pad.date_to,p_effective_date);

Line 111: from per_addresses pad

107: IS
108: l_district_code VARCHAR2(30);
109: CURSOR cur_district_code IS
110: select pad.town_or_city
111: from per_addresses pad
112: where pad.person_id=p_person_id
113: and pad.address_type=p_address_type
114: and p_effective_date
115: between pad.date_from and nvl(pad.date_to,p_effective_date);