APPS.PER_SSM_BUS dependencies on PER_SALARY_SURVEY_LINES

Line 158: from per_salary_survey_lines ssl

154: l_start_date date;
155: --
156: cursor csr_get_dates is
157: select start_date
158: from per_salary_survey_lines ssl
159: where ssl.salary_survey_line_id = p_salary_survey_line_id;
160: --
161: Begin
162: --

Line 214: from per_salary_survey_lines ssl

210: l_end_date date;
211: --
212: cursor csr_get_dates is
213: select nvl(end_date,hr_api.g_eot)
214: from per_salary_survey_lines ssl
215: where ssl.salary_survey_line_id = p_salary_survey_line_id;
216: --
217: Begin
218: --

Line 269: from per_salary_survey_lines ssl

265: l_exists varchar2(1);
266: --
267: cursor csr_chk_survey_line_exists is
268: select 'Y'
269: from per_salary_survey_lines ssl
270: where ssl.salary_survey_line_id = p_salary_survey_line_id;
271: --
272: Begin
273: --

Line 299: -- per_salary_survey_lines table

295: --
296: Elsif not l_api_updating and p_salary_survey_line_id is not null then
297: --
298: -- check If salary_survey_line_id value exists in
299: -- per_salary_survey_lines table
300: --
301: open csr_chk_survey_line_exists;
302: --
303: fetch csr_chk_survey_line_exists into l_exists;

Line 309: -- raise error as FK does not relate to PK in per_salary_survey_lines

305: If csr_chk_survey_line_exists%notfound Then
306: --
307: close csr_chk_survey_line_exists;
308: --
309: -- raise error as FK does not relate to PK in per_salary_survey_lines
310: -- table.
311: --
312: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK1');
313: --