CMP_CWB_POST_PERSON_SEL_V

Details

• Schema: FUSION

• Object owner: CMP

• Object type: VIEW

Columns

Name

PERSON_EVENT_ID PLAN_ID PERIOD_ID PERSON_ID ASSIGNMENT_ID WORKER_NUMBER BUSINESS_GROUP_ID BUSINESS_UNIT_ID LEGAL_ENTITY_ID ORGANIZATION_ID LOCATION_ID JOB_SET_ID POSITION_ID CURRENT_ASG_NAME GRADE_SET_ID DUE_DATE ACCESS_CODE EMP_STATUS_CODE MGR_STATUS_CODE EFFECTIVE_DATE ASSIGNMENT_STATUS_TYPE_ID PRIMARY_FLAG START_DATE ORIGINAL_START_DATE ADJUSTED_SVC_DATE EMPLOYMENT_CATEGORY YEARS_EMPLOYED YEARS_IN_JOB YEARS_IN_POSITION YEARS_IN_GRADE JOB_CHANGE_DATE POSITION_CHANGE_DATE GRADE_CHANGE_DATE NORMAL_HOURS FTE_FACTOR BASE_SALARY BASE_SALARY_CURRENCY BASE_SALARY_CHANGE_DATE BASE_SALARY_FREQUENCY CURRENT_SALARY_ID SALARY_BASIS_ID PAYROLL_ID FREQUENCY PAY_ANNUALIZATION_FACTOR ANNUALIZATION_FACTOR_PLAN PERFORMANCE_RATING PERFORMANCE_RATING_TYPE PERFORMANCE_RATING_DATE NEW_BASE_SALARY BASE_SALARY_CHANGE_VAL SEX RATE_FOUND_FLAG EMP_RECV_COUNT ELIG_FLAG CUSTOM_SEGMENT1 CUSTOM_SEGMENT2 CUSTOM_SEGMENT3 CUSTOM_SEGMENT4 CUSTOM_SEGMENT5 CUSTOM_SEGMENT6 CUSTOM_SEGMENT7 CUSTOM_SEGMENT8 CUSTOM_SEGMENT9 CUSTOM_SEGMENT10 CUSTOM_SEGMENT11 CUSTOM_SEGMENT12 CUSTOM_SEGMENT13 CUSTOM_SEGMENT14 CUSTOM_SEGMENT15 CUSTOM_SEGMENT16 CUSTOM_SEGMENT17 CUSTOM_SEGMENT18 CUSTOM_SEGMENT19 CUSTOM_SEGMENT20 CUSTOM_SEGMENT21 CUSTOM_SEGMENT22 CUSTOM_SEGMENT23 CUSTOM_SEGMENT24 CUSTOM_SEGMENT25 CUSTOM_SEGMENT26 CUSTOM_SEGMENT27 CUSTOM_SEGMENT28 CUSTOM_SEGMENT29 CUSTOM_SEGMENT30 CUSTOM_SEGMENT31 CUSTOM_SEGMENT32 CUSTOM_SEGMENT33 CUSTOM_SEGMENT34 CUSTOM_SEGMENT35 CUSTOM_SEGMENT36 CUSTOM_SEGMENT37 CUSTOM_SEGMENT38 CUSTOM_SEGMENT39 CUSTOM_SEGMENT40 CUSTOM_SEGMENT41 CUSTOM_SEGMENT42 CUSTOM_SEGMENT43 CUSTOM_SEGMENT44 CUSTOM_SEGMENT45 CUSTOM_SEGMENT46 CUSTOM_SEGMENT47 CUSTOM_SEGMENT48 CUSTOM_SEGMENT49 CUSTOM_SEGMENT50 ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 DATE_OF_BIRTH EMAIL_ADDRESS EMPLOYEE_POTENTIAL GRADE_ATTRIBUTE1 GRADE_ATTRIBUTE2 GRADE_ATTRIBUTE3 GRADE_COMPARATIO GRADE_DECILE GRADE_ID GRADE_PCT_IN_RANGE GRADE_QUARTILE GRADE_QUINTILE JOB_ATTRIBUTE1 JOB_ATTRIBUTE2 JOB_ATTRIBUTE3 JOB_ATTRIBUTE4 JOB_ATTRIBUTE5 JOB_ATTRIBUTE6 JOB_ID LEGISLATION_CODE NEW_GRADE_COMPARATIO NEW_GRADE_DECILE NEW_GRADE_PCT_IN_RANGE NEW_GRADE_QUARTILE NEW_GRADE_QUINTILE WORK_TELEPHONE WORKING_HOURS WS_MGR_PERSON_ID RISK_OF_LOSS SUPERVISOR_ID DO_NOT_POST_FLAG PERF_RATING PERF_UPDATE_DATE PROMOTION_ID JOB_ID_PROPOSED POSITION_ID_PROPOSED PROPOSED_ASG_NAME GRADE_ID_PROPOSED ASG_CHANGE_DATE GRADE_MIN_VAL GRADE_MAX_VAL GRADE_MID_POINT PROM_UPDATE_DATE WS_VAL_C1 WS_VAL_C2 WS_VAL_C3 WS_VAL_C4 WS_VAL_C5 ELIG_FLAG_C1 ELIG_FLAG_C2 ELIG_FLAG_C3 ELIG_FLAG_C4 ELIG_FLAG_C5 ELIG_SAL_VAL_C1 ELIG_SAL_VAL_C2 ELIG_SAL_VAL_C3 ELIG_SAL_VAL_C4 ELIG_SAL_VAL_C5 WS_MIN_VAL_C1 WS_MIN_VAL_C2 WS_MIN_VAL_C3 WS_MIN_VAL_C4 WS_MIN_VAL_C5 WS_MAX_VAL_C1 WS_MAX_VAL_C2 WS_MAX_VAL_C3 WS_MAX_VAL_C4 WS_MAX_VAL_C5 MISC1_VAL_C1 MISC1_VAL_C2 MISC1_VAL_C3 MISC1_VAL_C4 MISC1_VAL_C5 MISC2_VAL_C1 MISC2_VAL_C2 MISC2_VAL_C3 MISC2_VAL_C4 MISC2_VAL_C5 MISC3_VAL_C1 MISC3_VAL_C2 MISC3_VAL_C3 MISC3_VAL_C4 MISC3_VAL_C5 MISC4_VAL_C1 MISC4_VAL_C2 MISC4_VAL_C3 MISC4_VAL_C4 MISC4_VAL_C5 MISC5_VAL_C1 MISC5_VAL_C2 MISC5_VAL_C3 MISC5_VAL_C4 MISC5_VAL_C5 MISC6_VAL_C1 MISC6_VAL_C2 MISC6_VAL_C3 MISC6_VAL_C4 MISC6_VAL_C5 CURRENCY_C1 CURRENCY_C2 CURRENCY_C3 CURRENCY_C4 CURRENCY_C5 EMP_BDGT_VAL_C1 EMP_BDGT_VAL_C2 EMP_BDGT_VAL_C3 EMP_BDGT_VAL_C4 EMP_BDGT_VAL_C5 REC_VAL_C1 REC_VAL_C2 REC_VAL_C3 REC_VAL_C4 REC_VAL_C5 REC_MAX_VAL_C1 REC_MAX_VAL_C2 REC_MAX_VAL_C3 REC_MAX_VAL_C4 REC_MAX_VAL_C5 REC_MIN_VAL_C1 REC_MIN_VAL_C2 REC_MIN_VAL_C3 REC_MIN_VAL_C4 REC_MIN_VAL_C5 WS_VAL_LAST_UPD_DATE_C1 WS_VAL_LAST_UPD_DATE_C2 WS_VAL_LAST_UPD_DATE_C3 WS_VAL_LAST_UPD_DATE_C4 WS_VAL_LAST_UPD_DATE_C5 COMP_POSTING_DATE_C1 COMP_POSTING_DATE_C2 COMP_POSTING_DATE_C3 COMP_POSTING_DATE_C4 COMP_POSTING_DATE_C5 PERSON_NUMBER SALARY_BASIS_TYPE

