DBA Data[Home] [Help]

APPS.PQH_RST_BUS dependencies on PQH_RULE_SETS_VL

Line 18: from pqh_rule_sets_vl

14: --
15: function get_rule_set_name (p_rule_set_id in number) return varchar2 is
16: l_rule_set_name pqh_rule_sets_tl.rule_set_name%type;
17: cursor c1 is select rule_set_name
18: from pqh_rule_sets_vl
19: where rule_set_id = p_rule_set_id;
20: begin
21: open c1;
22: fetch c1 into l_rule_set_name;

Line 130: from pqh_rule_sets_vl

126: l_dummy varchar2(1);
127: --
128: Cursor csr_rst_name is
129: select null
130: from pqh_rule_sets_vl
131: where rule_set_name = p_rule_set_name;
132: --
133: l_proc varchar2(72) := g_package||'chk_rule_set_name';
134: --

Line 203: from pqh_rule_sets_vl

199: l_ref_rule_set_name pqh_rule_sets_tl.rule_set_name%type;
200: --
201: cursor c1 is
202: select seeded_rule_flag,rule_set_name,rule_category
203: from pqh_rule_sets_vl
204: where rule_set_id = p_referenced_rule_set_id;
205: --
206: Begin
207: --