DBA Data[Home] [Help]

APPS.HR_BPL_ALERT_ADDRESS dependencies on PER_ADDRESSES

Line 104: FROM per_addresses addr

100: , addr.add_information18
101: , addr.add_information19
102: , addr.add_information20
103: , NULL
104: FROM per_addresses addr
105: WHERE addr.person_id = cp_person_id
106: AND TRUNC(sysdate)
107: BETWEEN date_from
108: AND NVL(addr.date_to