[Home] [Help]
190: cursor get_context_values is
191: select pcv_information1 ,
192: pcv_information3 ,
193: pcv_information4
194: from pqp_configuration_values pcv
195: where pcv.pcv_information_category = 'PQP_GB_SWF_TEACHER_NUM'
196: and pcv.business_group_id = g_business_group_id;
197:
198: cursor get_qts_source is
196: and pcv.business_group_id = g_business_group_id;
197:
198: cursor get_qts_source is
199: select pcv_information1
200: from pqp_configuration_values pcv
201: where pcv.pcv_information_category = 'PQP_GB_SWF_QTS_SRC'
202: and pcv.business_group_id = g_business_group_id;
203:
204: cursor get_qts_route_source is
203:
204: cursor get_qts_route_source is
205: select pcv_information1,
206: pcv_information2
207: from pqp_configuration_values pcv
208: where pcv.pcv_information_category = 'PQP_GB_SWF_QTS_ROUTE_SRC'
209: and pcv.business_group_id = g_business_group_id;
210:
211: cursor get_hlta_source is
211: cursor get_hlta_source is
212: select pcv_information1,
213: pcv_information4,
214: decode(pcv_information1,'JOB',pcv_information3, pcv_information5)
215: from pqp_configuration_values pcv
216: where pcv.pcv_information_category = 'PQP_GB_SWF_HLTA_STATUS_SRC'
217: and pcv.business_group_id = g_business_group_id;
218:
219: cursor get_post_source is
218:
219: cursor get_post_source is
220: select pcv_information1,
221: pcv_information3
222: from pqp_configuration_values pcv
223: where pcv.pcv_information_category = 'PQP_GB_SWF_POST_SOURCE'
224: and pcv.business_group_id = g_business_group_id;
225:
226: cursor get_origin_source is
226: cursor get_origin_source is
227: select pcv_information1,
228: pcv_information2,
229: pcv_information3
230: from pqp_configuration_values pcv
231: where pcv.pcv_information_category = 'PQP_GB_SWF_ORIGIN_SRC'
232: and pcv.business_group_id = g_business_group_id;
233:
234: cursor get_destination_source is
234: cursor get_destination_source is
235: select pcv_information1,
236: pcv_information2,
237: pcv_information3
238: from pqp_configuration_values pcv
239: where pcv.pcv_information_category = 'PQP_GB_SWF_DESTINATION_SRC' -- Check in database
240: and pcv.business_group_id = g_business_group_id;
241:
242: cursor get_role_source is
241:
242: cursor get_role_source is
243: select pcv_information1,
244: pcv_information3
245: from pqp_configuration_values pcv
246: where pcv.pcv_information_category = 'PQP_GB_SWF_ROLE_SOURCE'
247: and pcv.business_group_id = g_business_group_id;
248:
249: cursor get_addl_role_source is
249: cursor get_addl_role_source is
250: select pcv_information1,
251: pcv_information2,
252: pcv_information3
253: from pqp_configuration_values pcv
254: where pcv.pcv_information_category = 'PQP_GB_SWF_ADD_ROLE_SOURCE'
255: and pcv.business_group_id = g_business_group_id;
256:
257: ---
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
332: and pcv.business_group_id = paf.business_group_id
333: and pgr.grade_definition_id = pgd.grade_definition_id
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
362: and pcv.business_group_id = paf.business_group_id
363: and pgr.grade_definition_id = pgd.grade_definition_id
374: 'select max(pcv.pcv_information4) QT_status
375: from per_all_assignments_f paf,
376: per_jobs job,
377: per_job_definitions jobdef ,
378: pqp_configuration_values pcv
379: where paf.business_group_id + 0 = :bg_id
380: and paf.business_group_id = job.business_group_id
381: and pcv.business_group_id = paf.business_group_id
382: and job.job_definition_id = jobdef.job_definition_id
390: 'select max(pcv.pcv_information4) QT_status
391: from per_all_assignments_f paf,
392: per_positions pos,
393: per_position_definitions posdef ,
394: pqp_configuration_values pcv
395: where paf.business_group_id + 0 = :bg_id
396: and paf.business_group_id = pos.business_group_id
397: and pcv.business_group_id = paf.business_group_id
398: and pos.position_definition_id = posdef.position_definition_id
412: 'select max(hr_general.decode_lookup(''YES_NO'',pcv.pcv_information3))
413: from per_all_assignments_f paf,
414: per_jobs job,
415: per_job_definitions jobdef ,
416: pqp_configuration_values pcv
417: where paf.business_group_id + 0 = :bg_id
418: and paf.business_group_id = job.business_group_id
419: and pcv.business_group_id = paf.business_group_id
420: and job.job_definition_id = jobdef.job_definition_id
427: elsif g_hlta_dff_name = 'PER_PEOPLE' then
428: g_hlta_sql_str:=
429: 'select max(hr_general.decode_lookup(''YES_NO'',pcv.pcv_information3))
430: from per_all_people_f pap,
431: pqp_configuration_values pcv
432: where attribute_category = '''||l_hlta_context_name||'''
433: and pap.person_id = :person_id
434: and :effective_date between pap.effective_start_date and pap.effective_end_date
435: and pcv.business_group_id = pap.business_group_id
438: elsif g_hlta_dff_name = 'PER_ASSIGNMENTS' then
439: g_hlta_sql_str:=
440: 'select max(hr_general.decode_lookup(''YES_NO'',pcv.pcv_information3))
441: from per_all_assignments_f paf,
442: pqp_configuration_values pcv
443: where ass_attribute_category = '''||l_hlta_context_name||'''
444: and paf.person_id = :person_id
445: and :effective_date between paf.effective_start_date and paf.effective_end_date
446: and pcv.business_group_id = paf.business_group_id
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
464: and pcv.business_group_id = paf.business_group_id
465: and pgr.grade_definition_id = pgd.grade_definition_id
476: 'select pcv.pcv_information4
477: from per_all_assignments_f paf,
478: per_jobs job,
479: per_job_definitions jobdef ,
480: pqp_configuration_values pcv
481: where paf.business_group_id + 0 = :bg_id
482: and paf.business_group_id = job.business_group_id
483: and pcv.business_group_id = paf.business_group_id
484: and job.job_definition_id = jobdef.job_definition_id
492: 'select pcv.pcv_information4
493: from per_all_assignments_f paf,
494: per_positions pos,
495: per_position_definitions posdef ,
496: pqp_configuration_values pcv
497: where paf.business_group_id + 0 = :bg_id
498: and paf.business_group_id = pos.business_group_id
499: and pcv.business_group_id = paf.business_group_id
500: and pos.position_definition_id = posdef.position_definition_id
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
556: and pcv.business_group_id = paf.business_group_id
557: and pgr.grade_definition_id = pgd.grade_definition_id
568: 'select pcv.pcv_information4
569: from per_all_assignments_f paf,
570: per_jobs job,
571: per_job_definitions jobdef ,
572: pqp_configuration_values pcv
573: where paf.business_group_id + 0 = :bg_id
574: and paf.business_group_id = job.business_group_id
575: and pcv.business_group_id = paf.business_group_id
576: and job.job_definition_id = jobdef.job_definition_id
584: 'select pcv.pcv_information4
585: from per_all_assignments_f paf,
586: per_positions pos,
587: per_position_definitions posdef ,
588: pqp_configuration_values pcv
589: where paf.business_group_id + 0 = :bg_id
590: and paf.business_group_id = pos.business_group_id
591: and pcv.business_group_id = paf.business_group_id
592: and pos.position_definition_id = posdef.position_definition_id
605: g_addl_role_sql_str:=
606: 'select pcv.pcv_information4
607: from per_all_assignments_f paa,
608: per_position_extra_info pei,
609: pqp_configuration_values pcv
610: where paa.assignment_id = :p_assignment_id
611: and pei.position_id = paa.position_id
612: and pei.information_type = '''||l_addl_role_context||'''
613: and pcv.pcv_information_category = ''PQP_GB_SWF_ROLE_MAPPING''
618: g_addl_role_sql_str:=
619: 'select pcv.pcv_information4
620: from per_all_assignments_f paa,
621: per_job_extra_info jei,
622: pqp_configuration_values pcv
623: where paa.assignment_id = :p_assignment_id
624: and jei.job_id = paa.job_id
625: and jei.information_type = '''||l_addl_role_context||'''
626: and pcv.pcv_information_category = ''PQP_GB_SWF_ROLE_MAPPING''
630: elsif g_addl_role_src = 'Assignment Developer DF' then
631: g_addl_role_sql_str:=
632: 'select pcv.pcv_information4
633: from per_assignment_extra_info aei,
634: pqp_configuration_values pcv
635: where aei.assignment_id = :p_assignment_id
636: and aei.information_type = '''||l_addl_role_context||'''
637: and pcv.pcv_information_category = ''PQP_GB_SWF_ROLE_MAPPING''
638: and pcv.business_group_id = :bg_id
998:
999:
1000: cursor contract_type is
1001: select distinct pcv_information1
1002: from pqp_configuration_values
1003: where pcv_information_category = 'PQP_GB_SWF_CONTRACT_TYPE'
1004: and business_group_id = g_business_group_id;
1005:
1006: -- Local variables
1166: return null;
1167: end get_teachers_number;
1168:
1169: ------------------------------function get_dcsf_values--------------------------
1170: -- This function queries PQP_CONFIGURATION_VALUES table for the given context
1171: -- and returns the dcsf equivalent for the passed value.
1172: -- This function is used for the following context.
1173: -- PQP_GB_SWF_ETHNIC_CODES Staff Details - Ethnic Origin
1174: -- PQP_GB_SWF_PAY_SCALE_MAPPING Pay - Pay Scale
1176: -- PQP_GB_SWF_QUAL_SUBJECT_MAP Qualifications - Subject
1177: function get_dcsf_values(p_context_name in varchar2,
1178: p_value in varchar2) return varchar2
1179: is
1180: l_return pqp_configuration_values.pcv_attribute2%type;
1181: l_proc constant varchar2(50):= g_package||'get_dcsf_values';
1182:
1183: cursor get_config_values (p_context_name in varchar2 , p_value in varchar2) is
1184: select pcv_information2
1181: l_proc constant varchar2(50):= g_package||'get_dcsf_values';
1182:
1183: cursor get_config_values (p_context_name in varchar2 , p_value in varchar2) is
1184: select pcv_information2
1185: from pqp_configuration_values
1186: where pcv_information_category = p_context_name
1187: and pcv_information1 = p_value
1188: and business_group_id = g_business_group_id;
1189:
1946: and p_effective_date between paa.effective_start_date and paa.effective_end_date;
1947:
1948: cursor role_dcsf(p_role in varchar2) is
1949: select pcv_information4
1950: from pqp_configuration_values
1951: where business_group_id = g_business_group_id
1952: and pcv_information_category = 'PQP_GB_SWF_ROLE_MAPPING'
1953: and pcv_information2 = p_role;
1954:
2030: p_hrs_rec out nocopy act_info_rec) return boolean is
2031:
2032: cursor get_hrs_source is
2033: select pcv_information1 hrs_source
2034: from pqp_configuration_values pcv
2035: where pcv.pcv_information_category = 'PQP_GB_SWF_HOURS'
2036: and pcv.business_group_id = g_business_group_id;
2037:
2038: cursor get_hrs_details(p_contract_type in varchar2) is
2041: pcv_information3 hrs_per_wk_formula,
2042: pcv_information4 wks_per_yr_source,
2043: pcv_information5 wks_per_yr_formula,
2044: pcv_information6 wks_per_yr_column
2045: from pqp_configuration_values pcv
2046: where pcv.pcv_information_category = 'PQP_GB_SWF_HOURS'
2047: and nvl(pcv.pcv_information2,p_contract_type) = p_contract_type
2048: and pcv.business_group_id = g_business_group_id;
2049:
2048: and pcv.business_group_id = g_business_group_id;
2049:
2050: cursor get_hrs_details_asg (p_staff_cat in varchar2) IS
2051: select pcv_information8 default_weeks_per_yr
2052: from pqp_configuration_values pcv
2053: where pcv.pcv_information_category = 'PQP_GB_SWF_HOURS'
2054: and pcv.pcv_information7 = decode(p_staff_cat,1,'REGULAR_TEACHER',2,'AGENCY_TEACHER',3,'TEACHING_ASSISTANT',4,'OTHER_SUPPORT_STAFF')
2055: and pcv.business_group_id = g_business_group_id;
2056:
2104: and g_census_day between val.effective_start_date and val.effective_end_date;
2105:
2106: cursor get_fte_src is
2107: select pcv_information1,pcv_information2
2108: from pqp_configuration_values pcv
2109: where pcv.pcv_information_category = 'PQP_GB_SWF_FTE_HOURS'
2110: and pcv.business_group_id = g_business_group_id;
2111:
2112: cursor get_fte_budget_hrs is
2119: l_proc constant varchar2(50) := g_package || ' fetch_hours_details';
2120: l_hrs_details_rec get_hrs_details%rowtype;
2121: l_contract_type pqp_assignment_attributes_f.contract_type%type;
2122: l_assignment_number per_all_assignments_f.assignment_number%type;
2123: l_hrs_src pqp_configuration_values.pcv_information1%type;
2124: l_hours_per_week varchar2(20);
2125: l_weeks_per_yr varchar2(20);
2126: l_work_pattern pqp_assignment_attributes_f.work_pattern%type;
2127: l_frequency per_all_assignments_f.frequency%type;
2445: l_proc constant varchar2(50):= g_package||'fetch_absence_details';
2446:
2447: cursor get_abs_source is
2448: select pcv_information1
2449: from pqp_configuration_values pcv
2450: where pcv.pcv_information_category = 'PQP_GB_SWF_ABSENCE_CODE'
2451: and pcv.business_group_id = g_business_group_id;
2452:
2453: --
2450: where pcv.pcv_information_category = 'PQP_GB_SWF_ABSENCE_CODE'
2451: and pcv.business_group_id = g_business_group_id;
2452:
2453: --
2454: l_abs_source pqp_configuration_values.pcv_information1%type;
2455: l_date_end_missing varchar2(1) := 'N';
2456: l_last_before_first varchar2(1) := 'N';
2457: l_last_after_census varchar2(1) := 'N';
2458: l_first_day_of_abs varchar2(1) := 'N';
2483: p_estab_no
2484: bulk collect into p_abs_tab
2485: from per_absence_attendances paat,
2486: per_absence_attendance_types paatt,
2487: pqp_configuration_values pcv
2488: where paat.absence_attendance_type_id = paatt.absence_attendance_type_id
2489: and paat.person_id = p_person_id
2490: and pcv.pcv_information_category = 'PQP_GB_SWF_ABSENCE_CODE'
2491: and pcv_information1 = 'ABSENCE_CATEGORY'
2512: pcv.pcv_information5 absence_type,
2513: p_estab_no
2514: bulk collect into p_abs_tab
2515: from per_absence_attendances paat,
2516: pqp_configuration_values pcv
2517: where paat.person_id = p_person_id
2518: and pcv.pcv_information_category = 'PQP_GB_SWF_ABSENCE_CODE'
2519: and pcv_information1 = 'ABSENCE_TYPE'
2520: and pcv.business_group_id = g_business_group_id
2541: p_estab_no
2542: bulk collect into p_abs_tab
2543: from per_absence_attendances paat,
2544: per_abs_attendance_reasons paatr,
2545: pqp_configuration_values pcv
2546: where paatr.abs_attendance_reason_id = paat.abs_attendance_reason_id
2547: and paat.person_id = p_person_id
2548: and pcv.pcv_information_category = 'PQP_GB_SWF_ABSENCE_CODE'
2549: and pcv_information1 = 'ABSENCE_REASON'
2743: and paa.assignment_id = att.assignment_id;
2744:
2745: cursor get_date_of_arrival_src is
2746: select pcv_information1, pcv_information2
2747: from pqp_configuration_values
2748: where business_group_id = g_business_group_id
2749: and pcv_information_category = 'PQP_GB_SWF_CNTRT_ARRIVAL_DATE';
2750:
2751: cursor get_post(p_emp_or_asgcat in varchar2) is
2749: and pcv_information_category = 'PQP_GB_SWF_CNTRT_ARRIVAL_DATE';
2750:
2751: cursor get_post(p_emp_or_asgcat in varchar2) is
2752: select pcv_information4
2753: from pqp_configuration_values pcv
2754: where pcv.pcv_information_category = 'PQP_GB_SWF_POST_MAPPING'
2755: and pcv_information2 = p_emp_or_asgcat
2756: and pcv.business_group_id = g_business_group_id;
2757:
2756: and pcv.business_group_id = g_business_group_id;
2757:
2758: cursor get_origin(l_origin in varchar2) is
2759: select pcv_information3
2760: from pqp_configuration_values pcv
2761: where pcv.pcv_information_category = 'PQP_GB_SWF_ORIGIN_MAPPING'
2762: and pcv_information2 = l_origin
2763: and pcv.business_group_id = g_business_group_id;
2764:
2763: and pcv.business_group_id = g_business_group_id;
2764:
2765: cursor get_destination(l_destination in varchar2) is
2766: select pcv_information3
2767: from pqp_configuration_values pcv
2768: where pcv.pcv_information_category = 'PQP_GB_SWF_DESTINATION_MAPPING'
2769: and pcv_information2 = l_destination
2770: and pcv.business_group_id = g_business_group_id;
2771:
2782: and pei.person_id = p_person_id;
2783:
2784: cursor get_pqp_contract_type_dcsf(p_pqp_cont_type in pqp_assignment_attributes_f.contract_type%type ) is
2785: select pcv_information5
2786: from pqp_configuration_values pcv
2787: where pcv.pcv_information_category = 'PQP_GB_SWF_CONTRACT_TYPE'
2788: and pcv_information4 = p_pqp_cont_type
2789: and pcv.business_group_id = g_business_group_id;
2790:
2789: and pcv.business_group_id = g_business_group_id;
2790:
2791: cursor get_asg_contract_type_dcsf(p_cont_type in per_all_assignments_f.employment_category%type ) is
2792: select pcv_information5
2793: from pqp_configuration_values pcv
2794: where pcv.pcv_information_category = 'PQP_GB_SWF_CONTRACT_TYPE'
2795: and pcv_information3 = p_cont_type
2796: and pcv.business_group_id = g_business_group_id;
2797:
2800: l_asg_dates_rec get_assignment_dates%rowtype;
2801: l_post hr_lookups.lookup_code%type;
2802: l_post_emp_cat hr_lookups.lookup_code%type;
2803: l_post_asg_cat hr_lookups.lookup_code%type;
2804: l_date_of_arrival_src pqp_configuration_values.pcv_information1%type;
2805: l_date_of_arrival date;
2806: l_daily_rate varchar2(150);
2807: l_origin hr_lookups.lookup_code%type;
2808: l_dcsf_origin hr_lookups.lookup_code%type;
3401: max(decode(seq, 2, subject_dcsf, null)) subject_2
3402: from (select subject_dcsf, seq
3403: from (select pcv.pcv_information2 subject_dcsf, row_number() over(order by major desc) seq
3404: from per_qualifications qual, per_subjects_taken sub,
3405: pqp_configuration_values pcv
3406: where qual.qualification_id = sub.qualification_id
3407: and qual.person_id = p_person_id
3408: and qual.qualification_id = p_qual_id
3409: and pcv.pcv_information_category = 'PQP_GB_SWF_QUAL_SUBJECT_MAP'
3412: where seq < 3);
3413:
3414: cursor get_qual_code_src is
3415: select pcv_information1
3416: from pqp_configuration_values pcv
3417: where pcv.pcv_information_category = 'PQP_GB_SWF_QUAL_CODE_MAP'
3418: and pcv.business_group_id = g_business_group_id;
3419:
3420: cursor get_qual_code_dcsf_cat(p_qual_cat in varchar2) is
3418: and pcv.business_group_id = g_business_group_id;
3419:
3420: cursor get_qual_code_dcsf_cat(p_qual_cat in varchar2) is
3421: select pcv_information5
3422: from pqp_configuration_values pcv
3423: where pcv.pcv_information_category = 'PQP_GB_SWF_QUAL_CODE_MAP'
3424: and pcv.pcv_information3 = p_qual_cat
3425: and pcv.business_group_id = g_business_group_id;
3426:
3425: and pcv.business_group_id = g_business_group_id;
3426:
3427: cursor get_qual_code_dcsf_typ(p_qual_typ in varchar2) is
3428: select pcv_information5
3429: from pqp_configuration_values pcv
3430: where pcv.pcv_information_category = 'PQP_GB_SWF_QUAL_CODE_MAP'
3431: and pcv.pcv_information4 = p_qual_typ
3432: and pcv.business_group_id = g_business_group_id;
3433:
3434: l_proc constant varchar2(50) := g_package || ' fetch_qualification_details';
3435: l_qual_rec get_qual_details%rowtype;
3436: l_subject1 per_subjects_taken.subject%type;
3437: l_subject2 per_subjects_taken.subject%type;
3438: l_qual_code_src pqp_configuration_values.pcv_information1%type;
3439: l_qual_code_dcsf pqp_configuration_values.pcv_information1%type;
3440: l_qual_tab_idx number := 1;
3441: l_invalid_qual_code varchar2(1) := 'N';
3442: l_missing_qual_code varchar2(1) := 'N';
3435: l_qual_rec get_qual_details%rowtype;
3436: l_subject1 per_subjects_taken.subject%type;
3437: l_subject2 per_subjects_taken.subject%type;
3438: l_qual_code_src pqp_configuration_values.pcv_information1%type;
3439: l_qual_code_dcsf pqp_configuration_values.pcv_information1%type;
3440: l_qual_tab_idx number := 1;
3441: l_invalid_qual_code varchar2(1) := 'N';
3442: l_missing_qual_code varchar2(1) := 'N';
3443: l_sub_code_1_invalid varchar2(1) := 'N';
3610: and p_effective_date between grs.effective_start_date and grs.effective_end_date;
3611:
3612: cursor pay_scale_dcsf(p_pay_scale in per_parent_spines.parent_spine_id%type) is
3613: select pcv.pcv_information2
3614: from pqp_configuration_values pcv
3615: where pcv.pcv_information_category = 'PQP_GB_SWF_PAY_SCALE_MAPPING'
3616: and pcv.pcv_information1 = p_pay_scale
3617: and pcv.business_group_id = g_business_group_id;
3618:
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
3637: and pcv.pcv_information2 = p_spinal_point
3638: and pcv.business_group_id = g_business_group_id;
3644: and p_effective_date between pgr.effective_start_date and pgr.effective_end_date;
3645:
3646: cursor get_regional_spine_source is
3647: select pcv_information1, pcv_information2, pcv_information3
3648: from pqp_configuration_values pcv
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,
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
3658: and p_spinal_point between pcv.pcv_information2 and pcv.pcv_information3
3659: and pcv.business_group_id = g_business_group_id;
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
3731: and pcv.business_group_id = paf.business_group_id
3732: and pgr.grade_definition_id = pgd.grade_definition_id
4004: and pas.per_system_status = 'ACTIVE_ASSIGN';
4005:
4006: cursor contract_type is
4007: select distinct pcv_information1
4008: from pqp_configuration_values
4009: where pcv_information_category = 'PQP_GB_SWF_CONTRACT_TYPE'
4010: and business_group_id = g_business_group_id;
4011:
4012: cursor get_fte_src is
4010: and business_group_id = g_business_group_id;
4011:
4012: cursor get_fte_src is
4013: select pcv_information1,pcv_information2
4014: from pqp_configuration_values pcv
4015: where pcv.pcv_information_category = 'PQP_GB_SWF_FTE_HOURS'
4016: and pcv.business_group_id = g_business_group_id;
4017:
4018: begin