eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_EDW_WRK_ACTVTY_F_SIZING dependencies on HRI_EDW_DIM_SIZING

Line 274: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;

270: ,x_establishment_id;
271: CLOSE asg_cur;
272:
273: x_assignment_change_pk := x_assignment_id + x_effective_start_date + x_instance_fk;
274: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;
275: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
276: x_assignment_change_fk := hri_edw_dim_sizing.get_size_acg_pk;
277: x_geography_from_fk := hri_edw_dim_sizing.get_size_geog_pk;
278: x_geography_to_fk := x_geography_from_fk;

Line 275: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;

271: CLOSE asg_cur;
272:
273: x_assignment_change_pk := x_assignment_id + x_effective_start_date + x_instance_fk;
274: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;
275: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
276: x_assignment_change_fk := hri_edw_dim_sizing.get_size_acg_pk;
277: x_geography_from_fk := hri_edw_dim_sizing.get_size_geog_pk;
278: x_geography_to_fk := x_geography_from_fk;
279: x_grade_from_fk := hri_edw_dim_sizing.get_size_grd_pk;

Line 276: x_assignment_change_fk := hri_edw_dim_sizing.get_size_acg_pk;

272:
273: x_assignment_change_pk := x_assignment_id + x_effective_start_date + x_instance_fk;
274: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;
275: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
276: x_assignment_change_fk := hri_edw_dim_sizing.get_size_acg_pk;
277: x_geography_from_fk := hri_edw_dim_sizing.get_size_geog_pk;
278: x_geography_to_fk := x_geography_from_fk;
279: x_grade_from_fk := hri_edw_dim_sizing.get_size_grd_pk;
280: x_grade_to_fk := x_grade_from_fk;

Line 277: x_geography_from_fk := hri_edw_dim_sizing.get_size_geog_pk;

273: x_assignment_change_pk := x_assignment_id + x_effective_start_date + x_instance_fk;
274: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;
275: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
276: x_assignment_change_fk := hri_edw_dim_sizing.get_size_acg_pk;
277: x_geography_from_fk := hri_edw_dim_sizing.get_size_geog_pk;
278: x_geography_to_fk := x_geography_from_fk;
279: x_grade_from_fk := hri_edw_dim_sizing.get_size_grd_pk;
280: x_grade_to_fk := x_grade_from_fk;
281: x_job_from_fk := hri_edw_dim_sizing.get_size_job_pk;

Line 279: x_grade_from_fk := hri_edw_dim_sizing.get_size_grd_pk;

275: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
276: x_assignment_change_fk := hri_edw_dim_sizing.get_size_acg_pk;
277: x_geography_from_fk := hri_edw_dim_sizing.get_size_geog_pk;
278: x_geography_to_fk := x_geography_from_fk;
279: x_grade_from_fk := hri_edw_dim_sizing.get_size_grd_pk;
280: x_grade_to_fk := x_grade_from_fk;
281: x_job_from_fk := hri_edw_dim_sizing.get_size_job_pk;
282: x_job_to_fk := x_job_from_fk;
283: x_organization_from_fk := hri_edw_dim_sizing.get_size_org_pk;

Line 281: x_job_from_fk := hri_edw_dim_sizing.get_size_job_pk;

277: x_geography_from_fk := hri_edw_dim_sizing.get_size_geog_pk;
278: x_geography_to_fk := x_geography_from_fk;
279: x_grade_from_fk := hri_edw_dim_sizing.get_size_grd_pk;
280: x_grade_to_fk := x_grade_from_fk;
281: x_job_from_fk := hri_edw_dim_sizing.get_size_job_pk;
282: x_job_to_fk := x_job_from_fk;
283: x_organization_from_fk := hri_edw_dim_sizing.get_size_org_pk;
284: x_organization_to_fk := x_organization_from_fk;
285: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;

Line 283: x_organization_from_fk := hri_edw_dim_sizing.get_size_org_pk;

