APPS.PAY_KW_ANNUAL_REPORTS dependencies on PER_PHONES

Line 136: FROM per_phones pp,per_people_f ppf

132:
133: /* Cursor for fetching person's phone details */
134: CURSOR csr_p_phone_data (l_person_id number,l_ph_type varchar2,l_effective_date date) IS
135: SELECT pp.phone_number
136: FROM per_phones pp,per_people_f ppf
137: WHERE pp.parent_id = ppf.person_id
138: AND pp.phone_type = l_ph_type
139: AND ppf.person_id = l_person_id
140: AND l_effective_date between pp.date_from and nvl(pp.date_to,to_date('31-12-4712','DD-MM-YYYY'));