APPS.PER_CAGR_APPLY_RESULTS_PKG dependencies on PER_CAGR_REQUESTS

Line 119: from per_cagr_requests req

115: FROM per_cagr_entitlement_results res
116: WHERE res.assignment_id = p_assignment_id
117: AND p_effective_date BETWEEN res.start_date and nvl(res.end_date,hr_general.end_of_time)
118: AND exists (select 'x'
119: from per_cagr_requests req
120: where req.cagr_request_id = cagr_request_id
121: and req.OPERATION_MODE = 'SA')
122: and rownum = 1;
123:

Line 125: l_request per_cagr_requests.cagr_request_id%type;

121: and req.OPERATION_MODE = 'SA')
122: and rownum = 1;
123:
124: l_proc constant VARCHAR2(80) := g_pkg || 'get_request_id';
125: l_request per_cagr_requests.cagr_request_id%type;
126:
127: BEGIN
128: hr_utility.set_location('Entering: '||l_proc,10);
129: