DBA Data[Home] [Help]

APPS.GHR_VALIDATE_CHECK dependencies on GHR_PA_INCENTIVES

Line 487: FROM ghr_pa_incentives

483: l_max_months NUMBER;
484:
485: CURSOR c_incentives IS
486: SELECT pa_incentive_category_end_date,pa_incentive_category_percent
487: FROM ghr_pa_incentives
488: WHERE pa_request_id = p_pa_request_rec.pa_request_id
489: AND pa_incentive_category = 'Biweekly';
490:
491: CURSOR c_incentive_cnt IS

Line 493: FROM ghr_pa_incentives

489: AND pa_incentive_category = 'Biweekly';
490:
491: CURSOR c_incentive_cnt IS
492: SELECT count(*) cnt
493: FROM ghr_pa_incentives
494: WHERE pa_request_id = p_pa_request_rec.pa_request_id;
495:
496: -- Bug#5041985
497: CURSOR c_futr_incentives(l_asg_id NUMBER, l_effective_date DATE) IS