DBA Data[Home] [Help]

APPS.OKL_CPY_PDT_RULS_PVT dependencies on OKC_RULES_V

Line 73: FROM Okc_Rules_V

69: ans_set_jtot_object_code,
70: ans_set_jtot_object_id1,
71: ans_set_jtot_object_id2,
72: DISPLAY_SEQUENCE
73: FROM Okc_Rules_V
74: WHERE okc_rules_v.id = p_id;
75:
76: l_rulv_rec OKC_RULE_PUB.rulv_rec_type;
77: --

Line 74: WHERE okc_rules_v.id = p_id;

70: ans_set_jtot_object_id1,
71: ans_set_jtot_object_id2,
72: DISPLAY_SEQUENCE
73: FROM Okc_Rules_V
74: WHERE okc_rules_v.id = p_id;
75:
76: l_rulv_rec OKC_RULE_PUB.rulv_rec_type;
77: --
78: l_proc varchar2(72) := g_pkg_name||'get_rec';

Line 732: SELECT RUL_ID, --required fk to okc_rules_v.id

728: l_opv_ruls_rec l_opv_ruls_csr%ROWTYPE;
729:
730: --cursor to get rule id from option value rule templates (okl_ovd_rul_tmls)
731: CURSOR l_ovd_rul_tmls_csr (p_ovd_id IN NUMBER) is
732: SELECT RUL_ID, --required fk to okc_rules_v.id
733: OVD_ID --fk to okl_opv_rules.id
734: FROM OKL_OVD_RUL_TMLS
735: WHERE OVD_ID = p_ovd_id; --(p_ovd_id will be id fetched in the last cursor)
736: