APPS.OKS_EXTWAR_UTIL_PVT dependencies on PER_PHONES

Line 4983: FROM per_phones

4979:
4980: CURSOR l_phone_csr (p_source_id NUMBER, p_phone_type VARCHAR2)
4981: IS
4982: SELECT phone_number
4983: FROM per_phones
4984: WHERE parent_id = p_source_id
4985: AND phone_type = p_phone_type
4986: AND parent_table = 'PER_ALL_PEOPLE_F'
4987: AND TRUNC (SYSDATE) BETWEEN date_from AND NVL (date_to, SYSDATE);