APPS.PER_JP_DEPENDENT_PKG dependencies on PER_ADDRESSES

Line 9: SELECT COUNT(person_id) FROM per_addresses

5: p_person_id IN NUMBER,
6: p_effective_date IN DATE) RETURN NUMBER IS
7: --
8: CURSOR cel_address_exist IS
9: SELECT COUNT(person_id) FROM per_addresses
10: WHERE person_id = p_person_id
11: AND p_effective_date BETWEEN date_from AND NVL(date_to,p_effective_date);
12: --
13: l_address_count NUMBER;

Line 106: FROM per_addresses

102: add_information19,
103: add_information20,
104: date_from,
105: date_to
106: FROM per_addresses
107: WHERE person_id = p_person_id
108: AND p_effective_date BETWEEN date_from AND NVL(date_to,p_effective_date);
109: --
110: celrec_address_detail cel_address_detail%ROWTYPE;