APPS.GHR_POSN_COPY dependencies on PER_POSITIONS

Line 166: l_stmt := l_stmt||' AND EXISTS (SELECT 1 FROM per_positions pos'

162: l_stmt := l_stmt||' AND SEGMENT'||i||' = '''||replace(p_segment30,'''','''''')||'''';
163: END IF;
164: END IF;
165: END LOOP;
166: l_stmt := l_stmt||' AND EXISTS (SELECT 1 FROM per_positions pos'
167: ||' WHERE pde.position_definition_id = pos.position_definition_id)';
168:
169: --
170: -- dbms_sql.parse format (number, statement , language_flag)

Line 378: l_pos_data per_positions%rowtype;

374: l_effective_end_date date;
375: l_position_definition_id number;
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;

Line 382: l_new_pos_id per_positions.position_id%TYPE;

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);
385: l_new_seq VARCHAR2(150);
386: l_agency_seq VARCHAR2(150);

Line 383: l_new_pos_name per_positions.name%TYPE;

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);
385: l_new_seq VARCHAR2(150);
386: l_agency_seq VARCHAR2(150);
387: l_ovn NUMBER;