APPS.OKC_EXP_DATE_ASMBLR_PVT SQL Statements

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

Line: 39

    SELECT /*+ leading(khr) use_nl(khr cls) */ khr.id k_id,        -- Bug 5012601 Added hint to avoid FTS
           khr.contract_number k_number,
		 khr.contract_number_modifier k_nbr_mod,
		 khr.end_date k_expire_date,
		 cls.cls_code k_class,
		 khr.scs_code k_subclass,
		 khr.estimated_amount k_estimated_amount,
		 khr.sts_code,
		 khr.authoring_org_id
    FROM  okc_k_headers_b khr,
    		okc_subclasses_b cls
    WHERE (khr.id = p_chr_id OR p_chr_id IS NULL)
    AND khr.scs_code = cls.code
    AND khr.end_date BETWEEN (p_variance + trunc(p_last_rundate) + 1)
    AND (trunc(sysdate) + p_variance + 0.99999)
    ORDER BY k_number;

Line: 59

    SELECT aae.element_name
    FROM   okc_actions_v acn,okc_action_attributes_v aae
    WHERE  acn.id = aae.acn_id
    AND    acn.correlation = 'KEXPIRE';

Line: 106

/*    SELECT acn.correlation INTO l_corrid_rec FROM okc_actions_v acn
    WHERE acn.correlation = 'KEXPIRE';*/

Line: 110

    SELECT acn.id INTO l_acn_id FROM okc_actions_b acn
    WHERE acn.correlation = 'KEXPIRE';

Line: 318

 SELECT /*+ leading(kln) use_nl(kln khr cls sts) */ khr.id k_id,   -- Bug 5012601 Added hint to avoid FTS
 		khr.contract_number k_number,
          khr.contract_number_modifier k_nbr_mod,
          khr.end_date k_expire_date,
          cls.cls_code k_class,
          khr.scs_code k_subclass,
          khr.estimated_amount k_estimated_amount,
          khr.sts_code,
          khr.authoring_org_id
    FROM   okc_k_headers_b khr,
           okc_subclasses_b cls,
           okc_statuses_b sts ,
           okc_k_lines_b kln
    WHERE
    (khr.id = p_chr_id OR p_chr_id IS NULL)
    AND khr.scs_code = cls.code
    AND khr.sts_code = sts.code
    AND sts.ste_code IN ('ACTIVE', 'SIGNED')
    AND kln.sts_code = sts.code
    AND  kln.dnz_chr_id = khr.id
    AND kln.end_date BETWEEN (p_variance + trunc(p_last_rundate) + 1)
    AND (trunc(sysdate) + p_variance + 0.99999)
    ORDER BY k_number;

Line: 346

    SELECT aae.element_name
    FROM   okc_actions_v acn,okc_action_attributes_v aae
    WHERE  acn.id = aae.acn_id
    AND    acn.correlation = 'KLEXPIRE';

Line: 397

    /*SELECT acn.correlation INTO l_corrid_rec FROM okc_actions_v acn
    WHERE acn.correlation = 'KLEXPIRE';*/

Line: 400

    SELECT acn.id INTO l_acn_id FROM okc_actions_b acn
    WHERE acn.correlation = 'KLEXPIRE';