DBA Data[Home] [Help]

APPS.OKL_CPY_PDT_RULS_PVT dependencies on OKC_K_HEADERS_B

Line 674: OKC_K_HEADERS_B chr

670: chr.end_date,
671: chr.sts_code,
672: khr.pdt_id
673: FROM OKL_K_HEADERS khr,
674: OKC_K_HEADERS_B chr
675: WHERE khr.id = chr.id
676: AND chr.id = p_khr_id;
677:
678: l_khr_rec l_khr_csr%ROWTYPE;

Line 684: KHR_ID -- fk to okc_k_headers_b.id

680: --cursor to get selected product options
681: CURSOR l_slctd_opt_csr (p_khr_id IN NUMBER, p_pov_id IN NUMBER) is
682: SELECT ID,
683: POV_ID, --required
684: KHR_ID -- fk to okc_k_headers_b.id
685: FROM OKL_SLCTD_OPTNS
686: WHERE KHR_ID = p_khr_id
687: and POV_ID = p_pov_id;
688: