APPS.HR_CAGR_ENT_LINES_API dependencies on PER_CAGR_ENTITLEMENT_RESULTS

Line 16: FROM per_cagr_entitlement_results cer

12: CURSOR csr_entitlement_results IS
13: SELECT cagr_request_id,
14: cagr_entitlement_result_id,
15: assignment_id
16: FROM per_cagr_entitlement_results cer
17: WHERE cer.cagr_entitlement_line_id = p_cagr_entitlement_line_id
18: FOR UPDATE;
19: --
20: CURSOR csr_chk_for_other_lines

Line 25: FROM per_cagr_entitlement_results cer

21: (p_cagr_entitlement_result_id IN NUMBER
22: ,p_cagr_request_id IN NUMBER
23: ,p_assignment_id IN NUMBER) IS
24: SELECT cagr_entitlement_result_id
25: FROM per_cagr_entitlement_results cer
26: WHERE cer.cagr_entitlement_line_id <> p_cagr_entitlement_line_id
27: AND cer.cagr_request_id = p_cagr_request_id
28: AND cer.cagr_entitlement_result_id <> p_cagr_entitlement_result_id
29: AND cer.assignment_id = p_assignment_id;

Line 34: l_result_id per_cagr_entitlement_results.cagr_entitlement_result_id %TYPE;

30: --
31: -- Declare Local Variables
32: --
33: l_proc VARCHAR2(72) := g_package||'delete_from_engine_tables';
34: l_result_id per_cagr_entitlement_results.cagr_entitlement_result_id %TYPE;
35: --
36: BEGIN
37: --
38: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 65: DELETE FROM per_cagr_entitlement_results

61: WHERE cagr_entitlement_line_id = p_cagr_entitlement_line_id;
62: --
63: hr_utility.set_location(l_proc,40);
64: --
65: DELETE FROM per_cagr_entitlement_results
66: WHERE cagr_entitlement_result_id = c_results.cagr_entitlement_result_id;
67: --
68: hr_utility.set_location(l_proc,50);
69: --

Line 91: DELETE FROM per_cagr_entitlement_results

87: WHERE cagr_entitlement_result_id = c_results.cagr_entitlement_result_id;
88: --
89: hr_utility.set_location(l_proc,90);
90: --
91: DELETE FROM per_cagr_entitlement_results
92: WHERE cagr_entitlement_result_id = c_results.cagr_entitlement_result_id;
93: --
94: hr_utility.set_location(l_proc,100);
95: --