[Home] [Help]
50: l_effective_end_date DATE;
51: --
52: CURSOR csr_get_api_id IS
53: SELECT cagr_api_id
54: FROM per_cagr_api_parameters p
55: WHERE p.cagr_api_param_id = p_cagr_api_param_id;
56: --
57: BEGIN
58: --
308: l_cagr_api_id per_cagr_entitlement_items.cagr_api_id%TYPE;
309: --
310: CURSOR csr_get_api_id IS
311: SELECT cagr_api_id
312: FROM per_cagr_api_parameters p
313: WHERE p.cagr_api_param_id = p_cagr_api_param_id;
314: --
315: begin
316: --