APPS.PER_SSL_BUS dependencies on PER_SALARY_SURVEY_MAPPINGS

Line 1969: -- rows in PER_SALARY_SURVEY_MAPPINGS with matching salary_survey_line_id.

1965: -- {Start Of Comments}
1966: --
1967: -- Description:
1968: -- This Procedure is used to ensure that no rows may be deleted If there are
1969: -- rows in PER_SALARY_SURVEY_MAPPINGS with matching salary_survey_line_id.
1970: --
1971: -- Pre Conditions:
1972: -- None.
1973: --

Line 1978: -- Processing continue If there are no rows in per_salary_survey_mappings with

1974: -- In Arguments:
1975: -- salary_survey_line_id
1976: --
1977: -- Post Success:
1978: -- Processing continue If there are no rows in per_salary_survey_mappings with
1979: -- matcing salary_survey_line_id.
1980: --
1981: -- Post Failure:
1982: -- An application error is raised If there are rows in

Line 1983: -- per_salary_survey_mappings with matcing salary_survey_line_id.

1979: -- matcing salary_survey_line_id.
1980: --
1981: -- Post Failure:
1982: -- An application error is raised If there are rows in
1983: -- per_salary_survey_mappings with matcing salary_survey_line_id.
1984: --
1985: -- Access Status
1986: -- Internal row handler use only.
1987: --

Line 1997: from per_salary_survey_mappings ssm

1993: l_exists varchar2(1);
1994: --
1995: cursor csr_survey_mapping_exists is
1996: select null
1997: from per_salary_survey_mappings ssm
1998: where ssm.salary_survey_line_id = p_salary_survey_line_id;
1999: --
2000: Begin
2001: --