VIEW: APPS.HR_EMPLOYEE_ASSIGNMENTS_V

Source

View Text - Preformatted

SELECT paf.assignment_number, haou.name organization_name, pjt.name job_name, papf.full_name supervisor_name, pap.payroll_name, pgt.name grade_name, pft.name position_name, hl.description location_name, paf.person_id, paf.assignment_id, paf.effective_start_date, paf.effective_end_date, paf.business_group_id, paf.organization_id, paf.supervisor_id, paf.location_id, paf.job_id, paf.payroll_id from hr_locations hl, per_grades_tl pgt, hr_all_positions_f_tl pft, pay_all_payrolls_f pap, per_all_people_f papf, per_jobs_tl pjt, hr_all_organization_units haou, per_assignments_f paf, fnd_sessions fs WHERE haou.organization_id = paf.organization_id and fs.session_id = userenv('sessionid') and fs.effective_date between paf.effective_start_date and paf.effective_end_date and pjt.job_id(+) = paf.job_id and pjt.language = userenv('LANG') and paf.supervisor_id = papf.person_id(+) and fs.effective_date between nvl(papf.effective_start_date, fs.effective_date) and nvl(papf.effective_end_date, fs.effective_date) and pap.payroll_id = paf.payroll_id and fs.effective_date between nvl(pap.effective_start_date, fs.effective_date) and nvl(pap.effective_end_date, fs.effective_date) and pgt.grade_id(+) = paf.grade_id and pgt.language(+) = userenv('LANG') and pft.position_id(+) = paf.position_id and pft.language(+) = userenv('LANG') and hl.location_id = paf.location_id

View Text - HTML Formatted

SELECT PAF.ASSIGNMENT_NUMBER
, HAOU.NAME ORGANIZATION_NAME
, PJT.NAME JOB_NAME
, PAPF.FULL_NAME SUPERVISOR_NAME
, PAP.PAYROLL_NAME
, PGT.NAME GRADE_NAME
, PFT.NAME POSITION_NAME
, HL.DESCRIPTION LOCATION_NAME
, PAF.PERSON_ID
, PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, PAF.BUSINESS_GROUP_ID
, PAF.ORGANIZATION_ID
, PAF.SUPERVISOR_ID
, PAF.LOCATION_ID
, PAF.JOB_ID
, PAF.PAYROLL_ID
FROM HR_LOCATIONS HL
, PER_GRADES_TL PGT
, HR_ALL_POSITIONS_F_TL PFT
, PAY_ALL_PAYROLLS_F PAP
, PER_ALL_PEOPLE_F PAPF
, PER_JOBS_TL PJT
, HR_ALL_ORGANIZATION_UNITS HAOU
, PER_ASSIGNMENTS_F PAF
, FND_SESSIONS FS
WHERE HAOU.ORGANIZATION_ID = PAF.ORGANIZATION_ID
AND FS.SESSION_ID = USERENV('SESSIONID')
AND FS.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PJT.JOB_ID(+) = PAF.JOB_ID
AND PJT.LANGUAGE = USERENV('LANG')
AND PAF.SUPERVISOR_ID = PAPF.PERSON_ID(+)
AND FS.EFFECTIVE_DATE BETWEEN NVL(PAPF.EFFECTIVE_START_DATE
, FS.EFFECTIVE_DATE)
AND NVL(PAPF.EFFECTIVE_END_DATE
, FS.EFFECTIVE_DATE)
AND PAP.PAYROLL_ID = PAF.PAYROLL_ID
AND FS.EFFECTIVE_DATE BETWEEN NVL(PAP.EFFECTIVE_START_DATE
, FS.EFFECTIVE_DATE)
AND NVL(PAP.EFFECTIVE_END_DATE
, FS.EFFECTIVE_DATE)
AND PGT.GRADE_ID(+) = PAF.GRADE_ID
AND PGT.LANGUAGE(+) = USERENV('LANG')
AND PFT.POSITION_ID(+) = PAF.POSITION_ID
AND PFT.LANGUAGE(+) = USERENV('LANG')
AND HL.LOCATION_ID = PAF.LOCATION_ID