159: --
160: -- Desciption :
161: --
162: -- Validate that on insert cagr_api_id is not null and that 163: -- it exists in per_cagr_apis. 164: --
165: --
166: -- Pre-conditions :
167: --
Line 196: FROM per_cagr_apis per
192: l_dummy NUMBER := NULL;
193: --
194: CURSOR csr_cagr_api_id IS
195: SELECT null 196: FROM per_cagr_apis per 197: WHERE per.cagr_api_id = p_cagr_api_id;
198: --
199: BEGIN
200: --