102: CLOSE asg_cur;
103:
104: x_composition_pk := x_asg_assignment_id + x_snapshot_date + x_instance_fk ;
105:
106: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;
107: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
108: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
109: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
110: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
103:
104: x_composition_pk := x_asg_assignment_id + x_snapshot_date + x_instance_fk ;
105:
106: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;
107: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
108: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
109: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
110: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
111: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
104: x_composition_pk := x_asg_assignment_id + x_snapshot_date + x_instance_fk ;
105:
106: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;
107: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
108: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
109: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
110: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
111: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
112: x_organization_fk := hri_edw_dim_sizing.get_size_org_pk;
105:
106: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;
107: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
108: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
109: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
110: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
111: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
112: x_organization_fk := hri_edw_dim_sizing.get_size_org_pk;
113: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;
106: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;
107: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
108: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
109: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
110: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
111: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
112: x_organization_fk := hri_edw_dim_sizing.get_size_org_pk;
113: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;
114: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
107: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
108: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
109: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
110: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
111: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
112: x_organization_fk := hri_edw_dim_sizing.get_size_org_pk;
113: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;
114: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
115: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;
108: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
109: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
110: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
111: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
112: x_organization_fk := hri_edw_dim_sizing.get_size_org_pk;
113: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;
114: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
115: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;
116: x_time_fk := hri_edw_dim_sizing.get_size_time_pk;
109: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
110: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
111: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
112: x_organization_fk := hri_edw_dim_sizing.get_size_org_pk;
113: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;
114: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
115: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;
116: x_time_fk := hri_edw_dim_sizing.get_size_time_pk;
117:
110: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
111: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
112: x_organization_fk := hri_edw_dim_sizing.get_size_org_pk;
113: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;
114: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
115: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;
116: x_time_fk := hri_edw_dim_sizing.get_size_time_pk;
117:
118:
111: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
112: x_organization_fk := hri_edw_dim_sizing.get_size_org_pk;
113: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;
114: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
115: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;
116: x_time_fk := hri_edw_dim_sizing.get_size_time_pk;
117:
118:
119: x_total_wrk_cmpstn := NVL(ceil(x_composition_pk + 1), 0)
112: x_organization_fk := hri_edw_dim_sizing.get_size_org_pk;
113: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;
114: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
115: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;
116: x_time_fk := hri_edw_dim_sizing.get_size_time_pk;
117:
118:
119: x_total_wrk_cmpstn := NVL(ceil(x_composition_pk + 1), 0)
120: + NVL(ceil(x_composition_pk + 1), 0)