[Home] [Help]
323: if l_qts_grade_seg_name is not null then
324: g_qts_sql_str:=
325: 'select max(hr_general.decode_lookup(''YES_NO'',pcv.pcv_information4))
326: from per_all_assignments_f paf,
327: per_grades pgr,
328: per_grade_definitions pgd ,
329: pqp_configuration_values pcv
330: where paf.business_group_id + 0 = :bg_id
331: and paf.business_group_id = pgr.business_group_id
353: if l_qts_route_dff_name = 'GRD' then
354: g_qts_route_sql_str:=
355: 'select max(pcv.pcv_information4)
356: from per_all_assignments_f paf,
357: per_grades pgr,
358: per_grade_definitions pgd ,
359: pqp_configuration_values pcv
360: where paf.business_group_id + 0 = :bg_id
361: and paf.business_group_id = pgr.business_group_id
455: if g_cont_post_src = 'GRD' then
456: g_cont_post_sql_str:=
457: 'select pcv.pcv_information4
458: from per_all_assignments_f paf,
459: per_grades pgr,
460: per_grade_definitions pgd ,
461: pqp_configuration_values pcv
462: where paf.business_group_id + 0 = :bg_id
463: and paf.business_group_id = pgr.business_group_id
547: if g_role_src = 'GRD' then
548: g_role_sql_str:=
549: 'select pcv.pcv_information4
550: from per_all_assignments_f paf,
551: per_grades pgr,
552: per_grade_definitions pgd ,
553: pqp_configuration_values pcv
554: where paf.business_group_id + 0 = :bg_id
555: and paf.business_group_id = pgr.business_group_id
3598:
3599: cursor pay_scale is
3600: select ps.parent_spine_id
3601: from per_grade_spines_f grs,
3602: per_grades gdt,
3603: per_parent_spines ps,
3604: per_all_assignments_f asg
3605: where grs.grade_id = gdt.grade_id
3606: and grs.parent_spine_id = ps.parent_spine_id
3722:
3723: if l_regional_spine_context = 'GRD' then
3724: l_regional_spine_sql_str :='select pcv.pcv_information4
3725: from per_all_assignments_f paf,
3726: per_grades pgr,
3727: per_grade_definitions pgd ,
3728: pqp_configuration_values pcv
3729: where paf.business_group_id + 0 = :bg_id
3730: and paf.business_group_id = pgr.business_group_id