16: Secure views were used for Performance enhancement.
17: A. Mahanty 14/04/2005 115.21 3491357 BRA Enh. Balance Value retrieval
18: modified.
19: J.N. Louw 23/06/2004 115.20 3694450 Modified assignment_nature
20: to reference fnd_lookup_values
21: instead of hr_lookups
22: R. Pahune 09/02/2004 115.19 3400581 Modified the cursor
23: csr_processed_assignments.
24: N. Venugopal 09/01/2004 115.18 3221746 removed set serverout on for gscc compliance.
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: (
673: SELECT max(paf2.effective_start_date)