2906: ,csr_v_effective_date DATE
2907: )
2908: IS
2909: SELECT nvl(TRUNC
2910: (fnd_number.canonical_to_number (segment13)),l_full_time)
2911: /* change this to the field which we are going to add for part time employee */
2912: FROM per_all_assignments_f paaf
2913: ,
2914: -- per_all_people_f papf,
3105: -- paaf.business_group_id,
3106: -- paaf.person_id,
3107: -- greatest(paaf.effective_start_date,'01-Apr-2000'),
3108: -- least(paaf.effective_end_date,'31-Mar-2001'),
3109: fnd_number.canonical_to_number (segment9) perc --segment9 perc --Existing bug fixed as part of 9747212
3110: , LEAST (paaf.effective_end_date, csr_v_ey_end)
3111: - GREATEST (paaf.effective_start_date
3112: ,csr_v_ey_start)
3113: + 1 "DAYS"