DBA Data[Home] [Help]

APPS.HR_EDW_WRK_CMPSTN_F_SIZING dependencies on HRI_EDW_DIM_SIZING

Line 106: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;

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;

Line 107: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_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;

Line 108: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_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;

Line 109: x_geography_fk := hri_edw_dim_sizing.get_size_geog_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;

Line 110: x_grade_fk := hri_edw_dim_sizing.get_size_grd_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;

Line 111: x_job_fk := hri_edw_dim_sizing.get_size_job_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;

Line 112: x_organization_fk := hri_edw_dim_sizing.get_size_org_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;

Line 113: x_person_fk := hri_edw_dim_sizing.get_size_psn_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:

Line 114: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_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:
118:

Line 115: x_position_fk := hri_edw_dim_sizing.get_size_pos_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:
119: x_total_wrk_cmpstn := NVL(ceil(x_composition_pk + 1), 0)

Line 116: x_time_fk := hri_edw_dim_sizing.get_size_time_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)
120: + NVL(ceil(x_composition_pk + 1), 0)