APPS.PQH_RST_BUS dependencies on PQH_RULE_SETS_TL

Line 16: l_rule_set_name pqh_rule_sets_tl.rule_set_name%type;

12: -- | LOCAL Functions |
13: -- ----------------------------------------------------------------------------
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

Line 199: l_ref_rule_set_name pqh_rule_sets_tl.rule_set_name%type;

195: l_proc varchar2(72) := g_package||'chk_referenced_rule_set_id';
196: l_api_updating boolean;
197: l_seeded_rule_flag pqh_rule_sets.seeded_rule_flag%type;
198: l_rule_category pqh_rule_sets.rule_category%type;
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

Line 369: l_rule_set_name pqh_rule_sets_tl.rule_set_name%type;

365: --
366: l_proc varchar2(72) := g_package||'chk_duplicate_rule_set';
367: l_api_updating boolean;
368: l_business_group_id hr_all_organization_units.business_group_id%type;
369: l_rule_set_name pqh_rule_sets_tl.rule_set_name%type;
370: l_rule_set_id pqh_rule_sets.rule_set_id%type;
371: --
372: cursor c1 is
373: select rule_set_id

Line 468: l_ref_rule_set_name PQH_RULE_SETS_TL.rule_set_name%TYPE;

464: p_object_version_number IN NUMBER) IS
465: --
466: l_proc VARCHAR2(72) := g_package||'chk_ins_dup_rule_set';
467: l_rule_set_id PQH_RULE_SETS.rule_set_id%TYPE;
468: l_ref_rule_set_name PQH_RULE_SETS_TL.rule_set_name%TYPE;
469: --
470: CURSOR c1 IS
471: SELECT rule_set_id
472: FROM pqh_rule_sets

Line 1060: From pqh_rule_sets_tl

1056: p_rule_set_name out nocopy varchar2) is
1057: --
1058: Cursor csr_ref is
1059: Select rule_set_name
1060: From pqh_rule_sets_tl
1061: Where rule_set_id = p_rule_set_id;
1062: --
1063: l_proc varchar2(72) := g_package||'get_ref_rule_set_name';
1064: --