APPS.OKS_EXTWAR_UTIL_PVT dependencies on PER_PHONES

Line 5029: FROM per_phones

5025:
5026: CURSOR l_phone_csr (p_source_id NUMBER, p_phone_type VARCHAR2)
5027: IS
5028: SELECT phone_number
5029: FROM per_phones
5030: WHERE parent_id = p_source_id
5031: AND phone_type = p_phone_type
5032: AND parent_table = 'PER_ALL_PEOPLE_F'
5033: AND TRUNC (SYSDATE) BETWEEN date_from AND NVL (date_to, SYSDATE);