APPS.GHR_POSITION_COPY dependencies on PER_POSITION_DEFINITIONS

Line 64: 'FROM per_position_definitions pde WHERE 1=1';

60: BEGIN
61:
62: l_cur := dbms_sql.open_cursor;
63: l_stmt := 'SELECT MAX(TO_NUMBER('||p_seq_location||')) max_seq '||
64: 'FROM per_position_definitions pde WHERE 1=1';
65: --
66: l_seq_loc := SUBSTR(p_seq_location,8);
67: --
68: FOR i IN 1..30 LOOP

Line 160: l_pde_data per_position_definitions%rowtype;

156: ,p_ovn OUT NOCOPY NUMBER) IS
157: --
158: l_pos_data hr_all_positions_f%rowtype;
159: l_result_code VARCHAR2(30);
160: l_pde_data per_position_definitions%rowtype;
161: l_dummy_number NUMBER;
162: l_new_pos_id hr_all_positions_f.position_id%TYPE;
163: l_new_pos_name hr_all_positions_f.name%TYPE;
164: l_seq_segment_name VARCHAR2(30);

Line 171: FROM per_position_definitions pde

167: l_seq_len NUMBER;
168: --
169: CURSOR cur_pde (p_position_definition_id IN NUMBER) IS
170: SELECT *
171: FROM per_position_definitions pde
172: WHERE pde.position_definition_id = p_position_definition_id;
173:
174: BEGIN
175: