DBA Data[Home] [Help]

APPS.PER_SSM_BUS dependencies on PER_GRADES

Line 811: from per_grades g

807: l_bg number(15);
808: --
809: cursor csr_chk_grade_exists is
810: select g.business_group_id, g.date_from, nvl(g.date_to,hr_api.g_eot)
811: from per_grades g
812: where g.grade_id = p_grade_id;
813: --
814: cursor csr_get_bg is
815: select business_group_id

Line 841: -- raise error as FK does not relate to PK in per_grades

837: fetch csr_chk_grade_exists into l_business_group_id, l_grade_date_from, l_grade_date_to;
838: If csr_chk_grade_exists%notfound then
839: close csr_chk_grade_exists;
840: --
841: -- raise error as FK does not relate to PK in per_grades
842: -- table.
843: --
844: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK3');
845: --