[Home] [Help]
894: ,oru.organization_id
895: ,oru.name
896: ,loc.location_code
897: ,ppf.payroll_name
898: From per_all_assignments_f paf
899: ,per_assignment_status_types pat
900: ,hr_organization_information ori
901: ,hr_all_organization_units_vl oru
902: ,hr_locations loc
927: cursor c_time_periods is
928: select tpe.start_date
929: ,tpe.end_date
930: From per_time_periods tpe
931: ,per_all_assignments_f paf
932: Where paf.person_id = p_person_id
933: and paf.primary_flag = 'Y'
934: and paf.assignment_type <> 'C'
935: and paf.business_group_id = p_business_group_id
957: cursor c_next_pay_period is
958: select tpe.start_date
959: ,tpe.end_date
960: from per_time_periods tpe
961: ,per_all_assignments_f asg
962: where tpe.payroll_id = asg.payroll_id
963: and asg.person_id = p_person_id
964: and asg.assignment_type <> 'C'
965: and asg.primary_flag = 'Y'
971: --
972: cursor c_total_fte is
973: select sum(pab.value)
974: from per_all_people_f ppf
975: ,per_all_assignments_f paf
976: ,per_assignment_budget_values_f pab
977: where ppf.person_id = p_person_id
978: and paf.assignment_type <> 'C'
979: and ppf.business_group_id = p_business_group_id
1503: paf.effective_start_date and paf.effective_end_date;
1504: --
1505: Cursor c2 is
1506: Select assignment_id
1507: From per_all_assignments_f paf
1508: Where paf.person_id = p_person_id
1509: and paf.assignment_type <> 'C'
1510: And paf.primary_flag = 'Y'
1511: And paf.business_group_id = p_business_group_id
2397: And p_effective_date between paf.effective_start_date and paf.effective_end_date ;
2398: --
2399: Cursor c2 is
2400: Select assignment_id
2401: From per_all_assignments_f paf
2402: Where paf.person_id = p_person_id
2403: and paf.assignment_type <> 'C'
2404: And paf.primary_flag = 'Y'
2405: And paf.business_group_id = p_business_group_id