DBA Data[Home] [Help]

APPS.PQH_COMP_SURVEY dependencies on PER_SALARY_SURVEY_LINES

Line 108: l_salary_survey_line_id per_salary_survey_lines.salary_survey_line_id%TYPE;

104: , P_CREATION_DATE DATE default null
105: ) is
106:
107: --
108: l_salary_survey_line_id per_salary_survey_lines.salary_survey_line_id%TYPE;
109: l_ssl_object_version_number per_salary_survey_lines.object_version_number%TYPE;
110: --
111: l_overlap_warning boolean := false;
112: --

Line 109: l_ssl_object_version_number per_salary_survey_lines.object_version_number%TYPE;

105: ) is
106:
107: --
108: l_salary_survey_line_id per_salary_survey_lines.salary_survey_line_id%TYPE;
109: l_ssl_object_version_number per_salary_survey_lines.object_version_number%TYPE;
110: --
111: l_overlap_warning boolean := false;
112: --
113: -- This cursor gets the latest object version number to determine the row to be -- updated.

Line 116: from per_salary_survey_lines

112: --
113: -- This cursor gets the latest object version number to determine the row to be -- updated.
114: cursor c_object_version is
115: select max(object_version_number)
116: from per_salary_survey_lines
117: where salary_survey_line_id = p_salary_survey_line_id
118: and salary_survey_id = p_salary_survey_id;
119:
120: begin