APPS.GHR_APPROVED_PA_REQUESTS dependencies on GHR_PA_INCENTIVES

Line 1614: INSERT INTO ghr_pa_incentives( pa_incentive_id,

1610: );
1611:
1612: IF nvl(l_noa_family_code,hr_api.g_varchar2) = 'GHR_INCENTIVE' THEN
1613: hr_utility.set_location('Inserting incentive records',0);
1614: INSERT INTO ghr_pa_incentives( pa_incentive_id,
1615: pa_request_id ,
1616: pa_incentive_category,
1617: pa_incentive_category_percent ,
1618: pa_incentive_category_amount,

Line 1622: ghr_pa_incentives_s.nextval,

1618: pa_incentive_category_amount,
1619: pa_incentive_category_pmnt_dt ,
1620: pa_incentive_category_end_date)
1621: SELECT
1622: ghr_pa_incentives_s.nextval,
1623: l_pa_req_rec.pa_request_id,
1624: pa_incentive_category,
1625: pa_incentive_category_percent ,
1626: pa_incentive_category_amount,

Line 1629: FROM GHR_PA_INCENTIVES

1625: pa_incentive_category_percent ,
1626: pa_incentive_category_amount,
1627: pa_incentive_category_pmnt_dt ,
1628: pa_incentive_category_end_date
1629: FROM GHR_PA_INCENTIVES
1630: WHERE pa_request_id = l_pa_req_rec.altered_pa_request_id;
1631: hr_utility.set_location('After Inserting incentive records',10);
1632: END IF;
1633: -- Bug#4486823 RRR Changes