APPS.OKL_CPY_PDT_RULS_PVT dependencies on OKC_RULE_GROUPS_B

Line 271: from okc_rule_groups_b rgp

267: --cursor to ceck if rule group is already attched at the k hdr level
268: CURSOR chk_rgp_csr (p_khr_id IN NUMBER,
269: p_rgd_code IN VARCHAR2) IS
270: select rgp.id
271: from okc_rule_groups_b rgp
272: where rgp.rgd_code = p_rgd_code
273: and rgp.chr_id = p_khr_id;
274:
275: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE default Null;

Line 275: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE default Null;

271: from okc_rule_groups_b rgp
272: where rgp.rgd_code = p_rgd_code
273: and rgp.chr_id = p_khr_id;
274:
275: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE default Null;
276:
277: --cursor to check if rule exists at the k_hdr level
278: CURSOR chk_rul_csr (p_khr_id IN NUMBER,
279: p_rgp_id IN NUMBER,

Line 473: from okc_rule_groups_b rgp

469: CURSOR chk_rgp_csr (p_khr_id IN NUMBER,
470: p_kle_id IN NUMBER,
471: p_rgd_code IN VARCHAR2) IS
472: select rgp.id
473: from okc_rule_groups_b rgp
474: where rgp.rgd_code = p_rgd_code
475: and rgp.dnz_chr_id = p_khr_id
476: and rgp.cle_id = p_kle_id;
477:

Line 478: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE default Null;

474: where rgp.rgd_code = p_rgd_code
475: and rgp.dnz_chr_id = p_khr_id
476: and rgp.cle_id = p_kle_id;
477:
478: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE default Null;
479:
480: --cursor to check if rule exists at the k_line level
481: CURSOR chk_rul_csr (p_khr_id IN NUMBER,
482: p_rgp_id IN NUMBER,