VIEW: APPS.HRI_OBI_MD_REC_CAND_PIPLN_V

Source

View Text - Preformatted

SELECT tab.time_day_evt_fk ,tab.time_day_evt_end_fk ,tab.time_day_stg_evt_eff_end_fk ,tab.vac_open_date time_day_vac_strt_fk ,tab.vac_close_date time_day_vac_end_fk ,tab.per_person_cand_fk ,tab.per_person_mngr_fk ,tab.per_person_rcrt_fk ,tab.per_person_rmgr_fk ,tab.per_person_rsed_fk ,tab.per_person_mrgd_fk ,tab.per_person_auth_fk ,tab.per_person_refr_fk ,tab.org_organztn_fk ,tab.org_organztn_mrgd_fk ,tab.org_organztn_recr_fk ,tab.geo_location_fk ,tab.job_job_fk ,tab.grd_grade_fk ,tab.pos_position_fk ,tab.prfm_perfband_fk ,tab.rvac_vacncy_fk ,tab.ract_recactvy_fk ,tab.rev_recevent_fk ,tab.tarn_trmaplrn_fk ,tab.rern_recevtrn_fk ,(1 - tab.vac_closed_ind) vac_open_cnt ,tab.init_appl_stg_ind init_appl_stg_cnt ,tab.asmt_stg_ind asmt_stg_cnt ,tab.offr_extd_stg_ind offr_extd_stg_cnt ,tab.strt_pndg_stg_ind strt_pndg_stg_cnt ,tab.hire_stg_ind hire_pre_pow1_cnt ,SIGN(tab.init_appl_stg_ind + tab.asmt_stg_ind + tab.offr_extd_stg_ind + tab.strt_pndg_stg_ind) appl_in_progress_cnt ,tab.appl_strt_evnt_ind appl_strt_evnt_cnt ,tab.init_appl_or_term_ind * tab.appl_term_evnt_ind appl_term_init_evnt_cnt ,tab.init_appl_or_term_ind * tab.appl_term_vol_evnt_ind appl_term_vol_init_evnt_cnt ,tab.init_appl_or_term_ind * tab.appl_term_invol_evnt_ind appl_term_invol_init_evnt_cnt ,tab.asmt_strt_evnt_ind asmt_strt_evnt_cnt ,tab.asmt_strt_or_term_ind * tab.appl_term_evnt_ind appl_term_asmt_evnt_cnt ,tab.asmt_strt_or_term_ind * tab.appl_term_vol_evnt_ind appl_term_vol_asmt_evnt_cnt ,tab.asmt_strt_or_term_ind * tab.appl_term_invol_evnt_ind appl_term_invol_asmt_evnt_cnt ,tab.offr_extd_evnt_ind offr_extd_evnt_cnt ,tab.offr_rjct_evnt_ind appl_term_offr_evnt_cnt ,tab.offr_rjct_evnt_ind * tab.appl_term_vol_evnt_ind appl_term_vol_offr_evnt_cnt ,tab.offr_rjct_evnt_ind * tab.appl_term_invol_evnt_ind appl_term_invol_offr_evnt_cnt ,tab.offr_acpt_evnt_ind offr_acpt_evnt_cnt ,tab.offr_acpt_or_term_ind * tab.appl_term_evnt_ind appl_term_acpt_evnt_cnt ,tab.offr_acpt_or_term_ind * tab.appl_term_vol_evnt_ind appl_term_vol_acpt_evnt_cnt ,tab.offr_acpt_or_term_ind * tab.appl_term_invol_evnt_ind appl_term_invol_acpt_evnt_cnt ,tab.appl_term_evnt_ind appl_term_evnt_cnt ,tab.appl_term_vol_evnt_ind appl_term_vol_evnt_cnt ,tab.appl_term_invol_evnt_ind appl_term_invol_evnt_cnt ,tab.hire_evnt_ind hire_evnt_cnt ,tab.appl_hire_evnt_ind hire_appl_evnt_cnt ,tab.hire_evnt_ind - tab.appl_hire_evnt_ind hire_empl_evnt_cnt ,tab.post_hire_pow1_end_evnt_ind post_hire_pow1_end_evnt_cnt ,tab.emp_sprtn_evnt_ind pre_pow1_end_sprtn_evnt_cnt ,(tab.appl_strt_date - tab.vac_open_date) * tab.appl_strt_evnt_nind vac_to_appl_strt_evnt_days ,(tab.asmt_strt_date - tab.vac_open_date) * tab.asmt_strt_evnt_nind vac_to_asmt_strt_evnt_days ,(tab.offr_extd_date - tab.vac_open_date) * tab.offr_extd_evnt_nind vac_to_offr_extd_evnt_days ,(tab.offr_rjct_date - tab.vac_open_date) * tab.offr_rjct_evnt_nind vac_to_term_offr_evnt_days ,(tab.offr_acpt_date - tab.vac_open_date) * tab.offr_acpt_evnt_nind vac_to_offr_acpt_evnt_days ,(tab.hire_date - tab.vac_open_date) * tab.hire_evnt_nind vac_to_appl_hire_evnt_days ,(tab.appl_term_date - tab.vac_open_date) * tab.appl_term_evnt_nind vac_to_appl_term_evnt_days ,(tab.offr_acpt_date - tab.vac_open_date) * tab.hire_evnt_nind vac_to_fill_evnt_days ,tab.event_date - tab.vac_open_date vac_to_event_days ,tab.appl_to_term_days * tab.init_appl_or_term_nind * tab.appl_term_evnt_nind appl_to_term_init_evnt_days ,(tab.asmt_strt_date - tab.appl_strt_date) * tab.asmt_strt_evnt_nind appl_to_asmt_strt_evnt_days ,tab.appl_to_term_days * tab.asmt_strt_or_term_nind * tab.appl_term_evnt_nind appl_to_term_asmt_evnt_days ,(tab.offr_extd_date - tab.appl_strt_date) * tab.offr_extd_evnt_nind appl_to_offr_extd_evnt_days ,(tab.offr_rjct_date - tab.appl_strt_date) * tab.offr_rjct_evnt_nind appl_to_term_offr_evnt_days ,(tab.offr_acpt_date - tab.appl_strt_date) * tab.offr_acpt_evnt_nind appl_to_offr_acpt_evnt_days ,tab.appl_to_term_days * tab.offr_acpt_or_term_nind * tab.appl_term_evnt_nind appl_to_term_acpt_evnt_days ,(tab.hire_date - tab.appl_strt_date) * tab.hire_evnt_nind appl_to_appl_hire_evnt_days ,tab.appl_to_term_days * tab.appl_term_evnt_nind appl_to_appl_term_evnt_days ,(tab.offr_acpt_date - tab.appl_strt_date) * tab.hire_evnt_nind appl_to_fill_evnt_days ,(tab.hire_date - tab.offr_acpt_date) * tab.hire_evnt_nind fill_to_appl_hire_evnt_days ,tab.event_date - tab.appl_strt_date appl_to_event_days ,tab.event_date - tab.stage_start_date stage_strt_to_event_days ,(tab.appl_term_date - tab.asmt_strt_date) * tab.asmt_strt_or_term_nind * tab.appl_term_evnt_nind asmt_to_term_evnt_days ,(tab.offr_rjct_date - tab.offr_extd_date) * tab.appl_term_vol_evnt_nind offr_to_term_vol_evnt_days ,(tab.offr_rjct_date - tab.offr_extd_date) * tab.appl_term_invol_evnt_nind offr_to_term_invol_evnt_days ,(tab.offr_acpt_date - tab.offr_extd_date) * tab.offr_acpt_evnt_nind offr_to_acpt_evnt_days ,(tab.hire_date - tab.offr_acpt_date) * tab.hire_evnt_nind acpt_to_hire_evnt_days ,(tab.appl_term_date - tab.offr_acpt_date) * tab.appl_term_vol_evnt_nind acpt_to_term_vol_evnt_days ,(tab.appl_term_date - tab.offr_acpt_date) * tab.appl_term_invol_evnt_nind acpt_to_term_invol_evnt_days ,tab.headcount ,tab.fte ,tab.appl_ind ,tab.appl_new_ind ,tab.appl_emp_ind ,tab.appl_cwk_ind ,tab.post_hire_nrmlsd_perf_rtng ,tab.event_seq ,tab.vac_close_date - tab.vac_open_date vac_open_days ,tab.appl_strt_nevnt_ind appl_strt_nevnt_cnt ,tab.init_appl_or_term_ind * tab.appl_term_nevnt_ind appl_term_init_nevnt_cnt ,tab.init_appl_or_term_ind * tab.appl_term_vol_nevnt_ind appl_term_vol_init_nevnt_cnt ,tab.init_appl_or_term_ind * tab.appl_term_invol_nevnt_ind appl_term_invol_init_nevnt_cnt ,tab.asmt_strt_nevnt_ind asmt_strt_nevnt_cnt ,tab.asmt_strt_or_term_ind * tab.appl_term_nevnt_ind appl_term_asmt_nevnt_cnt ,tab.asmt_strt_or_term_ind * tab.appl_term_vol_nevnt_ind appl_term_vol_asmt_nevnt_cnt ,tab.asmt_strt_or_term_ind * tab.appl_term_invol_nevnt_ind appl_term_invol_asmt_nevnt_cnt ,tab.offr_extd_nevnt_ind offr_extd_nevnt_cnt ,tab.offr_rjct_nevnt_ind appl_term_offr_nevnt_cnt ,tab.offr_rjct_nevnt_ind * tab.appl_term_vol_nevnt_ind appl_term_vol_offr_nevnt_cnt ,tab.offr_rjct_nevnt_ind * tab.appl_term_invol_nevnt_ind appl_term_invol_offr_nevnt_cnt ,tab.offr_acpt_nevnt_ind offr_acpt_nevnt_cnt ,tab.offr_acpt_or_term_ind * tab.appl_term_nevnt_ind appl_term_acpt_nevnt_cnt ,tab.offr_acpt_or_term_ind * tab.appl_term_vol_nevnt_ind appl_term_vol_acpt_nevnt_cnt ,tab.offr_acpt_or_term_ind * tab.appl_term_invol_nevnt_ind appl_term_invol_acpt_nevnt_cnt ,tab.appl_term_nevnt_ind appl_term_nevnt_cnt ,tab.appl_term_vol_nevnt_ind appl_term_vol_nevnt_cnt ,tab.appl_term_invol_nevnt_ind appl_term_invol_nevnt_cnt ,tab.hire_nevnt_ind hire_nevnt_cnt ,tab.appl_hire_nevnt_ind hire_appl_nevnt_cnt ,tab.hire_nevnt_ind - tab.appl_hire_nevnt_ind hire_empl_nevnt_cnt ,tab.post_hire_pow1_end_nevnt_ind post_hire_pow1_end_nevnt_cnt ,tab.emp_sprtn_nevnt_ind pre_pow1_end_sprtn_nevnt_cnt ,(tab.appl_strt_date - tab.vac_open_date) vac_to_appl_strt_nevnt_days ,(tab.asmt_strt_date - tab.vac_open_date) vac_to_asmt_strt_nevnt_days ,(tab.offr_extd_date - tab.vac_open_date) vac_to_offr_extd_nevnt_days ,(tab.offr_rjct_date - tab.vac_open_date) vac_to_term_offr_nevnt_days ,(tab.offr_acpt_date - tab.vac_open_date) vac_to_offr_acpt_nevnt_days ,(tab.hire_date - tab.vac_open_date) vac_to_appl_hire_nevnt_days ,(tab.appl_term_date - tab.vac_open_date) vac_to_appl_term_nevnt_days ,tab.appl_to_term_days * tab.init_appl_or_term_nind * tab.appl_term_nevnt_nind appl_to_term_init_nevnt_days ,(tab.asmt_strt_date - tab.appl_strt_date) appl_to_asmt_strt_nevnt_days ,tab.appl_to_term_days * tab.asmt_strt_or_term_nind * tab.appl_term_nevnt_nind appl_to_term_asmt_nevnt_days ,(tab.offr_extd_date - tab.appl_strt_date) appl_to_offr_extd_nevnt_days ,(tab.offr_rjct_date - tab.appl_strt_date) appl_to_term_offr_nevnt_days ,(tab.offr_acpt_date - tab.appl_strt_date) appl_to_offr_acpt_nevnt_days ,tab.appl_to_term_days * tab.offr_acpt_or_term_nind * tab.appl_term_nevnt_nind appl_to_term_acpt_nevnt_days ,(tab.hire_date - tab.appl_strt_date) appl_to_appl_hire_nevnt_days ,tab.appl_to_term_days appl_to_appl_term_nevnt_days ,(tab.appl_term_date - tab.asmt_strt_date) * tab.asmt_strt_or_term_nind * tab.appl_term_nevnt_nind asmt_to_term_nevnt_days ,(tab.offr_rjct_date - tab.offr_extd_date) * tab.appl_term_vol_nevnt_nind offr_to_term_vol_nevnt_days ,(tab.offr_rjct_date - tab.offr_extd_date) * tab.appl_term_invol_nevnt_nind offr_to_term_invol_nevnt_days ,(tab.offr_acpt_date - tab.offr_extd_date) offr_to_acpt_nevnt_days ,(tab.hire_date - tab.offr_acpt_date) acpt_to_hire_nevnt_days ,(tab.appl_term_date - tab.offr_acpt_date) * tab.appl_term_vol_nevnt_nind acpt_to_term_vol_nevnt_days ,(tab.appl_term_date - tab.offr_acpt_date) * tab.appl_term_invol_nevnt_nind acpt_to_term_invol_nevnt_days ,tab.number_of_openings total_openings ,tab.appl_hire_evnt_ind filled_openings ,CASE WHEN tab.adt_budget_type_code = 'HEAD' THEN tab.budget_measurement_value ELSE to_number(null) END total_headcount ,CASE WHEN tab.adt_budget_type_code = 'HEAD' THEN tab.appl_hire_evnt_ind * NVL(tab.headcount, 0) ELSE to_number(null) END filled_headcount ,CASE WHEN tab.adt_budget_type_code = 'FTE' THEN tab.budget_measurement_value ELSE to_number(null) END total_fte ,CASE WHEN tab.adt_budget_type_code = 'FTE' THEN tab.appl_hire_evnt_ind * NVL(tab.fte, 0) ELSE to_number(null) END filled_fte ,CASE WHEN tab.adt_budget_type_code = 'MONEY' THEN tab.budget_measurement_value ELSE to_number(null) END total_money ,to_number(null) filled_money ,tab.budget_measurement_value ,tab.adt_assignment_id FROM (SELECT apl.time_day_evt_fk ,apl.time_day_evt_end_fk ,apl.time_day_stg_evt_eff_end_fk ,apl.per_person_cand_fk ,apl.per_person_mngr_fk ,apl.per_person_rcrt_fk ,apl.per_person_rmgr_fk ,apl.per_person_rsed_fk ,apl.per_person_mrgd_fk ,apl.per_person_auth_fk ,apl.per_person_refr_fk ,apl.org_organztn_fk ,apl.org_organztn_mrgd_fk ,apl.org_organztn_recr_fk ,apl.geo_location_fk ,apl.job_job_fk ,apl.grd_grade_fk ,apl.pos_position_fk ,apl.prfm_perfband_fk ,apl.rvac_vacncy_fk ,apl.ract_recactvy_fk ,apl.rev_recevent_fk ,apl.tarn_trmaplrn_fk ,apl.rern_recevtrn_fk ,vac.number_of_openings ,vac.budget_measurement_value ,apl.adt_assignment_id ,apl.adt_asg_effctv_start_date ,apl.adt_asg_effctv_end_date ,apl.adt_application_id ,vac.adt_vacancy_status_code ,vac.adt_budget_type_code ,vac.adt_vacancy_category_code ,CASE WHEN vac.adt_vacancy_status_code = 'CLOSED' AND vac.time_day_vac_end_fk <= TRUNC(SYSDATE) THEN 1 ELSE 0 END vac_closed_ind ,apl.appl_strt_nevnt_ind * (1 - apl.asmt_strt_nevnt_ind) init_appl_or_term_ind ,apl.asmt_strt_nevnt_ind * (1 - apl.offr_extd_nevnt_ind) asmt_strt_or_term_ind ,apl.offr_extd_nevnt_ind * (1 - apl.offr_acpt_nevnt_ind) offr_extd_or_term_ind ,apl.offr_acpt_nevnt_ind * (1 - apl.appl_hire_nevnt_ind) offr_acpt_or_term_ind ,apl.hire_nevnt_ind * (1 - apl.post_hire_pow1_end_nevnt_ind) hire_pre_pow1_or_term_ind ,DECODE(apl.appl_strt_evnt_ind, 1, 1, to_number(null)) appl_strt_evnt_nind ,DECODE(apl.asmt_strt_evnt_ind, 1, 1, to_number(null)) asmt_strt_evnt_nind ,DECODE(apl.offr_extd_evnt_ind, 1, 1, to_number(null)) offr_extd_evnt_nind ,DECODE(apl.offr_rjct_evnt_ind, 1, 1, to_number(null)) offr_rjct_evnt_nind ,DECODE(apl.offr_acpt_evnt_ind, 1, 1, to_number(null)) offr_acpt_evnt_nind ,DECODE(apl.hire_evnt_ind, 1, 1, to_number(null)) hire_evnt_nind ,DECODE(apl.appl_term_evnt_ind, 1, 1, to_number(null)) appl_term_evnt_nind ,DECODE(apl.appl_term_vol_evnt_ind, 1, 1, to_number(null)) appl_term_vol_evnt_nind ,DECODE(apl.appl_term_invol_evnt_ind, 1, 1, to_number(null)) appl_term_invol_evnt_nind ,DECODE(apl.appl_term_nevnt_ind, 1, 1, to_number(null)) appl_term_nevnt_nind ,DECODE(apl.appl_term_vol_nevnt_ind, 1, 1, to_number(null)) appl_term_vol_nevnt_nind ,DECODE(apl.appl_term_invol_nevnt_ind, 1, 1, to_number(null)) appl_term_invol_nevnt_nind ,DECODE(apl.appl_strt_nevnt_ind * (1 - apl.asmt_strt_nevnt_ind), 1, 1, to_number(null)) init_appl_or_term_nind ,DECODE(apl.asmt_strt_nevnt_ind * (1 - apl.offr_extd_nevnt_ind), 1, 1, to_number(null)) asmt_strt_or_term_nind ,DECODE(apl.offr_acpt_nevnt_ind * (1 - apl.appl_hire_nevnt_ind), 1, 1, to_number(null)) offr_acpt_or_term_nind ,apl.appl_strt_evnt_ind ,apl.asmt_strt_evnt_ind ,apl.offr_extd_evnt_ind ,apl.offr_rjct_evnt_ind ,apl.offr_acpt_evnt_ind ,apl.appl_term_evnt_ind ,apl.appl_term_vol_evnt_ind ,apl.appl_term_invol_evnt_ind ,apl.hire_evnt_ind ,apl.appl_hire_evnt_ind ,apl.post_hire_pow1_end_evnt_ind ,apl.emp_sprtn_evnt_ind ,NVL(vac.vac_strt_date, apl.appl_strt_date) vac_open_date ,vac.time_day_vac_end_fk vac_close_date ,apl.appl_strt_date ,apl.asmt_strt_date ,apl.offr_extd_date ,apl.offr_rjct_date ,apl.offr_acpt_date ,apl.hire_date ,apl.appl_term_date ,apl.event_date ,apl.stage_start_date ,apl.headcount ,apl.fte ,apl.post_hire_nrmlsd_perf_rtng ,apl.event_seq ,(apl.appl_term_date - apl.appl_strt_date) appl_to_term_days ,apl.appl_ind ,apl.appl_new_ind ,apl.appl_emp_ind ,apl.appl_cwk_ind ,apl.appl_strt_nevnt_ind ,apl.asmt_strt_nevnt_ind ,apl.asmt_end_nevnt_ind ,apl.offr_extd_nevnt_ind ,apl.offr_rjct_nevnt_ind ,apl.offr_acpt_nevnt_ind ,apl.appl_term_nevnt_ind ,apl.appl_term_vol_nevnt_ind ,apl.appl_term_invol_nevnt_ind ,apl.appl_hire_nevnt_ind ,apl.hire_nevnt_ind ,apl.post_hire_pow1_end_nevnt_ind ,apl.post_hire_perf_nevnt_ind ,apl.emp_sprtn_nevnt_ind ,apl.hire_org_chng_ind ,apl.hire_job_chng_ind ,apl.hire_pos_chng_ind ,apl.hire_grd_chng_ind ,apl.hire_loc_chng_ind ,apl.current_record_ind ,apl.current_stage_strt_ind ,apl.gen_record_ind ,apl.init_appl_stg_ind ,apl.asmt_stg_ind ,apl.offr_extd_stg_ind ,apl.strt_pndg_stg_ind ,apl.hire_stg_ind FROM hri_mb_rec_cand_pipln_ct apl ,hri_mb_rec_vacancy_ct vac WHERE apl.rvac_vacncy_fk = vac.rvac_vacncy_fk ) tab