Query

SQL_Statement

SELECT PI.person_event_id person_event_id, PI.plan_id plan_id , PI.period_id period_id , PI.person_id person_id , PI.assignment_id assignment_id , PI.worker_number worker_number , PI.business_group_id business_group_id , PI.business_unit_id business_unit_id , PI.legal_entity_id legal_entity_id , PI.organization_id organization_id , PI.location_id location_id , PI.job_set_id job_set_id , PI.position_id position_id , PI.assignment_name current_asg_name, PI.grade_set_id grade_set_id , PI.due_date due_date , PI.access_code access_code , PI.emp_status_code emp_status_code , PI.mgr_status_code mgr_status_code , PI.effective_date effective_date , PI.assignment_status_type_id assignment_status_type_id , PI.primary_flag primary_flag , PI.start_date start_date , PI.original_start_date original_start_date , PI.adjusted_svc_date adjusted_svc_date , PI.employment_category employment_category , PI.years_employed years_employed , PI.years_in_job years_in_job , PI.years_in_position years_in_position , PI.years_in_grade years_in_grade , PI.job_change_date job_change_date , PI.position_change_date position_change_date , PI.grade_change_date grade_change_date , PI.normal_hours normal_hours , PI.fte_factor fte_factor , PI.base_salary base_salary , PI.base_salary_currency base_salary_currency , PI.base_salary_change_date base_salary_change_date , PI.base_salary_frequency base_salary_frequency , PI.current_salary_id current_salary_id , PI.salary_basis_id salary_basis_id , PI.payroll_id payroll_id , PI.frequency frequency , PI.pay_annualization_factor pay_annualization_factor , PL.annualization_factor annualization_factor_plan , PI.performance_rating performance_rating , PI.performance_rating_type performance_rating_type , PI.performance_rating_date performance_rating_date , PI.new_base_salary new_base_salary , PI.base_salary_change_val base_salary_change_val , PI.sex , DECODE(RT.person_event_id,NULL,'N','Y') rate_found_flag , DECODE(RT.ws_val,NULL,0,0,0,1) emp_recv_count , RT.elig_flag elig_flag , PI.custom_segment1 , PI.custom_segment2 , PI.custom_segment3 , PI.custom_segment4 , PI.custom_segment5 , PI.custom_segment6 , PI.custom_segment7 , PI.custom_segment8 , PI.custom_segment9 , PI.custom_segment10 , PI.custom_segment11 , PI.custom_segment12 , PI.custom_segment13 , PI.custom_segment14 , PI.custom_segment15 , PI.custom_segment16 , PI.custom_segment17 , PI.custom_segment18 , PI.custom_segment19 , PI.custom_segment20 , PI.custom_segment21 , PI.custom_segment22 , PI.custom_segment23 , PI.custom_segment24 , PI.custom_segment25 , PI.custom_segment26 , PI.custom_segment27 , PI.custom_segment28 , PI.custom_segment29 , PI.custom_segment30 , PI.custom_segment31 , PI.custom_segment32 , PI.custom_segment33 , PI.custom_segment34 , PI.custom_segment35 , PI.custom_segment36 , PI.custom_segment37 , PI.custom_segment38 , PI.custom_segment39 , PI.custom_segment40 , PI.custom_segment41 , PI.custom_segment42 , PI.custom_segment43 , PI.custom_segment44 , PI.custom_segment45 , PI.custom_segment46 , PI.custom_segment47 , PI.custom_segment48 , PI.custom_segment49 , PI.custom_segment50 , PI.attribute1 , PI.attribute2 , PI.attribute3 , PI.attribute4 , PI.attribute5 , PI.attribute6 , PI.attribute7 , PI.attribute8 , PI.attribute9 , PI.attribute10 , PI.attribute11 , PI.attribute12 , PI.attribute13 , PI.attribute14 , PI.attribute15 , PI.attribute16 , PI.attribute17 , PI.attribute18 , PI.attribute19 , PI.attribute20 , PI.attribute21 , PI.attribute22 , PI.attribute23 , PI.attribute24 , PI.attribute25 , PI.attribute26 , PI.attribute27 , PI.attribute28 , PI.attribute29 , PI.attribute30 , PI.date_of_birth , PI.email_address , PI.worker_potential employee_potential, PI.grade_attribute1 , PI.grade_attribute2 , PI.grade_attribute3 , PI.grade_comparatio , PI.grade_decile , PI.grade_id grade_id , PI.grade_pct_in_range , PI.grade_quartile , PI.grade_quintile , PI.job_attribute1 , PI.job_attribute2 , PI.job_attribute3 , PI.job_attribute4 , PI.job_attribute5 , PI.job_attribute6 , PI.job_id job_id , PI.legislation_code , PI.new_grade_comparatio , PI.new_grade_decile , PI.new_grade_pct_in_range , PI.new_grade_quartile , PI.new_grade_quintile , PI.work_telephone , PI.working_hours , PI.ws_mgr_person_id , PI.risk_of_loss , PI.supervisor_id , PI.do_not_post_flag , CR.perf_rating , CR.perf_update_date , PR.promotion_id promotion_id , PR.job_id job_id_proposed , PR.position_id position_id_proposed , PR.assignment_name proposed_asg_name, PR.grade_id grade_id_proposed , PR.asg_change_date asg_change_date , PR.grade_min_val grade_min_val , PR.grade_max_val grade_max_val , PR.grade_mid_point grade_mid_point , PR.prom_update_date , DECODE(RT1.component_id, -1, to_number(NULL), RT1.ws_val) ws_val_c1 , DECODE(RT2.component_id, -1, to_number(NULL), RT2.ws_val) ws_val_c2 , DECODE(RT3.component_id, -1, to_number(NULL), RT3.ws_val) ws_val_c3 , DECODE(RT4.component_id, -1, to_number(NULL), RT4.ws_val) ws_val_c4 , DECODE(RT5.component_id, -1, to_number(NULL), RT5.ws_val) ws_val_c5 , DECODE(RT1.component_id, -1, TO_CHAR(NULL), RT1.elig_flag) elig_flag_c1 , DECODE(RT2.component_id, -1, TO_CHAR(NULL), RT2.elig_flag) elig_flag_c2 , DECODE(RT3.component_id, -1, TO_CHAR(NULL), RT3.elig_flag) elig_flag_c3 , DECODE(RT4.component_id, -1, TO_CHAR(NULL), RT4.elig_flag) elig_flag_c4 , DECODE(RT5.component_id, -1, TO_CHAR(NULL), RT5.elig_flag) elig_flag_c5 , DECODE(RT1.component_id, -1, to_number(NULL), RT1.elig_sal_val) elig_sal_val_c1 , DECODE(RT2.component_id, -1, to_number(NULL), RT2.elig_sal_val) elig_sal_val_c2 , DECODE(RT3.component_id, -1, to_number(NULL), RT3.elig_sal_val) elig_sal_val_c3 , DECODE(RT4.component_id, -1, to_number(NULL), RT4.elig_sal_val) elig_sal_val_c4 , DECODE(RT5.component_id, -1, to_number(NULL), RT5.elig_sal_val) elig_sal_val_c5 , DECODE(RT1.component_id, -1, to_number(NULL), RT1.ws_min_val) ws_min_val_c1 , DECODE(RT2.component_id, -1, to_number(NULL), RT2.ws_min_val) ws_min_val_c2 , DECODE(RT3.component_id, -1, to_number(NULL), RT3.ws_min_val) ws_min_val_c3 , DECODE(RT4.component_id, -1, to_number(NULL), RT4.ws_min_val) ws_min_val_c4 , DECODE(RT5.component_id, -1, to_number(NULL), RT5.ws_min_val) ws_min_val_c5 , DECODE(RT1.component_id, -1, to_number(NULL), RT1.ws_max_val) ws_max_val_c1 , DECODE(RT2.component_id, -1, to_number(NULL), RT2.ws_max_val) ws_max_val_c2 , DECODE(RT3.component_id, -1, to_number(NULL), RT3.ws_max_val) ws_max_val_c3 , DECODE(RT4.component_id, -1, to_number(NULL), RT4.ws_max_val) ws_max_val_c4 , DECODE(RT5.component_id, -1, to_number(NULL), RT5.ws_max_val) ws_max_val_c5 , DECODE(RT1.component_id, -1, to_number(NULL), RT1.misc1_val) misc1_val_c1 , DECODE(RT2.component_id, -1, to_number(NULL), RT2.misc1_val) misc1_val_c2 , DECODE(RT3.component_id, -1, to_number(NULL), RT3.misc1_val) misc1_val_c3 , DECODE(RT4.component_id, -1, to_number(NULL), RT4.misc1_val) misc1_val_c4 , DECODE(RT5.component_id, -1, to_number(NULL), RT5.misc1_val) misc1_val_c5 , DECODE(RT1.component_id, -1, to_number(NULL), RT1.misc2_val) misc2_val_c1 , DECODE(RT2.component_id, -1, to_number(NULL), RT2.misc2_val) misc2_val_c2 , DECODE(RT3.component_id, -1, to_number(NULL), RT3.misc2_val) misc2_val_c3 , DECODE(RT4.component_id, -1, to_number(NULL), RT4.misc2_val) misc2_val_c4 , DECODE(RT5.component_id, -1, to_number(NULL), RT5.misc2_val) misc2_val_c5 , DECODE(RT1.component_id, -1, to_number(NULL), RT1.misc3_val) misc3_val_c1 , DECODE(RT2.component_id, -1, to_number(NULL), RT2.misc3_val) misc3_val_c2 , DECODE(RT3.component_id, -1, to_number(NULL), RT3.misc3_val) misc3_val_c3 , DECODE(RT4.component_id, -1, to_number(NULL), RT4.misc3_val) misc3_val_c4 , DECODE(RT5.component_id, -1, to_number(NULL), RT5.misc3_val) misc3_val_c5 , DECODE(RT1.component_id, -1, to_number(NULL), RT1.misc4_val) misc4_val_c1 , DECODE(RT2.component_id, -1, to_number(NULL), RT2.misc4_val) misc4_val_c2 , DECODE(RT3.component_id, -1, to_number(NULL), RT3.misc4_val) misc4_val_c3 , DECODE(RT4.component_id, -1, to_number(NULL), RT4.misc4_val) misc4_val_c4 , DECODE(RT5.component_id, -1, to_number(NULL), RT5.misc4_val) misc4_val_c5 , DECODE(RT1.component_id, -1, to_number(NULL), RT1.misc5_val) misc5_val_c1 , DECODE(RT2.component_id, -1, to_number(NULL), RT2.misc5_val) misc5_val_c2 , DECODE(RT3.component_id, -1, to_number(NULL), RT3.misc5_val) misc5_val_c3 , DECODE(RT4.component_id, -1, to_number(NULL), RT4.misc5_val) misc5_val_c4 , DECODE(RT5.component_id, -1, to_number(NULL), RT5.misc5_val) misc5_val_c5 , DECODE(RT1.component_id, -1, to_number(NULL), RT1.misc6_val) misc6_val_c1 , DECODE(RT2.component_id, -1, to_number(NULL), RT2.misc6_val) misc6_val_c2 , DECODE(RT3.component_id, -1, to_number(NULL), RT3.misc6_val) misc6_val_c3 , DECODE(RT4.component_id, -1, to_number(NULL), RT4.misc6_val) misc6_val_c4 , DECODE(RT5.component_id, -1, to_number(NULL), RT5.misc6_val) misc6_val_c5 , DECODE(RT1.component_id, -1, TO_CHAR(NULL), RT1.currency) currency_c1 , DECODE(RT2.component_id, -1, TO_CHAR(NULL), RT2.currency) currency_c2 , DECODE(RT3.component_id, -1, TO_CHAR(NULL), RT3.currency) currency_c3 , DECODE(RT4.component_id, -1, TO_CHAR(NULL), RT4.currency) currency_c4 , DECODE(RT5.component_id, -1, TO_CHAR(NULL), RT5.currency) currency_c5 , DECODE(RT1.component_id, -1, to_number(NULL), RT1.emp_bdgt_val) emp_bdgt_val_c1 , DECODE(RT2.component_id, -1, to_number(NULL), RT2.emp_bdgt_val) emp_bdgt_val_c2 , DECODE(RT3.component_id, -1, to_number(NULL), RT3.emp_bdgt_val) emp_bdgt_val_c3 , DECODE(RT4.component_id, -1, to_number(NULL), RT4.emp_bdgt_val) emp_bdgt_val_c4 , DECODE(RT5.component_id, -1, to_number(NULL), RT5.emp_bdgt_val) emp_bdgt_val_c5 , DECODE(RT1.component_id, -1, to_number(NULL), RT1.rec_val) rec_val_c1 , DECODE(RT2.component_id, -1, to_number(NULL), RT2.rec_val) rec_val_c2 , DECODE(RT3.component_id, -1, to_number(NULL), RT3.rec_val) rec_val_c3 , DECODE(RT4.component_id, -1, to_number(NULL), RT4.rec_val) rec_val_c4 , DECODE(RT5.component_id, -1, to_number(NULL), RT5.rec_val) rec_val_c5 , DECODE(RT1.component_id, -1, to_number(NULL), RT1.rec_max_val) rec_max_val_c1 , DECODE(RT2.component_id, -1, to_number(NULL), RT2.rec_max_val) rec_max_val_c2 , DECODE(RT3.component_id, -1, to_number(NULL), RT3.rec_max_val) rec_max_val_c3 , DECODE(RT4.component_id, -1, to_number(NULL), RT4.rec_max_val) rec_max_val_c4 , DECODE(RT5.component_id, -1, to_number(NULL), RT5.rec_max_val) rec_max_val_c5 , DECODE(RT1.component_id, -1, to_number(NULL), RT1.rec_min_val) rec_min_val_c1 , DECODE(RT2.component_id, -1, to_number(NULL), RT2.rec_min_val) rec_min_val_c2 , DECODE(RT3.component_id, -1, to_number(NULL), RT3.rec_min_val) rec_min_val_c3 , DECODE(RT4.component_id, -1, to_number(NULL), RT4.rec_min_val) rec_min_val_c4 , DECODE(RT5.component_id, -1, to_number(NULL), RT5.rec_min_val) rec_min_val_c5 , DECODE(RT1.component_id, -1, to_date(NULL), RT1.ws_val_last_upd_date) ws_val_last_upd_date_c1 , DECODE(RT2.component_id, -1, to_date(NULL), RT2.ws_val_last_upd_date) ws_val_last_upd_date_c2 , DECODE(RT3.component_id, -1, to_date(NULL), RT3.ws_val_last_upd_date) ws_val_last_upd_date_c3 , DECODE(RT4.component_id, -1, to_date(NULL), RT4.ws_val_last_upd_date) ws_val_last_upd_date_c4 , DECODE(RT5.component_id, -1, to_date(NULL), RT5.ws_val_last_upd_date) ws_val_last_upd_date_c5 , DECODE(RT1.component_id, -1, to_date(NULL), RT1.comp_posting_date) comp_posting_date_c1 , DECODE(RT2.component_id, -1, to_date(NULL), RT2.comp_posting_date) comp_posting_date_c2 , DECODE(RT3.component_id, -1, to_date(NULL), RT3.comp_posting_date) comp_posting_date_c3 , DECODE(RT4.component_id, -1, to_date(NULL), RT4.comp_posting_date) comp_posting_date_c4 , DECODE(RT5.component_id, -1, to_date(NULL), RT5.comp_posting_date) comp_posting_date_c5 , PI.person_number, PI.salary_basis_type FROM cmp_cwb_person_info PI , cmp_plans_b PL , cmp_plan_periods PP, cmp_cwb_person_rates RT , cmp_cwb_person_rates RT1 , cmp_cwb_person_rates RT2 , cmp_cwb_person_rates RT3 , cmp_cwb_person_rates RT4 , cmp_cwb_person_rates RT5 , cmp_cwb_perf_ratings CR , cmp_cwb_promotions PR WHERE NVL(PI.do_not_post_flag,'N') = 'N' AND NOT EXISTS (SELECT 1 FROM cmp_cwb_post_person x WHERE x.plan_id = PI.plan_id AND x.period_id = PI.period_id AND x.person_event_id = PI.person_event_id AND x.status_person = 'POSTED' ) AND PI.plan_id = PL.plan_id AND PI.plan_id = PP.plan_id AND PI.period_id = PP.period_id AND PI.plan_id = RT.plan_id AND PI.period_id = RT.period_id AND PI.person_event_id = RT.person_event_id AND RT.component_id = -1 AND PI.person_event_id = RT1.person_event_id (+) AND RT1.component_id = NVL( (SELECT component_id FROM cmp_components_b c1 WHERE c1.plan_id = PI.plan_id AND c1.system_order_num = 1 ), -1) AND PI.person_event_id = RT2.person_event_id (+) AND RT2.component_id = NVL( (SELECT component_id FROM cmp_components_b c2 WHERE c2.plan_id = PI.plan_id AND c2.system_order_num = 2 ), -1) AND PI.person_event_id = RT3.person_event_id (+) AND RT3.component_id = NVL( (SELECT component_id FROM cmp_components_b c3 WHERE c3.plan_id = PI.plan_id AND c3.system_order_num = 3 ), -1) AND PI.person_event_id = RT4.person_event_id (+) AND RT4.component_id = NVL( (SELECT component_id FROM cmp_components_b c4 WHERE c4.plan_id = PI.plan_id AND c4.system_order_num = 4 ), -1) AND PI.person_event_id = RT5.person_event_id (+) AND RT5.component_id = NVL( (SELECT component_id FROM cmp_components_b c5 WHERE c5.plan_id = PI.plan_id AND c5.system_order_num = 5 ), -1) AND PI.assignment_id = CR.assignment_id(+) AND CR.perf_date(+) = PP.performance_date AND PI.assignment_id = PR.assignment_id(+) AND PR.asg_change_date(+) = PP.assignment_change_date