DBA Data[Home] [Help]

APPS.PAY_PWO_BUS dependencies on PER_JOBS_V

Line 80: -- Validation : The job must exist in new view per_jobs_v

76: -- |-----------------------------< chk_job_group >----------------------------|
77: -- ----------------------------------------------------------------------------
78: -- Description : This function is used to validate the job being inserted. It
79: -- must be a valid HR Job Group job.
80: -- Validation : The job must exist in new view per_jobs_v
81: -- On Failure : Raise message 'The job you have entered is not for a valid HR
82: -- Job Group.'
83: -- ----------------------------------------------------------------------------
84: FUNCTION chk_job_group (p_job_id in number

Line 92: FROM per_jobs_v

88: CURSOR get_job_group_job(p_job_id number
89: ,p_bg_id number)
90: IS
91: SELECT job_id
92: FROM per_jobs_v
93: WHERE business_group_id = p_bg_id
94: AND job_id = p_job_id;
95: --
96: l_proc varchar2(72) := g_package||'chk_job_group';