APPS.PER_PERSON_INFORMATION dependencies on PER_PERSON_TYPE_USAGES_F

Line 172: FROM per_person_type_usages_f ptu

168: ,NVL(to_char(ptu.effective_end_date,'MM/DD/YYYY'),'12/31/4712') e_e_d
169: ,SUBSTR(ppt.user_person_type,1,20) u_p_t
170: ,SUBSTR(ppt.system_person_type,1,7) p_t_id
171: ,ptu.person_type_id p_id
172: FROM per_person_type_usages_f ptu
173: ,per_person_types ppt
174: WHERE ptu.person_id = p_person_id
175: AND ptu.person_type_id = ppt.person_type_id
176: ORDER BY ptu_id, e_s_d;

Line 417: l_body := l_body || ' Person Type Details - per_person_type_usages_f ';

413: -- person type information
414:
415: l_body := '';
416:
417: l_body := l_body || '';
418:
419: l_body := l_body || ''
420: || ''
421: || ''

Person Type Details - per_person_type_usages_f
' || 'PTU Id' || '	' || 'Effective Start Date' || '