APPS.OKC_RENEW_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 220

   select cls_code
    from okc_k_headers_all_b,okc_subclasses_b  -- bug 4777431
	WHERE id=p_chr_id and code=scs_code;

Line: 357

  SELECT nvl(rul.rule_information1,OKC_API.G_MISS_CHAR) renew_type,
					   nvl(rul.rule_information2,OKC_API.G_MISS_CHAR) contact
  FROM okc_rules_b rul,okc_rule_groups_b rgp
  WHERE    rgp.dnz_chr_id = p_chr_id
           and   rgp.id=rul.rgp_id
	    --and   rgp.rgd_code='RENEW'
		 and   rul.rule_information_category='REN' ;

Line: 367

  SELECT * from okc_k_headers_b
  where id = p_chr_id;

Line: 373

    is select fnd.user_name from okx_resources_v res, fnd_user fnd
    where fnd.user_id=res.user_id and res.id1=p_user_id;

Line: 699

Procedure Update_Parents_Date_Renewed( p_api_version        IN  NUMBER,
                                       p_init_msg_list      IN  VARCHAR2 ,
                                       x_return_status      OUT NOCOPY VARCHAR2,
                                       x_msg_count          OUT NOCOPY NUMBER,
                                       x_msg_data           OUT NOCOPY VARCHAR2,
                                       p_chr_id             IN NUMBER
                                      ) is

     l_api_name constant varchar2(30) := 'upd_parents_date_rnwd';

Line: 711

         OKC_RENEW_PVT.UPDATE_PARENTS_DATE_RENEWED( p_api_version  => 1,
                              p_init_msg_list   => OKC_API.G_FALSE,
                              x_return_status   => x_return_status,
                              x_msg_count       => x_msg_count,
                              x_msg_data        => x_msg_data,
                              p_chr_id          => p_chr_id
						);