View Text - HTML Formatted

SELECT TAB.TIME_DAY_EVT_FK
, TAB.TIME_DAY_EVT_END_FK
, TAB.TIME_DAY_STG_EVT_EFF_END_FK
, TAB.VAC_OPEN_DATE TIME_DAY_VAC_STRT_FK
, TAB.VAC_CLOSE_DATE TIME_DAY_VAC_END_FK
, TAB.PER_PERSON_CAND_FK
, TAB.PER_PERSON_MNGR_FK
, TAB.PER_PERSON_RCRT_FK
, TAB.PER_PERSON_RMGR_FK
, TAB.PER_PERSON_RSED_FK
, TAB.PER_PERSON_MRGD_FK
, TAB.PER_PERSON_AUTH_FK
, TAB.PER_PERSON_REFR_FK
, TAB.ORG_ORGANZTN_FK
, TAB.ORG_ORGANZTN_MRGD_FK
, TAB.ORG_ORGANZTN_RECR_FK
, TAB.GEO_LOCATION_FK
, TAB.JOB_JOB_FK
, TAB.GRD_GRADE_FK
, TAB.POS_POSITION_FK
, TAB.PRFM_PERFBAND_FK
, TAB.RVAC_VACNCY_FK
, TAB.RACT_RECACTVY_FK
, TAB.REV_RECEVENT_FK
, TAB.TARN_TRMAPLRN_FK
, TAB.RERN_RECEVTRN_FK
, (1 - TAB.VAC_CLOSED_IND) VAC_OPEN_CNT
, TAB.INIT_APPL_STG_IND INIT_APPL_STG_CNT
, TAB.ASMT_STG_IND ASMT_STG_CNT
, TAB.OFFR_EXTD_STG_IND OFFR_EXTD_STG_CNT
, TAB.STRT_PNDG_STG_IND STRT_PNDG_STG_CNT
, TAB.HIRE_STG_IND HIRE_PRE_POW1_CNT
, SIGN(TAB.INIT_APPL_STG_IND + TAB.ASMT_STG_IND + TAB.OFFR_EXTD_STG_IND + TAB.STRT_PNDG_STG_IND) APPL_IN_PROGRESS_CNT
, TAB.APPL_STRT_EVNT_IND APPL_STRT_EVNT_CNT
, TAB.INIT_APPL_OR_TERM_IND * TAB.APPL_TERM_EVNT_IND APPL_TERM_INIT_EVNT_CNT
, TAB.INIT_APPL_OR_TERM_IND * TAB.APPL_TERM_VOL_EVNT_IND APPL_TERM_VOL_INIT_EVNT_CNT
, TAB.INIT_APPL_OR_TERM_IND * TAB.APPL_TERM_INVOL_EVNT_IND APPL_TERM_INVOL_INIT_EVNT_CNT
, TAB.ASMT_STRT_EVNT_IND ASMT_STRT_EVNT_CNT
, TAB.ASMT_STRT_OR_TERM_IND * TAB.APPL_TERM_EVNT_IND APPL_TERM_ASMT_EVNT_CNT
, TAB.ASMT_STRT_OR_TERM_IND * TAB.APPL_TERM_VOL_EVNT_IND APPL_TERM_VOL_ASMT_EVNT_CNT
, TAB.ASMT_STRT_OR_TERM_IND * TAB.APPL_TERM_INVOL_EVNT_IND APPL_TERM_INVOL_ASMT_EVNT_CNT
, TAB.OFFR_EXTD_EVNT_IND OFFR_EXTD_EVNT_CNT
, TAB.OFFR_RJCT_EVNT_IND APPL_TERM_OFFR_EVNT_CNT
, TAB.OFFR_RJCT_EVNT_IND * TAB.APPL_TERM_VOL_EVNT_IND APPL_TERM_VOL_OFFR_EVNT_CNT
, TAB.OFFR_RJCT_EVNT_IND * TAB.APPL_TERM_INVOL_EVNT_IND APPL_TERM_INVOL_OFFR_EVNT_CNT
, TAB.OFFR_ACPT_EVNT_IND OFFR_ACPT_EVNT_CNT
, TAB.OFFR_ACPT_OR_TERM_IND * TAB.APPL_TERM_EVNT_IND APPL_TERM_ACPT_EVNT_CNT
, TAB.OFFR_ACPT_OR_TERM_IND * TAB.APPL_TERM_VOL_EVNT_IND APPL_TERM_VOL_ACPT_EVNT_CNT
, TAB.OFFR_ACPT_OR_TERM_IND * TAB.APPL_TERM_INVOL_EVNT_IND APPL_TERM_INVOL_ACPT_EVNT_CNT
, TAB.APPL_TERM_EVNT_IND APPL_TERM_EVNT_CNT
, TAB.APPL_TERM_VOL_EVNT_IND APPL_TERM_VOL_EVNT_CNT
, TAB.APPL_TERM_INVOL_EVNT_IND APPL_TERM_INVOL_EVNT_CNT
, TAB.HIRE_EVNT_IND HIRE_EVNT_CNT
, TAB.APPL_HIRE_EVNT_IND HIRE_APPL_EVNT_CNT
, TAB.HIRE_EVNT_IND - TAB.APPL_HIRE_EVNT_IND HIRE_EMPL_EVNT_CNT
, TAB.POST_HIRE_POW1_END_EVNT_IND POST_HIRE_POW1_END_EVNT_CNT
, TAB.EMP_SPRTN_EVNT_IND PRE_POW1_END_SPRTN_EVNT_CNT
, (TAB.APPL_STRT_DATE - TAB.VAC_OPEN_DATE) * TAB.APPL_STRT_EVNT_NIND VAC_TO_APPL_STRT_EVNT_DAYS
, (TAB.ASMT_STRT_DATE - TAB.VAC_OPEN_DATE) * TAB.ASMT_STRT_EVNT_NIND VAC_TO_ASMT_STRT_EVNT_DAYS
, (TAB.OFFR_EXTD_DATE - TAB.VAC_OPEN_DATE) * TAB.OFFR_EXTD_EVNT_NIND VAC_TO_OFFR_EXTD_EVNT_DAYS
, (TAB.OFFR_RJCT_DATE - TAB.VAC_OPEN_DATE) * TAB.OFFR_RJCT_EVNT_NIND VAC_TO_TERM_OFFR_EVNT_DAYS
, (TAB.OFFR_ACPT_DATE - TAB.VAC_OPEN_DATE) * TAB.OFFR_ACPT_EVNT_NIND VAC_TO_OFFR_ACPT_EVNT_DAYS
, (TAB.HIRE_DATE - TAB.VAC_OPEN_DATE) * TAB.HIRE_EVNT_NIND VAC_TO_APPL_HIRE_EVNT_DAYS
, (TAB.APPL_TERM_DATE - TAB.VAC_OPEN_DATE) * TAB.APPL_TERM_EVNT_NIND VAC_TO_APPL_TERM_EVNT_DAYS
, (TAB.OFFR_ACPT_DATE - TAB.VAC_OPEN_DATE) * TAB.HIRE_EVNT_NIND VAC_TO_FILL_EVNT_DAYS
, TAB.EVENT_DATE - TAB.VAC_OPEN_DATE VAC_TO_EVENT_DAYS
, TAB.APPL_TO_TERM_DAYS * TAB.INIT_APPL_OR_TERM_NIND * TAB.APPL_TERM_EVNT_NIND APPL_TO_TERM_INIT_EVNT_DAYS
, (TAB.ASMT_STRT_DATE - TAB.APPL_STRT_DATE) * TAB.ASMT_STRT_EVNT_NIND APPL_TO_ASMT_STRT_EVNT_DAYS
, TAB.APPL_TO_TERM_DAYS * TAB.ASMT_STRT_OR_TERM_NIND * TAB.APPL_TERM_EVNT_NIND APPL_TO_TERM_ASMT_EVNT_DAYS
, (TAB.OFFR_EXTD_DATE - TAB.APPL_STRT_DATE) * TAB.OFFR_EXTD_EVNT_NIND APPL_TO_OFFR_EXTD_EVNT_DAYS
, (TAB.OFFR_RJCT_DATE - TAB.APPL_STRT_DATE) * TAB.OFFR_RJCT_EVNT_NIND APPL_TO_TERM_OFFR_EVNT_DAYS
, (TAB.OFFR_ACPT_DATE - TAB.APPL_STRT_DATE) * TAB.OFFR_ACPT_EVNT_NIND APPL_TO_OFFR_ACPT_EVNT_DAYS
, TAB.APPL_TO_TERM_DAYS * TAB.OFFR_ACPT_OR_TERM_NIND * TAB.APPL_TERM_EVNT_NIND APPL_TO_TERM_ACPT_EVNT_DAYS
, (TAB.HIRE_DATE - TAB.APPL_STRT_DATE) * TAB.HIRE_EVNT_NIND APPL_TO_APPL_HIRE_EVNT_DAYS
, TAB.APPL_TO_TERM_DAYS * TAB.APPL_TERM_EVNT_NIND APPL_TO_APPL_TERM_EVNT_DAYS
, (TAB.OFFR_ACPT_DATE - TAB.APPL_STRT_DATE) * TAB.HIRE_EVNT_NIND APPL_TO_FILL_EVNT_DAYS
, (TAB.HIRE_DATE - TAB.OFFR_ACPT_DATE) * TAB.HIRE_EVNT_NIND FILL_TO_APPL_HIRE_EVNT_DAYS
, TAB.EVENT_DATE - TAB.APPL_STRT_DATE APPL_TO_EVENT_DAYS
, TAB.EVENT_DATE - TAB.STAGE_START_DATE STAGE_STRT_TO_EVENT_DAYS
, (TAB.APPL_TERM_DATE - TAB.ASMT_STRT_DATE) * TAB.ASMT_STRT_OR_TERM_NIND * TAB.APPL_TERM_EVNT_NIND ASMT_TO_TERM_EVNT_DAYS
, (TAB.OFFR_RJCT_DATE - TAB.OFFR_EXTD_DATE) * TAB.APPL_TERM_VOL_EVNT_NIND OFFR_TO_TERM_VOL_EVNT_DAYS
, (TAB.OFFR_RJCT_DATE - TAB.OFFR_EXTD_DATE) * TAB.APPL_TERM_INVOL_EVNT_NIND OFFR_TO_TERM_INVOL_EVNT_DAYS
, (TAB.OFFR_ACPT_DATE - TAB.OFFR_EXTD_DATE) * TAB.OFFR_ACPT_EVNT_NIND OFFR_TO_ACPT_EVNT_DAYS
, (TAB.HIRE_DATE - TAB.OFFR_ACPT_DATE) * TAB.HIRE_EVNT_NIND ACPT_TO_HIRE_EVNT_DAYS
, (TAB.APPL_TERM_DATE - TAB.OFFR_ACPT_DATE) * TAB.APPL_TERM_VOL_EVNT_NIND ACPT_TO_TERM_VOL_EVNT_DAYS
, (TAB.APPL_TERM_DATE - TAB.OFFR_ACPT_DATE) * TAB.APPL_TERM_INVOL_EVNT_NIND ACPT_TO_TERM_INVOL_EVNT_DAYS
, TAB.HEADCOUNT
, TAB.FTE
, TAB.APPL_IND
, TAB.APPL_NEW_IND
, TAB.APPL_EMP_IND
, TAB.APPL_CWK_IND
, TAB.POST_HIRE_NRMLSD_PERF_RTNG
, TAB.EVENT_SEQ
, TAB.VAC_CLOSE_DATE - TAB.VAC_OPEN_DATE VAC_OPEN_DAYS
, TAB.APPL_STRT_NEVNT_IND APPL_STRT_NEVNT_CNT
, TAB.INIT_APPL_OR_TERM_IND * TAB.APPL_TERM_NEVNT_IND APPL_TERM_INIT_NEVNT_CNT
, TAB.INIT_APPL_OR_TERM_IND * TAB.APPL_TERM_VOL_NEVNT_IND APPL_TERM_VOL_INIT_NEVNT_CNT
, TAB.INIT_APPL_OR_TERM_IND * TAB.APPL_TERM_INVOL_NEVNT_IND APPL_TERM_INVOL_INIT_NEVNT_CNT
, TAB.ASMT_STRT_NEVNT_IND ASMT_STRT_NEVNT_CNT
, TAB.ASMT_STRT_OR_TERM_IND * TAB.APPL_TERM_NEVNT_IND APPL_TERM_ASMT_NEVNT_CNT
, TAB.ASMT_STRT_OR_TERM_IND * TAB.APPL_TERM_VOL_NEVNT_IND APPL_TERM_VOL_ASMT_NEVNT_CNT
, TAB.ASMT_STRT_OR_TERM_IND * TAB.APPL_TERM_INVOL_NEVNT_IND APPL_TERM_INVOL_ASMT_NEVNT_CNT
, TAB.OFFR_EXTD_NEVNT_IND OFFR_EXTD_NEVNT_CNT
, TAB.OFFR_RJCT_NEVNT_IND APPL_TERM_OFFR_NEVNT_CNT
, TAB.OFFR_RJCT_NEVNT_IND * TAB.APPL_TERM_VOL_NEVNT_IND APPL_TERM_VOL_OFFR_NEVNT_CNT
, TAB.OFFR_RJCT_NEVNT_IND * TAB.APPL_TERM_INVOL_NEVNT_IND APPL_TERM_INVOL_OFFR_NEVNT_CNT
, TAB.OFFR_ACPT_NEVNT_IND OFFR_ACPT_NEVNT_CNT
, TAB.OFFR_ACPT_OR_TERM_IND * TAB.APPL_TERM_NEVNT_IND APPL_TERM_ACPT_NEVNT_CNT
, TAB.OFFR_ACPT_OR_TERM_IND * TAB.APPL_TERM_VOL_NEVNT_IND APPL_TERM_VOL_ACPT_NEVNT_CNT
, TAB.OFFR_ACPT_OR_TERM_IND * TAB.APPL_TERM_INVOL_NEVNT_IND APPL_TERM_INVOL_ACPT_NEVNT_CNT
, TAB.APPL_TERM_NEVNT_IND APPL_TERM_NEVNT_CNT
, TAB.APPL_TERM_VOL_NEVNT_IND APPL_TERM_VOL_NEVNT_CNT
, TAB.APPL_TERM_INVOL_NEVNT_IND APPL_TERM_INVOL_NEVNT_CNT
, TAB.HIRE_NEVNT_IND HIRE_NEVNT_CNT
, TAB.APPL_HIRE_NEVNT_IND HIRE_APPL_NEVNT_CNT
, TAB.HIRE_NEVNT_IND - TAB.APPL_HIRE_NEVNT_IND HIRE_EMPL_NEVNT_CNT
, TAB.POST_HIRE_POW1_END_NEVNT_IND POST_HIRE_POW1_END_NEVNT_CNT
, TAB.EMP_SPRTN_NEVNT_IND PRE_POW1_END_SPRTN_NEVNT_CNT
, (TAB.APPL_STRT_DATE - TAB.VAC_OPEN_DATE) VAC_TO_APPL_STRT_NEVNT_DAYS
, (TAB.ASMT_STRT_DATE - TAB.VAC_OPEN_DATE) VAC_TO_ASMT_STRT_NEVNT_DAYS
, (TAB.OFFR_EXTD_DATE - TAB.VAC_OPEN_DATE) VAC_TO_OFFR_EXTD_NEVNT_DAYS
, (TAB.OFFR_RJCT_DATE - TAB.VAC_OPEN_DATE) VAC_TO_TERM_OFFR_NEVNT_DAYS
, (TAB.OFFR_ACPT_DATE - TAB.VAC_OPEN_DATE) VAC_TO_OFFR_ACPT_NEVNT_DAYS
, (TAB.HIRE_DATE - TAB.VAC_OPEN_DATE) VAC_TO_APPL_HIRE_NEVNT_DAYS
, (TAB.APPL_TERM_DATE - TAB.VAC_OPEN_DATE) VAC_TO_APPL_TERM_NEVNT_DAYS
, TAB.APPL_TO_TERM_DAYS * TAB.INIT_APPL_OR_TERM_NIND * TAB.APPL_TERM_NEVNT_NIND APPL_TO_TERM_INIT_NEVNT_DAYS
, (TAB.ASMT_STRT_DATE - TAB.APPL_STRT_DATE) APPL_TO_ASMT_STRT_NEVNT_DAYS
, TAB.APPL_TO_TERM_DAYS * TAB.ASMT_STRT_OR_TERM_NIND * TAB.APPL_TERM_NEVNT_NIND APPL_TO_TERM_ASMT_NEVNT_DAYS
, (TAB.OFFR_EXTD_DATE - TAB.APPL_STRT_DATE) APPL_TO_OFFR_EXTD_NEVNT_DAYS
, (TAB.OFFR_RJCT_DATE - TAB.APPL_STRT_DATE) APPL_TO_TERM_OFFR_NEVNT_DAYS
, (TAB.OFFR_ACPT_DATE - TAB.APPL_STRT_DATE) APPL_TO_OFFR_ACPT_NEVNT_DAYS
, TAB.APPL_TO_TERM_DAYS * TAB.OFFR_ACPT_OR_TERM_NIND * TAB.APPL_TERM_NEVNT_NIND APPL_TO_TERM_ACPT_NEVNT_DAYS
, (TAB.HIRE_DATE - TAB.APPL_STRT_DATE) APPL_TO_APPL_HIRE_NEVNT_DAYS
, TAB.APPL_TO_TERM_DAYS APPL_TO_APPL_TERM_NEVNT_DAYS
, (TAB.APPL_TERM_DATE - TAB.ASMT_STRT_DATE) * TAB.ASMT_STRT_OR_TERM_NIND * TAB.APPL_TERM_NEVNT_NIND ASMT_TO_TERM_NEVNT_DAYS
, (TAB.OFFR_RJCT_DATE - TAB.OFFR_EXTD_DATE) * TAB.APPL_TERM_VOL_NEVNT_NIND OFFR_TO_TERM_VOL_NEVNT_DAYS
, (TAB.OFFR_RJCT_DATE - TAB.OFFR_EXTD_DATE) * TAB.APPL_TERM_INVOL_NEVNT_NIND OFFR_TO_TERM_INVOL_NEVNT_DAYS
, (TAB.OFFR_ACPT_DATE - TAB.OFFR_EXTD_DATE) OFFR_TO_ACPT_NEVNT_DAYS
, (TAB.HIRE_DATE - TAB.OFFR_ACPT_DATE) ACPT_TO_HIRE_NEVNT_DAYS
, (TAB.APPL_TERM_DATE - TAB.OFFR_ACPT_DATE) * TAB.APPL_TERM_VOL_NEVNT_NIND ACPT_TO_TERM_VOL_NEVNT_DAYS
, (TAB.APPL_TERM_DATE - TAB.OFFR_ACPT_DATE) * TAB.APPL_TERM_INVOL_NEVNT_NIND ACPT_TO_TERM_INVOL_NEVNT_DAYS
, TAB.NUMBER_OF_OPENINGS TOTAL_OPENINGS
, TAB.APPL_HIRE_EVNT_IND FILLED_OPENINGS
, CASE WHEN TAB.ADT_BUDGET_TYPE_CODE = 'HEAD' THEN TAB.BUDGET_MEASUREMENT_VALUE ELSE TO_NUMBER(NULL) END TOTAL_HEADCOUNT
, CASE WHEN TAB.ADT_BUDGET_TYPE_CODE = 'HEAD' THEN TAB.APPL_HIRE_EVNT_IND * NVL(TAB.HEADCOUNT
, 0) ELSE TO_NUMBER(NULL) END FILLED_HEADCOUNT
, CASE WHEN TAB.ADT_BUDGET_TYPE_CODE = 'FTE' THEN TAB.BUDGET_MEASUREMENT_VALUE ELSE TO_NUMBER(NULL) END TOTAL_FTE
, CASE WHEN TAB.ADT_BUDGET_TYPE_CODE = 'FTE' THEN TAB.APPL_HIRE_EVNT_IND * NVL(TAB.FTE
, 0) ELSE TO_NUMBER(NULL) END FILLED_FTE
, CASE WHEN TAB.ADT_BUDGET_TYPE_CODE = 'MONEY' THEN TAB.BUDGET_MEASUREMENT_VALUE ELSE TO_NUMBER(NULL) END TOTAL_MONEY
, TO_NUMBER(NULL) FILLED_MONEY
, TAB.BUDGET_MEASUREMENT_VALUE
, TAB.ADT_ASSIGNMENT_ID
FROM (SELECT APL.TIME_DAY_EVT_FK
, APL.TIME_DAY_EVT_END_FK
, APL.TIME_DAY_STG_EVT_EFF_END_FK
, APL.PER_PERSON_CAND_FK
, APL.PER_PERSON_MNGR_FK
, APL.PER_PERSON_RCRT_FK
, APL.PER_PERSON_RMGR_FK
, APL.PER_PERSON_RSED_FK
, APL.PER_PERSON_MRGD_FK
, APL.PER_PERSON_AUTH_FK
, APL.PER_PERSON_REFR_FK
, APL.ORG_ORGANZTN_FK
, APL.ORG_ORGANZTN_MRGD_FK
, APL.ORG_ORGANZTN_RECR_FK
, APL.GEO_LOCATION_FK
, APL.JOB_JOB_FK
, APL.GRD_GRADE_FK
, APL.POS_POSITION_FK
, APL.PRFM_PERFBAND_FK
, APL.RVAC_VACNCY_FK
, APL.RACT_RECACTVY_FK
, APL.REV_RECEVENT_FK
, APL.TARN_TRMAPLRN_FK
, APL.RERN_RECEVTRN_FK
, VAC.NUMBER_OF_OPENINGS
, VAC.BUDGET_MEASUREMENT_VALUE
, APL.ADT_ASSIGNMENT_ID
, APL.ADT_ASG_EFFCTV_START_DATE
, APL.ADT_ASG_EFFCTV_END_DATE
, APL.ADT_APPLICATION_ID
, VAC.ADT_VACANCY_STATUS_CODE
, VAC.ADT_BUDGET_TYPE_CODE
, VAC.ADT_VACANCY_CATEGORY_CODE
, CASE WHEN VAC.ADT_VACANCY_STATUS_CODE = 'CLOSED'
AND VAC.TIME_DAY_VAC_END_FK <= TRUNC(SYSDATE) THEN 1 ELSE 0 END VAC_CLOSED_IND
, APL.APPL_STRT_NEVNT_IND * (1 - APL.ASMT_STRT_NEVNT_IND) INIT_APPL_OR_TERM_IND
, APL.ASMT_STRT_NEVNT_IND * (1 - APL.OFFR_EXTD_NEVNT_IND) ASMT_STRT_OR_TERM_IND
, APL.OFFR_EXTD_NEVNT_IND * (1 - APL.OFFR_ACPT_NEVNT_IND) OFFR_EXTD_OR_TERM_IND
, APL.OFFR_ACPT_NEVNT_IND * (1 - APL.APPL_HIRE_NEVNT_IND) OFFR_ACPT_OR_TERM_IND
, APL.HIRE_NEVNT_IND * (1 - APL.POST_HIRE_POW1_END_NEVNT_IND) HIRE_PRE_POW1_OR_TERM_IND
, DECODE(APL.APPL_STRT_EVNT_IND
, 1
, 1
, TO_NUMBER(NULL)) APPL_STRT_EVNT_NIND
, DECODE(APL.ASMT_STRT_EVNT_IND
, 1
, 1
, TO_NUMBER(NULL)) ASMT_STRT_EVNT_NIND
, DECODE(APL.OFFR_EXTD_EVNT_IND
, 1
, 1
, TO_NUMBER(NULL)) OFFR_EXTD_EVNT_NIND
, DECODE(APL.OFFR_RJCT_EVNT_IND
, 1
, 1
, TO_NUMBER(NULL)) OFFR_RJCT_EVNT_NIND
, DECODE(APL.OFFR_ACPT_EVNT_IND
, 1
, 1
, TO_NUMBER(NULL)) OFFR_ACPT_EVNT_NIND
, DECODE(APL.HIRE_EVNT_IND
, 1
, 1
, TO_NUMBER(NULL)) HIRE_EVNT_NIND
, DECODE(APL.APPL_TERM_EVNT_IND
, 1
, 1
, TO_NUMBER(NULL)) APPL_TERM_EVNT_NIND
, DECODE(APL.APPL_TERM_VOL_EVNT_IND
, 1
, 1
, TO_NUMBER(NULL)) APPL_TERM_VOL_EVNT_NIND
, DECODE(APL.APPL_TERM_INVOL_EVNT_IND
, 1
, 1
, TO_NUMBER(NULL)) APPL_TERM_INVOL_EVNT_NIND
, DECODE(APL.APPL_TERM_NEVNT_IND
, 1
, 1
, TO_NUMBER(NULL)) APPL_TERM_NEVNT_NIND
, DECODE(APL.APPL_TERM_VOL_NEVNT_IND
, 1
, 1
, TO_NUMBER(NULL)) APPL_TERM_VOL_NEVNT_NIND
, DECODE(APL.APPL_TERM_INVOL_NEVNT_IND
, 1
, 1
, TO_NUMBER(NULL)) APPL_TERM_INVOL_NEVNT_NIND
, DECODE(APL.APPL_STRT_NEVNT_IND * (1 - APL.ASMT_STRT_NEVNT_IND)
, 1
, 1
, TO_NUMBER(NULL)) INIT_APPL_OR_TERM_NIND
, DECODE(APL.ASMT_STRT_NEVNT_IND * (1 - APL.OFFR_EXTD_NEVNT_IND)
, 1
, 1
, TO_NUMBER(NULL)) ASMT_STRT_OR_TERM_NIND
, DECODE(APL.OFFR_ACPT_NEVNT_IND * (1 - APL.APPL_HIRE_NEVNT_IND)
, 1
, 1
, TO_NUMBER(NULL)) OFFR_ACPT_OR_TERM_NIND
, APL.APPL_STRT_EVNT_IND
, APL.ASMT_STRT_EVNT_IND
, APL.OFFR_EXTD_EVNT_IND
, APL.OFFR_RJCT_EVNT_IND
, APL.OFFR_ACPT_EVNT_IND
, APL.APPL_TERM_EVNT_IND
, APL.APPL_TERM_VOL_EVNT_IND
, APL.APPL_TERM_INVOL_EVNT_IND
, APL.HIRE_EVNT_IND
, APL.APPL_HIRE_EVNT_IND
, APL.POST_HIRE_POW1_END_EVNT_IND
, APL.EMP_SPRTN_EVNT_IND
, NVL(VAC.VAC_STRT_DATE
, APL.APPL_STRT_DATE) VAC_OPEN_DATE
, VAC.TIME_DAY_VAC_END_FK VAC_CLOSE_DATE
, APL.APPL_STRT_DATE
, APL.ASMT_STRT_DATE
, APL.OFFR_EXTD_DATE
, APL.OFFR_RJCT_DATE
, APL.OFFR_ACPT_DATE
, APL.HIRE_DATE
, APL.APPL_TERM_DATE
, APL.EVENT_DATE
, APL.STAGE_START_DATE
, APL.HEADCOUNT
, APL.FTE
, APL.POST_HIRE_NRMLSD_PERF_RTNG
, APL.EVENT_SEQ
, (APL.APPL_TERM_DATE - APL.APPL_STRT_DATE) APPL_TO_TERM_DAYS
, APL.APPL_IND
, APL.APPL_NEW_IND
, APL.APPL_EMP_IND
, APL.APPL_CWK_IND
, APL.APPL_STRT_NEVNT_IND
, APL.ASMT_STRT_NEVNT_IND
, APL.ASMT_END_NEVNT_IND
, APL.OFFR_EXTD_NEVNT_IND
, APL.OFFR_RJCT_NEVNT_IND
, APL.OFFR_ACPT_NEVNT_IND
, APL.APPL_TERM_NEVNT_IND
, APL.APPL_TERM_VOL_NEVNT_IND
, APL.APPL_TERM_INVOL_NEVNT_IND
, APL.APPL_HIRE_NEVNT_IND
, APL.HIRE_NEVNT_IND
, APL.POST_HIRE_POW1_END_NEVNT_IND
, APL.POST_HIRE_PERF_NEVNT_IND
, APL.EMP_SPRTN_NEVNT_IND
, APL.HIRE_ORG_CHNG_IND
, APL.HIRE_JOB_CHNG_IND
, APL.HIRE_POS_CHNG_IND
, APL.HIRE_GRD_CHNG_IND
, APL.HIRE_LOC_CHNG_IND
, APL.CURRENT_RECORD_IND
, APL.CURRENT_STAGE_STRT_IND
, APL.GEN_RECORD_IND
, APL.INIT_APPL_STG_IND
, APL.ASMT_STG_IND
, APL.OFFR_EXTD_STG_IND
, APL.STRT_PNDG_STG_IND
, APL.HIRE_STG_IND
FROM HRI_MB_REC_CAND_PIPLN_CT APL
, HRI_MB_REC_VACANCY_CT VAC
WHERE APL.RVAC_VACNCY_FK = VAC.RVAC_VACNCY_FK ) TAB