APPS.GHR_POSITION_COPY dependencies on PER_POSITIONS

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

129: l_stmt := l_stmt||' AND SEGMENT'||i||' = '''||p_segment30||'''';
130: END IF;
131: END IF;
132: END LOOP;
133: l_stmt := l_stmt||' AND EXISTS (SELECT 1 FROM per_positions pos'
134: ||' WHERE pde.position_definition_id = pos.position_definition_id)';
135: ---
136: --dbms_output.put_line(substr(l_stmt,1,100));
137: --dbms_output.put_line(substr(l_stmt,101,100));

Line 801: l_new_pos_id per_positions.position_id%TYPE;

797: ,p_new_pos_id OUT NOCOPY NUMBER
798: ,p_new_pos_name OUT NOCOPY VARCHAR2
799: ,p_ovn OUT NOCOPY NUMBER) IS
800: --
801: l_new_pos_id per_positions.position_id%TYPE;
802: l_new_pos_name per_positions.name%TYPE;
803:
804: BEGIN
805:

Line 802: l_new_pos_name per_positions.name%TYPE;

798: ,p_new_pos_name OUT NOCOPY VARCHAR2
799: ,p_ovn OUT NOCOPY NUMBER) IS
800: --
801: l_new_pos_id per_positions.position_id%TYPE;
802: l_new_pos_name per_positions.name%TYPE;
803:
804: BEGIN
805:
806: create_posn(p_pos_id

Line 836: from per_positions

832: l_ovn number;
833:
834: cursor c_get_ovn is
835: select object_version_number
836: from per_positions
837: where position_id = p_pos_id;
838:
839: BEGIN
840:

Line 841: Update per_positions

837: where position_id = p_pos_id;
838:
839: BEGIN
840:
841: Update per_positions
842: set
843: organization_id = p_new_org_id,
844: job_id = p_new_job_id
845: where position_id = p_pos_id;