APPS.PAY_KW_ANNUAL_REPORTS dependencies on PER_PHONES

Line 151: FROM per_phones pp,per_people_f ppf

147:
148: /* Cursor for fetching person's phone details */
149: CURSOR csr_p_phone_data (l_person_id number,l_ph_type varchar2,l_effective_date date) IS
150: SELECT pp.phone_number
151: FROM per_phones pp,per_people_f ppf
152: WHERE pp.parent_id = ppf.person_id
153: AND pp.phone_type = l_ph_type
154: AND ppf.person_id = l_person_id
155: AND l_effective_date between pp.date_from and nvl(pp.date_to,to_date('31-12-4712','DD-MM-YYYY'));

Line 1637: FROM per_phones pp,per_people_f ppf

1633:
1634: /* cursor to fetch employee telephone details Oct 2012 */
1635: CURSOR csr_p_phone_data (l_person_id number,l_ph_type varchar2,l_effective_date date) IS
1636: SELECT pp.phone_number
1637: FROM per_phones pp,per_people_f ppf
1638: WHERE pp.parent_id = ppf.person_id
1639: AND pp.phone_type = l_ph_type
1640: AND ppf.person_id = l_person_id
1641: AND l_effective_date between pp.date_from and nvl(pp.date_to,to_date('31-12-4712','DD-MM-YYYY'));