VIEW: APPS.HRI_MD_SAL_GRDRT_HX_V

Source

View Text - Preformatted

SELECT 1 row_indicator , sag.annualized_salary annualized_salary , sag.salary salary , sag.salary_annualization_factor salary_annualization_factor , sag.annualized_grade_max annualized_grade_max , sag.annualized_grade_mid annualized_grade_mid , sag.annualized_grade_min annualized_grade_min , sag.grade_max grade_max , sag.grade_mid grade_mid , sag.grade_min grade_min , sag.grade_annualization_factor grade_annualization_factor , sag.above_max_indicator above_max_indicator , sag.below_max_indicator below_max_indicator , sag.above_mid_indicator above_mid_indicator , sag.below_mid_indicator below_mid_indicator , sag.above_min_indicator above_min_indicator , sag.below_min_indicator below_min_indicator , sag.min_to_mid_indicator min_to_mid_indicator , sag.mid_to_max_indicator mid_to_max_indicator , sag.salary_to_min_ratio salary_to_min_ratio , sag.salary_to_mid_ratio salary_to_mid_ratio , sag.salary_to_max_ratio salary_to_max_ratio , sag.salary_to_min_ratio_pct salary_to_min_ratio_pct , sag.salary_to_mid_ratio_pct salary_to_mid_ratio_pct , sag.salary_to_max_ratio_pct salary_to_max_ratio_pct , sag.effective_start_date effective_start_date , sag.effective_end_date effective_end_date , sag.assignment_id assignment_id , sag.person_id person_id , sag.business_group_id business_group_id , sag.organization_id organization_id , sag.location_id location_id , sag.job_id job_id , sag.grade_id grade_id , sag.position_id position_id , sag.supervisor_person_id supervisor_person_id , sag.pay_proposal_id pay_proposal_id , sag.currency_code currency_code , sag.output_currency_code output_currency_code , sag.currency_code grade_currency_code , sag.performance_rating_code performance_rating_code , sag.multiple_component_flag_code multiple_component_flag_code , sag.proposal_reason_code proposal_reason_code , sag.last_salary_flag_code last_salary_flag_code , sag.grade_rule_id grade_rule_id , sag.rate_id rate_id , sag.last_change_date last_change_date , sag.asg_last_update_date asg_last_update_date , sag.pro_last_update_date pro_last_update_date , sag.grl_last_update_date grl_last_update_date FROM hri_md_sal_grdrt_x_v sag WHERE DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE' , HR_SECURITY.SHOW_RECORD('PER_ALL_ASSIGNMENTS_F' , sag.assignment_id , sag.person_id , sag.assignment_type_code ) ) = 'TRUE'

View Text - HTML Formatted

SELECT 1 ROW_INDICATOR
, SAG.ANNUALIZED_SALARY ANNUALIZED_SALARY
, SAG.SALARY SALARY
, SAG.SALARY_ANNUALIZATION_FACTOR SALARY_ANNUALIZATION_FACTOR
, SAG.ANNUALIZED_GRADE_MAX ANNUALIZED_GRADE_MAX
, SAG.ANNUALIZED_GRADE_MID ANNUALIZED_GRADE_MID
, SAG.ANNUALIZED_GRADE_MIN ANNUALIZED_GRADE_MIN
, SAG.GRADE_MAX GRADE_MAX
, SAG.GRADE_MID GRADE_MID
, SAG.GRADE_MIN GRADE_MIN
, SAG.GRADE_ANNUALIZATION_FACTOR GRADE_ANNUALIZATION_FACTOR
, SAG.ABOVE_MAX_INDICATOR ABOVE_MAX_INDICATOR
, SAG.BELOW_MAX_INDICATOR BELOW_MAX_INDICATOR
, SAG.ABOVE_MID_INDICATOR ABOVE_MID_INDICATOR
, SAG.BELOW_MID_INDICATOR BELOW_MID_INDICATOR
, SAG.ABOVE_MIN_INDICATOR ABOVE_MIN_INDICATOR
, SAG.BELOW_MIN_INDICATOR BELOW_MIN_INDICATOR
, SAG.MIN_TO_MID_INDICATOR MIN_TO_MID_INDICATOR
, SAG.MID_TO_MAX_INDICATOR MID_TO_MAX_INDICATOR
, SAG.SALARY_TO_MIN_RATIO SALARY_TO_MIN_RATIO
, SAG.SALARY_TO_MID_RATIO SALARY_TO_MID_RATIO
, SAG.SALARY_TO_MAX_RATIO SALARY_TO_MAX_RATIO
, SAG.SALARY_TO_MIN_RATIO_PCT SALARY_TO_MIN_RATIO_PCT
, SAG.SALARY_TO_MID_RATIO_PCT SALARY_TO_MID_RATIO_PCT
, SAG.SALARY_TO_MAX_RATIO_PCT SALARY_TO_MAX_RATIO_PCT
, SAG.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, SAG.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, SAG.ASSIGNMENT_ID ASSIGNMENT_ID
, SAG.PERSON_ID PERSON_ID
, SAG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, SAG.ORGANIZATION_ID ORGANIZATION_ID
, SAG.LOCATION_ID LOCATION_ID
, SAG.JOB_ID JOB_ID
, SAG.GRADE_ID GRADE_ID
, SAG.POSITION_ID POSITION_ID
, SAG.SUPERVISOR_PERSON_ID SUPERVISOR_PERSON_ID
, SAG.PAY_PROPOSAL_ID PAY_PROPOSAL_ID
, SAG.CURRENCY_CODE CURRENCY_CODE
, SAG.OUTPUT_CURRENCY_CODE OUTPUT_CURRENCY_CODE
, SAG.CURRENCY_CODE GRADE_CURRENCY_CODE
, SAG.PERFORMANCE_RATING_CODE PERFORMANCE_RATING_CODE
, SAG.MULTIPLE_COMPONENT_FLAG_CODE MULTIPLE_COMPONENT_FLAG_CODE
, SAG.PROPOSAL_REASON_CODE PROPOSAL_REASON_CODE
, SAG.LAST_SALARY_FLAG_CODE LAST_SALARY_FLAG_CODE
, SAG.GRADE_RULE_ID GRADE_RULE_ID
, SAG.RATE_ID RATE_ID
, SAG.LAST_CHANGE_DATE LAST_CHANGE_DATE
, SAG.ASG_LAST_UPDATE_DATE ASG_LAST_UPDATE_DATE
, SAG.PRO_LAST_UPDATE_DATE PRO_LAST_UPDATE_DATE
, SAG.GRL_LAST_UPDATE_DATE GRL_LAST_UPDATE_DATE
FROM HRI_MD_SAL_GRDRT_X_V SAG
WHERE DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('PER_ALL_ASSIGNMENTS_F'
, SAG.ASSIGNMENT_ID
, SAG.PERSON_ID
, SAG.ASSIGNMENT_TYPE_CODE ) ) = 'TRUE'