[Home] [Help]
890: ,oru.organization_id
891: ,oru.name
892: ,loc.location_code
893: ,ppf.payroll_name
894: From per_all_assignments_f paf
895: ,per_assignment_status_types pat
896: ,hr_organization_information ori
897: ,hr_all_organization_units_vl oru
898: ,hr_locations loc
923: cursor c_time_periods is
924: select tpe.start_date
925: ,tpe.end_date
926: From per_time_periods tpe
927: ,per_all_assignments_f paf
928: Where paf.person_id = p_person_id
929: and paf.primary_flag = 'Y'
930: and paf.assignment_type <> 'C'
931: and paf.business_group_id = p_business_group_id
953: cursor c_next_pay_period is
954: select tpe.start_date
955: ,tpe.end_date
956: from per_time_periods tpe
957: ,per_all_assignments_f asg
958: where tpe.payroll_id = asg.payroll_id
959: and asg.person_id = p_person_id
960: and asg.assignment_type <> 'C'
961: and asg.primary_flag = 'Y'
967: --
968: cursor c_total_fte is
969: select sum(pab.value)
970: from per_all_people_f ppf
971: ,per_all_assignments_f paf
972: ,per_assignment_budget_values_f pab
973: where ppf.person_id = p_person_id
974: and paf.assignment_type <> 'C'
975: and ppf.business_group_id = p_business_group_id
1499: paf.effective_start_date and paf.effective_end_date;
1500: --
1501: Cursor c2 is
1502: Select assignment_id
1503: From per_all_assignments_f paf
1504: Where paf.person_id = p_person_id
1505: and paf.assignment_type <> 'C'
1506: And paf.primary_flag = 'Y'
1507: And paf.business_group_id = p_business_group_id
2387: And p_effective_date between paf.effective_start_date and paf.effective_end_date ;
2388: --
2389: Cursor c2 is
2390: Select assignment_id
2391: From per_all_assignments_f paf
2392: Where paf.person_id = p_person_id
2393: and paf.assignment_type <> 'C'
2394: And paf.primary_flag = 'Y'
2395: And paf.business_group_id = p_business_group_id