DBA Data[Home] [Help]

APPS.PA_DISTRIBUTION_LIST_UTILS dependencies on PER_ALL_PEOPLE_F

Line 387: per_all_people_f per,

383: SELECT u.user_name user_name,
384: per.full_name full_name,
385: per.email_address email_address
386: FROM pa_dist_list_items i,
387: per_all_people_f per,
388: fnd_user u
389: WHERE i.list_id = cp_list_id
390: AND i.access_level >= p_access_level
391: AND i.recipient_type = 'HZ_PARTY'

Line 554: per_all_people_f per,

550: SELECT u.user_name user_name,
551: per.full_name full_name,
552: per.email_address email_address
553: FROM pa_dist_list_items i,
554: per_all_people_f per,
555: fnd_user u
556: WHERE i.list_id = cp_list_id
557: AND i.access_level >= p_access_level
558: AND i.recipient_type = 'HZ_PARTY'