664: SELECT
665: nvl(fcl.meaning, 'A') nature
666: FROM
667: per_all_assignments_f ass
668: , per_assignment_extra_info aei
669: , fnd_lookup_values fcl
670: WHERE ass.assignment_id = c_assignment_id
671: AND ass.effective_start_date =
672: (
1431: FROM
1432: pay_assignment_actions paa
1433: , pay_payroll_actions ppa
1434: , hr_organization_information oit
1435: , per_assignment_extra_info aei
1436: , per_assignments_f asg
1437: , per_people_f pap
1438: , (select end_date from per_time_periods ptp where ptp.time_period_id = p_end_period_id) ptp
1439: WHERE