DBA Data[Home] [Help]

APPS.PER_PERSON_INFORMATION dependencies on PER_PERIODS_OF_SERVICE

Line 130: FROM per_periods_of_service

126: ,NVL(to_char(last_standard_process_date,'MM/DD/YYYY'),'12/31/4712') last
127: ,NVL(to_char(actual_termination_date,'MM/DD/YYYY'), '12/31/4712') actual
128: ,NVL(to_char(final_process_date,'MM/DD/YYYY'), '12/31/4712') final
129: ,leaving_reason l_r
130: FROM per_periods_of_service
131: WHERE person_id = p_person_id
132: ORDER BY date_start;
133:
134: cursor csr_persondetails is

Line 313: l_body := l_body || ' Period of Service Details - per_periods_of_service ';

309:
310:
311: l_body := '';
312:
313: l_body := l_body || '';
314:
315: l_body := l_body || ''
316: || ''
317: || ''

Period of Service Details - per_periods_of_service
' || 'POS Id' || '' || 'Start Date' || '