DBA Data[Home] [Help]

APPS.CN_IMP_RULE_PVT dependencies on CN_HEAD_HIERARCHIES

Line 1023: CURSOR c_rule_attrb_hier_id_csr (l_name CN_HEAD_HIERARCHIES.name%TYPE) IS

1019: AND nvl(parent_rule_name, FND_API.g_miss_char) = nvl(p_parent_rule_name, FND_API.g_miss_char)
1020: AND level_num = p_level_num;
1021:
1022: -- cursor to get the hierarchy id
1023: CURSOR c_rule_attrb_hier_id_csr (l_name CN_HEAD_HIERARCHIES.name%TYPE) IS
1024: SELECT head_hierarchy_id
1025: FROM CN_HEAD_HIERARCHIES
1026: WHERE name = l_name
1027: and org_id=p_org_id;

Line 1025: FROM CN_HEAD_HIERARCHIES

1021:
1022: -- cursor to get the hierarchy id
1023: CURSOR c_rule_attrb_hier_id_csr (l_name CN_HEAD_HIERARCHIES.name%TYPE) IS
1024: SELECT head_hierarchy_id
1025: FROM CN_HEAD_HIERARCHIES
1026: WHERE name = l_name
1027: and org_id=p_org_id;
1028:
1029: -- cursor to get the value associated with the hierarchy attribute