DBA Data[Home] [Help]

APPS.HR_JOB_POS dependencies on PER_JOBS_V

Line 43: 115.2 26-Jun-00 CCarter Changed per_jobs to per_jobs_v for

39: added exit;
40: 70.2 05-APR-93 TMATHERS Changed a comment line.
41: 70.3 22-APR-93 TMATHERS Added hr_pos_bg_chk.
42: 115.1 02-Oct-99 SCNair Date track position related changes.
43: 115.2 26-Jun-00 CCarter Changed per_jobs to per_jobs_v for
44: Job groups.
45: =================================================================
46: */
47: --

Line 78: from PER_JOBS_V x

74: select '1'
75: into l_test_func
76: from sys.dual
77: where exists ( select 1
78: from PER_JOBS_V x
79: where x.business_group_id = p_business_group_id);
80: --
81: if SQL%ROWCOUNT >0 THEN
82: hr_utility.set_message(801,'HR_6131_ORG_JOBS_EXIST');