DBA Data[Home] [Help]

APPS.HR_DELETE dependencies on HR_QUESTIONNAIRES

Line 1935: , hr_questionnaires qn

1931: DELETE from hr_quest_fields qsf
1932: WHERE qsf.field_id in (
1933: SELECT qf.field_id
1934: FROM hr_quest_fields qf
1935: , hr_questionnaires qn
1936: WHERE qf.questionnaire_template_id = qn.questionnaire_template_id
1937: AND qn.business_group_id = P_BUSINESS_GROUP_ID);
1938: --
1939: hr_utility.set_location(l_proc,40);

Line 1941: DELETE from hr_questionnaires qsn

1937: AND qn.business_group_id = P_BUSINESS_GROUP_ID);
1938: --
1939: hr_utility.set_location(l_proc,40);
1940: --
1941: DELETE from hr_questionnaires qsn
1942: WHERE qsn.business_group_id = P_BUSINESS_GROUP_ID;
1943: --
1944: hr_utility.set_location(l_proc,50);
1945: --