APPS.IEX_COLLECTORS_TO_RESOURCE dependencies on PER_ALL_PEOPLE_F

Line 377: ar_collectors ac, FND_USER fuser, per_all_people_f pemp ,hz_parties hp

373: hp.county,
374: hp.country,
375: hp.email_address
376: FROM
377: ar_collectors ac, FND_USER fuser, per_all_people_f pemp ,hz_parties hp
378: WHERE ac.employee_id is not null
379: AND ac.employee_id not in (SELECT jtr.source_id from
380: jtf_rs_resource_extns jtr where source_id is not null)
381: AND ac.resource_id is null

Line 400: FROM per_all_people_f

396: business_group_id,
397: office_number,
398: internal_location,
399: mailstop
400: FROM per_all_people_f
401: WHERE person_id = p_person_id
402: ORDER BY effective_start_date DESC;
403:
404: CURSOR C_ROLE_ID is