APPS.PER_PERSON_INFORMATION dependencies on STANDARD

Line 126: ,NVL(to_char(last_standard_process_date,'MM/DD/YYYY'),'12/31/4712') last

122:
123: cursor csr_pp_service is
124: SELECT SUBSTR(period_of_service_id,1,11) pos_id
125: ,to_char(date_start,'MM/DD/YYYY') d_s
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

Line 318: || '' || 'Last Standard Process Date' || ''

314:
315: l_body := l_body || ''
316: || '' || 'POS Id' || ''
317: || '' || 'Start Date' || ''
318: || '' || 'Last Standard Process Date' || ''
319: || '' || 'Actual Termination Date' || ''
320: || '' || 'Final Process Date' || ''
321: || '' || 'Leaving Reason' || ''
322: || '';