[Home] [Help]
321: close get_qts_source;
322:
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
408: close get_hlta_source;
409:
410: if g_hlta_dff_name = 'JOB' then
411: g_hlta_sql_str:=
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
425: and jobdef.'||l_hlta_seg_name||' = pcv.pcv_information2';
426:
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
436: and pcv.pcv_information_category = ''PQP_GB_SWF_HLTA_STATUS_MAPPING''
437: and pap.'||l_hlta_seg_name||' = pcv.pcv_information2';
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
865: )
866: )
867:
868: -- 28 Days Condition
869: and decode(min_max.effective_end_date,hr_general.end_of_time,to_date(g_census_day),min_max.effective_end_date)-
870: min_max.effective_start_date >= 28
871: -- 28 Days Condition
872:
873: and (g_data_ret_type <> 'TYPE3'
960:
961: )
962:
963: -- 28 Days Condition
964: and decode(min_max.effective_end_date,hr_general.end_of_time,to_date(g_census_day),min_max.effective_end_date)-
965: min_max.effective_start_date >= 28
966: -- 28 Days Condition
967:
968: and (g_data_ret_type <> 'TYPE3'
1229: and csr_effective_date between paa.effective_start_date and paa.effective_end_date
1230: and csr_effective_date between pap.effective_start_date and pap.effective_end_date;
1231:
1232: cursor get_swf_dff_vaues(p_person_id in number) is
1233: select hr_general.decode_lookup('YES_NO',pei_information1 ) qt_sts,
1234: fnd_date.canonical_to_date(pei_information2) qt_status_date,
1235: pei_information3 qts_route,
1236: pei_information4 teacher_number,
1237: pei_information5 workforce_inc_typ,
1234: fnd_date.canonical_to_date(pei_information2) qt_status_date,
1235: pei_information3 qts_route,
1236: pei_information4 teacher_number,
1237: pei_information5 workforce_inc_typ,
1238: hr_general.decode_lookup('YES_NO',pei_information9) hlta_sts,
1239: pei_information10 origin
1240: from per_people_extra_info pei
1241: where pei.information_type = 'PQP_SCHOOL_WORKFORCE_CENSUS'
1242: and pei.person_id = p_person_id;
3028: end if;
3029:
3030: -- 4360
3031:
3032: if l_asg_dates_rec.contract_end_date <> hr_general.end_of_time then
3033: if not(l_asg_dates_rec.contract_st_date between to_date('01-09-'||(g_census_year-1),'DD-MM-YYYY') and to_date('31-08-'||(g_census_year),'DD-MM-YYYY'))
3034: and not(l_asg_dates_rec.contract_end_date between to_date('01-09-'||(g_census_year-1),'DD-MM-YYYY') and to_date('31-08-'||(g_census_year),'DD-MM-YYYY'))
3035: and l_asg_dates_rec.contract_end_date < g_census_day then
3036: l_arch := false;