[Home] [Help]
253: peo.effective_end_date,
254: scl.segment1 -- Bug#8497477
255: from per_all_people_f peo,
256: per_all_assignments_f asg,
257: per_periods_of_service pps,
258: per_person_type_usages_f ptu,
259: per_person_types ppt,
260: pay_all_payrolls_f ppf, -- Bug#8497477
261: hr_soft_coding_keyflex scl -- Bug#8497477
2024: pps.last_standard_process_date,
2025: p_m34_rec.effective_date
2026: from per_all_people_f peo,
2027: per_all_assignments_f asg,
2028: per_periods_of_service pps
2029: where asg.business_group_id = g_business_group_id
2030: and peo.business_group_id = g_business_group_id
2031: and peo.person_id = asg.person_id
2032: -- Bug 6864422 modified p_m34_rec.full_name to substr of peo.last_name length
2066: pps.last_standard_process_date,
2067: p_m34_rec.effective_date
2068: from per_all_people_f peo,
2069: per_all_assignments_f asg,
2070: per_periods_of_service pps
2071: where asg.business_group_id = g_business_group_id
2072: and peo.business_group_id = g_business_group_id
2073: and peo.person_id = asg.person_id
2074: -- Bug 6864422 modified p_m34_rec.full_name to substr of peo.last_name length
2104: pps.last_standard_process_date,
2105: p_m34_rec.effective_date
2106: from per_all_people_f peo,
2107: per_all_assignments_f asg,
2108: per_periods_of_service pps
2109: where asg.business_group_id = g_business_group_id
2110: and peo.business_group_id = g_business_group_id
2111: and peo.person_id = asg.person_id
2112: -- Bug 6864422 modified p_m34_rec.full_name to substr of peo.last_name length
2142: pps.last_standard_process_date,
2143: p_m34_rec.effective_date
2144: from per_all_people_f peo,
2145: per_all_assignments_f asg,
2146: per_periods_of_service pps
2147: where asg.business_group_id = g_business_group_id
2148: and peo.business_group_id = g_business_group_id
2149: and peo.person_id = asg.person_id
2150: -- Bug 6864422 modified p_m34_rec.full_name to substr of peo.last_name length