APPS.CSF_ALERTS_PUB dependencies on PER_ALL_PEOPLE_F

Line 2440: per_all_people_f per,

2436: per.full_name contactname,
2437: per.email_address email,
2438: ph.phone_number phone_number
2439: FROM
2440: per_all_people_f per,
2441: per_phones ph
2442: WHERE
2443: per.person_id = v_id
2444: and per.person_id = ph.parent_id

Line 2446: AND ph.parent_table = 'PER_ALL_PEOPLE_F'

2442: WHERE
2443: per.person_id = v_id
2444: and per.person_id = ph.parent_id
2445: and ph.phone_type = 'W1'
2446: AND ph.parent_table = 'PER_ALL_PEOPLE_F'
2447: AND sysdate between nvl(per.effective_start_date, sysdate)
2448: and nvl(per.effective_end_date, sysdate);
2449:
2450: -- bug # 6630754