[Home] [Help]
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 || ' Person Type Details - per_person_type_usages_f |
';
418:
419: l_body := l_body || '
'
420: || '' || 'PTU Id' || ' | '
421: || '' || 'Effective Start Date' || ' | '