APPS.OKL_ORL_PVT dependencies on OKC_LSE_RULE_GROUPS_V

Line 766: FROM okc_lse_rule_groups_v

762:
763: CURSOR okl_lrgv_pk_csr (p_lse_id IN NUMBER,
764: p_srd_id IN NUMBER) IS
765: SELECT '1'
766: FROM okc_lse_rule_groups_v
767: WHERE okc_lse_rule_groups_v.lse_id = p_lse_id
768: AND okc_lse_rule_groups_v.srd_id = p_srd_id;
769:
770: l_rgr_status VARCHAR2(1);

Line 767: WHERE okc_lse_rule_groups_v.lse_id = p_lse_id

763: CURSOR okl_lrgv_pk_csr (p_lse_id IN NUMBER,
764: p_srd_id IN NUMBER) IS
765: SELECT '1'
766: FROM okc_lse_rule_groups_v
767: WHERE okc_lse_rule_groups_v.lse_id = p_lse_id
768: AND okc_lse_rule_groups_v.srd_id = p_srd_id;
769:
770: l_rgr_status VARCHAR2(1);
771: l_lrg_status VARCHAR2(1);

Line 768: AND okc_lse_rule_groups_v.srd_id = p_srd_id;

764: p_srd_id IN NUMBER) IS
765: SELECT '1'
766: FROM okc_lse_rule_groups_v
767: WHERE okc_lse_rule_groups_v.lse_id = p_lse_id
768: AND okc_lse_rule_groups_v.srd_id = p_srd_id;
769:
770: l_rgr_status VARCHAR2(1);
771: l_lrg_status VARCHAR2(1);
772: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;