279: x_grade_from_fk := hri_edw_dim_sizing.get_size_grd_pk;
280: x_grade_to_fk := x_grade_from_fk;
281: x_job_from_fk := hri_edw_dim_sizing.get_size_job_pk;
282: x_job_to_fk := x_job_from_fk;
283: x_organization_from_fk := hri_edw_dim_sizing.get_size_org_pk;
284: x_organization_to_fk := x_organization_from_fk;
285: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;
286: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
287: x_position_from_fk := hri_edw_dim_sizing.get_size_pos_pk;

Line 285: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;

281: x_job_from_fk := hri_edw_dim_sizing.get_size_job_pk;
282: x_job_to_fk := x_job_from_fk;
283: x_organization_from_fk := hri_edw_dim_sizing.get_size_org_pk;
284: x_organization_to_fk := x_organization_from_fk;
285: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;
286: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
287: x_position_from_fk := hri_edw_dim_sizing.get_size_pos_pk;
288: x_position_to_fk := x_position_from_fk;
289: x_movement_fk := hri_edw_dim_sizing.get_size_mvt_pk;

Line 286: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;

282: x_job_to_fk := x_job_from_fk;
283: x_organization_from_fk := hri_edw_dim_sizing.get_size_org_pk;
284: x_organization_to_fk := x_organization_from_fk;
285: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;
286: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
287: x_position_from_fk := hri_edw_dim_sizing.get_size_pos_pk;
288: x_position_to_fk := x_position_from_fk;
289: x_movement_fk := hri_edw_dim_sizing.get_size_mvt_pk;
290: x_reason_fk := hri_edw_dim_sizing.get_size_rsn_pk;

Line 287: x_position_from_fk := hri_edw_dim_sizing.get_size_pos_pk;

283: x_organization_from_fk := hri_edw_dim_sizing.get_size_org_pk;
284: x_organization_to_fk := x_organization_from_fk;
285: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;
286: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
287: x_position_from_fk := hri_edw_dim_sizing.get_size_pos_pk;
288: x_position_to_fk := x_position_from_fk;
289: x_movement_fk := hri_edw_dim_sizing.get_size_mvt_pk;
290: x_reason_fk := hri_edw_dim_sizing.get_size_rsn_pk;
291: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;

Line 289: x_movement_fk := hri_edw_dim_sizing.get_size_mvt_pk;

285: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;
286: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
287: x_position_from_fk := hri_edw_dim_sizing.get_size_pos_pk;
288: x_position_to_fk := x_position_from_fk;
289: x_movement_fk := hri_edw_dim_sizing.get_size_mvt_pk;
290: x_reason_fk := hri_edw_dim_sizing.get_size_rsn_pk;
291: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
292: x_time_from_fk := hri_edw_dim_sizing.get_size_time_pk;
293: x_time_to_fk := x_time_from_fk;

Line 290: x_reason_fk := hri_edw_dim_sizing.get_size_rsn_pk;

286: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
287: x_position_from_fk := hri_edw_dim_sizing.get_size_pos_pk;
288: x_position_to_fk := x_position_from_fk;
289: x_movement_fk := hri_edw_dim_sizing.get_size_mvt_pk;
290: x_reason_fk := hri_edw_dim_sizing.get_size_rsn_pk;
291: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
292: x_time_from_fk := hri_edw_dim_sizing.get_size_time_pk;
293: x_time_to_fk := x_time_from_fk;
294:

Line 291: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;

287: x_position_from_fk := hri_edw_dim_sizing.get_size_pos_pk;
288: x_position_to_fk := x_position_from_fk;
289: x_movement_fk := hri_edw_dim_sizing.get_size_mvt_pk;
290: x_reason_fk := hri_edw_dim_sizing.get_size_rsn_pk;
291: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
292: x_time_from_fk := hri_edw_dim_sizing.get_size_time_pk;
293: x_time_to_fk := x_time_from_fk;
294:
295:

Line 292: x_time_from_fk := hri_edw_dim_sizing.get_size_time_pk;

288: x_position_to_fk := x_position_from_fk;
289: x_movement_fk := hri_edw_dim_sizing.get_size_mvt_pk;
290: x_reason_fk := hri_edw_dim_sizing.get_size_rsn_pk;
291: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
292: x_time_from_fk := hri_edw_dim_sizing.get_size_time_pk;
293: x_time_to_fk := x_time_from_fk;
294:
295:
296: