VIEW: APPS.HRI_MD_SALARY_H_V

Source

View Text - Preformatted

SELECT mb.annualized_salary , mb.salary , mb.annualization_factor , mb.effective_start_date , mb.effective_end_date , mb.assignment_id , mb.person_id , mb.business_group_id , mb.organization_id , mb.location_id , mb.job_id , mb.grade_id , mb.position_id , mb.payroll_id , mb.salary_basis_id , mb.people_group_id , mb.supervisor_person_id , mb.assignment_status_type_id , mb.per_system_status_code , mb.pay_system_status_code , mb.recruiter_id , mb.set_of_books_id , mb.period_of_service_id , mb.employment_category_code , mb.primary_flag_code , mb.pay_proposal_id , mb.currency_code , mb.output_currency_code , mb.perf_rating_code , mb.multiple_component_flag_code , mb.proposal_reason_code , mb.last_salary_flag_code , mb.last_change_date , mb.asg_last_update_date , mb.pro_last_update_date , mb.asg_effective_start_date , mb.asg_effective_end_date , mb.pro_effective_start_date , mb.pro_effective_end_date FROM hri_mb_salary_v mb WHERE DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE' , HR_SECURITY.SHOW_RECORD('PER_ALL_ASSIGNMENTS_F' , mb.assignment_id , mb.person_id , mb.assignment_type_code ) ) = 'TRUE' WITH READ ONLY

View Text - HTML Formatted

SELECT MB.ANNUALIZED_SALARY
, MB.SALARY
, MB.ANNUALIZATION_FACTOR
, MB.EFFECTIVE_START_DATE
, MB.EFFECTIVE_END_DATE
, MB.ASSIGNMENT_ID
, MB.PERSON_ID
, MB.BUSINESS_GROUP_ID
, MB.ORGANIZATION_ID
, MB.LOCATION_ID
, MB.JOB_ID
, MB.GRADE_ID
, MB.POSITION_ID
, MB.PAYROLL_ID
, MB.SALARY_BASIS_ID
, MB.PEOPLE_GROUP_ID
, MB.SUPERVISOR_PERSON_ID
, MB.ASSIGNMENT_STATUS_TYPE_ID
, MB.PER_SYSTEM_STATUS_CODE
, MB.PAY_SYSTEM_STATUS_CODE
, MB.RECRUITER_ID
, MB.SET_OF_BOOKS_ID
, MB.PERIOD_OF_SERVICE_ID
, MB.EMPLOYMENT_CATEGORY_CODE
, MB.PRIMARY_FLAG_CODE
, MB.PAY_PROPOSAL_ID
, MB.CURRENCY_CODE
, MB.OUTPUT_CURRENCY_CODE
, MB.PERF_RATING_CODE
, MB.MULTIPLE_COMPONENT_FLAG_CODE
, MB.PROPOSAL_REASON_CODE
, MB.LAST_SALARY_FLAG_CODE
, MB.LAST_CHANGE_DATE
, MB.ASG_LAST_UPDATE_DATE
, MB.PRO_LAST_UPDATE_DATE
, MB.ASG_EFFECTIVE_START_DATE
, MB.ASG_EFFECTIVE_END_DATE
, MB.PRO_EFFECTIVE_START_DATE
, MB.PRO_EFFECTIVE_END_DATE
FROM HRI_MB_SALARY_V MB
WHERE DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('PER_ALL_ASSIGNMENTS_F'
, MB.ASSIGNMENT_ID
, MB.PERSON_ID
, MB.ASSIGNMENT_TYPE_CODE ) ) = 'TRUE' WITH READ ONLY