DBA Data[Home] [Help]

APPS.PA_DISTRIBUTION_LIST_UTILS dependencies on PER_ALL_PEOPLE_F

Line 354: per_all_people_f per,

350: SELECT u.user_name user_name,
351: per.full_name full_name,
352: per.email_address email_address
353: FROM pa_dist_list_items i,
354: per_all_people_f per,
355: fnd_user u
356: WHERE i.list_id = cp_list_id
357: AND i.access_level >= p_access_level
358: AND i.recipient_type = 'HZ_PARTY'

Line 521: per_all_people_f per,

517: SELECT u.user_name user_name,
518: per.full_name full_name,
519: per.email_address email_address
520: FROM pa_dist_list_items i,
521: per_all_people_f per,
522: fnd_user u
523: WHERE i.list_id = cp_list_id
524: AND i.access_level >= p_access_level
525: AND i.recipient_type = 'HZ_PARTY'