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 || '
Period of Service Details - per_periods_of_service