[Home] [Help]
3619: cursor spinal_points is
3620: select spinal_point,psp.spinal_point_id
3621: from per_spinal_point_placements_f pspp,
3622: per_spinal_point_steps_f psps,
3623: per_spinal_points psp
3624: where pspp.assignment_id = p_assignment_id
3625: and pspp.step_id = psps.step_id
3626: and psps.spinal_point_id = psp.spinal_point_id
3627: and p_effective_date between pspp.effective_start_date and pspp.effective_end_date
3628: and p_effective_date between psps.effective_start_date and psps.effective_end_date;
3629:
3630:
3631: cursor spinal_point_dcsf(p_pay_scale in per_parent_spines.parent_spine_id%type,
3632: p_spinal_point in per_spinal_points.spinal_point_id%type) is
3633: select pcv.pcv_information3
3634: from pqp_configuration_values pcv
3635: where pcv.pcv_information_category = 'PQP_GB_SWF_SPINE_POINT_MAPPING'
3636: and pcv.pcv_information1 = p_pay_scale
3649: where pcv.pcv_information_category = 'PQP_GB_SWF_REG_SPINE_SRC'
3650: and pcv.business_group_id = g_business_group_id;
3651:
3652: cursor reg_spinal_point_dcsf(p_pay_scale in per_parent_spines.name%type,
3653: p_spinal_point in per_spinal_points.spinal_point%type) is
3654: select pcv.pcv_information4
3655: from pqp_configuration_values pcv
3656: where pcv.pcv_information_category = 'PQP_GB_SWF_REG_SPINE_MAP_PYSCL'
3657: and pcv.pcv_information1 = p_pay_scale
3669: l_regional_spine_def_val varchar2(30);
3670: l_regional_spine_sql_str varchar2(3000);
3671: l_pay_scale per_parent_spines.parent_spine_id%type;
3672: l_pay_scale_dcsf hr_lookups.lookup_code%type;
3673: l_spinal_point per_spinal_points.spinal_point%type;
3674: l_spinal_point_dcsf hr_lookups.lookup_code%type;
3675: l_reg_spinal_point_dcsf hr_lookups.lookup_code%type;
3676: l_safe_grd_sal varchar2(5);
3677: l_arch boolean := true;