[Home] [Help]
887: decode(asgjob.effective_end_date,
888: to_date('4712/12/31', 'yyyy/mm/dd'),p_effective_date,
889: asgjob.effective_end_date+1),asgjob.effective_start_date))/12,1)
890: into l_years_in_job
891: from per_all_assignments_f asgjob
892: where asgjob.assignment_id=p_assignment_id
893: and asgjob.job_id = p_job_id
894: and asgjob.effective_start_date <= p_asg_effective_start_date;
895: --
909: decode(asgpos.effective_end_date,
910: to_date('4712/12/31', 'yyyy/mm/dd'),p_effective_date,
911: asgpos.effective_end_date+1),asgpos.effective_start_date))/12,1)
912: into l_years_in_position
913: from per_all_assignments_f asgpos
914: where asgpos.assignment_id=p_assignment_id
915: and asgpos.position_id = p_position_id
916: and asgpos.effective_start_date <= p_asg_effective_start_date;
917: --
931: decode(asggrd.effective_end_date,
932: to_date('4712/12/31', 'yyyy/mm/dd'),p_effective_date,
933: asggrd.effective_end_date+1),asggrd.effective_start_date))/12,1)
934: into l_years_in_grade
935: from per_all_assignments_f asggrd
936: where asggrd.assignment_id=p_assignment_id
937: and asggrd.grade_id = p_grade_id
938: and asggrd.effective_start_date <= p_asg_effective_start_date;
939: --
1097: ,paf.ass_attribute29 ass_attribute29
1098: ,paf.ass_attribute30 ass_attribute30
1099: ,perf.appraisal_id appraisal_id
1100: from per_all_people_f ppf
1101: ,per_all_assignments_f paf
1102: ,ben_per_in_ler pil
1103: ,per_all_people_f supv
1104: ,per_business_groups bg
1105: ,per_periods_of_service service_period
1507: cursor c_rank is
1508: select ext.assignment_extra_info_id
1509: ,pen.per_in_ler_id
1510: from per_assignment_extra_info ext
1511: ,per_all_assignments_f asg
1512: ,ben_prtt_enrt_rslt_f pen
1513: where ext.information_type = 'CWBRANK'
1514: and ext.aei_information_category = 'CWBRANK'
1515: and ext.aei_information3 is not null