DBA Data[Home] [Help]

APPS.PER_PSS_BUS dependencies on PER_SALARY_SURVEY_LINES

Line 549: -- rows in PER_SALARY_SURVEY_LINES with matching salary_survey_id.

545: -- {Start Of Comments}
546: --
547: -- Description:
548: -- This procedure is used to ensure that no rows may be deleted if there are
549: -- rows in PER_SALARY_SURVEY_LINES with matching salary_survey_id.
550: --
551: -- Pre Conditions:
552: -- None.
553: --

Line 578: from per_salary_survey_lines ssl

574: l_exists varchar2(1);
575: --
576: cursor csr_survey_line_exists is
577: select null
578: from per_salary_survey_lines ssl
579: where ssl.salary_survey_id = p_salary_survey_id;
580: --
581: --
582: Begin

Line 969: -- Check there are no rows in PER_SALARY_SURVEY_LINES.

965: hr_utility.set_location('Entering:'||l_proc, 5);
966: --
967: -- Call all supporting business operations
968: --
969: -- Check there are no rows in PER_SALARY_SURVEY_LINES.
970: --
971: chk_delete(p_salary_survey_id => p_rec.salary_survey_id);
972: --
973: hr_utility.set_location(' Leaving:'||l_proc, 10);