APPS.GHR_POSN_COPY dependencies on PER_POSITION_DEFINITIONS

Line 95: 'FROM per_position_definitions pde WHERE id_flex_num= '||l_id_flex_num;

91: -- seqment values (excluding sequence) and returns the highest sequence found +1.
92:
93: l_cur := dbms_sql.open_cursor;
94: l_stmt := 'SELECT MAX(TO_NUMBER('||p_seq_location||')) max_seq '||
95: 'FROM per_position_definitions pde WHERE id_flex_num= '||l_id_flex_num;
96: --
97: l_seq_loc := SUBSTR(p_seq_location,8);
98:
99: --

Line 380: l_pde_data per_position_definitions%rowtype;

376: l_name varchar2(2000);
377: l_object_version_number number;
378: l_pos_data per_positions%rowtype;
379: l_result_code VARCHAR2(30);
380: l_pde_data per_position_definitions%rowtype;
381: l_dummy_number NUMBER;
382: l_new_pos_id per_positions.position_id%TYPE;
383: l_new_pos_name per_positions.name%TYPE;
384: l_seq_segment_name VARCHAR2(30);