APPS.PQH_LENGTH_OF_SERVICE_PKG dependencies on PER_PREVIOUS_JOB_USAGES

Line 460: from per_previous_employers pem, per_previous_jobs pjo, per_previous_job_usages pju

456: nvl(pjo.start_date, trunc(sysdate)) pjo_start_date,
457: nvl(pjo.end_date, trunc(sysdate)) pjo_end_date,
458: nvl(pju.start_date, trunc(sysdate)) pju_start_date,
459: nvl(pju.end_date, trunc(sysdate)) pju_end_date
460: from per_previous_employers pem, per_previous_jobs pjo, per_previous_job_usages pju
461: where
462: pem.previous_employer_id = pjo.previous_employer_id(+)
463: and
464: pjo.previous_job_id = pju.previous_job_id(+)