6: p_effective_date IN date )
7: return number
8: is
9: l_position_id number(15) ;
10: cursor c1 is select position_id from hr_all_positions_f
11: where name = p_name
12: and effective_end_date = to_date('31124712','ddmmyyyy');
13: BEGIN
14: open c1 ;
22: p_effective_date IN date )
23: return number
24: is
25: l_position_definition_id number(15) ;
26: cursor c1 is select position_definition_id from hr_all_positions_f
27: where name = p_name
28: and effective_end_date = to_date('31124712','ddmmyyyy');
29: BEGIN
30: open c1 ;
150: p_effective_date IN date )
151: return number
152: is
153: l_position_ovn number(15) ;
154: cursor c1 is select object_version_number from hr_all_positions_f
155: where name = p_name
156: and effective_end_date = to_date('31124712','ddmmyyyy');
157: BEGIN
158: open c1 ;