APPS.CSF_ALERTS_PUB dependencies on PER_ALL_PEOPLE_F

Line 2430: per_all_people_f per,

2426: per.full_name contactname,
2427: per.email_address email,
2428: ph.phone_number phone_number
2429: FROM
2430: per_all_people_f per,
2431: per_phones ph
2432: WHERE
2433: per.person_id = v_id
2434: and per.person_id = ph.parent_id

Line 2436: AND ph.parent_table = 'PER_ALL_PEOPLE_F'

2432: WHERE
2433: per.person_id = v_id
2434: and per.person_id = ph.parent_id
2435: and ph.phone_type = 'W1'
2436: AND ph.parent_table = 'PER_ALL_PEOPLE_F'
2437: AND sysdate between nvl(per.effective_start_date, sysdate)
2438: and nvl(per.effective_end_date, sysdate);
2439:
2440: -- bug # 6630754