[Home] [Help]
APPS.PER_PERSON_INFORMATION dependencies on PER_PEOPLE_F
Line 142: from per_people_f ppf
138: ,NVL(to_char(ppf.effective_end_date,'MM/DD/YYYY'),'12/31/4712') e_e_d
139: ,substr(ppt.user_person_type,1,15) u_p_t
140: ,substr(ppt.system_person_type,1,7) p_t_id
141: ,ppf.party_id p_id
142: from per_people_f ppf
143: ,per_person_types ppt
144: where ppf.person_id = p_person_id
145: and ppf.person_type_id = ppt.person_type_id
146: order by ppf.effective_start_date
Line 382: l_body := l_body || ' Person Details - per_people_f |
';
378: -- person information
379:
380: l_body := '
';
381:
382: l_body := l_body || ' Person Details - per_people_f |
';
383:
384: l_body := l_body || '
'
385: || '' || 'Full Name' || ' | '
386: || '' || 'Effective Start Date' || ' | '