APPS.AS_CLASSIFICATION_HOOKS dependencies on HZ_CLASS_CODE_RELATIONS

Line 13: from hz_class_code_relations rel1,

9: set selectable_flag = 'N'
10: where denorm.class_category = p_class_category
11: and selectable_flag = 'Y'
12: and exists (select 'x'
13: from hz_class_code_relations rel1,
14: hz_class_code_relations rel2,
15: fnd_lookup_values lv
16: where (rel1.sub_class_code = denorm.class_code
17: or lv.lookup_code = rel1.sub_class_code)

Line 14: hz_class_code_relations rel2,

10: where denorm.class_category = p_class_category
11: and selectable_flag = 'Y'
12: and exists (select 'x'
13: from hz_class_code_relations rel1,
14: hz_class_code_relations rel2,
15: fnd_lookup_values lv
16: where (rel1.sub_class_code = denorm.class_code
17: or lv.lookup_code = rel1.sub_class_code)
18: and rel2.class_code = denorm.class_code

Line 220: from (select class_code, sub_class_code from hz_class_code_relations

216:
217: cursor get_class_code_hierarchy_csr(p_type varchar2,p_curr_code varchar2) is
218:
219: select a.class_code
220: from (select class_code, sub_class_code from hz_class_code_relations
221: where
222: sysdate between start_date_active and nvl(end_date_active,sysdate)
223: and class_category = p_type) a
224: start with sub_class_code = p_curr_code

Line 251: from (select class_code, sub_class_code from hz_class_code_relations

247: function get_concat_code(p_class_category in varchar2,p_curr_code in varchar2) return varchar2 is
248:
249: cursor get_class_code_hierarchy_csr is
250: select a.class_code
251: from (select class_code, sub_class_code from hz_class_code_relations
252: where
253: sysdate between start_date_active and nvl(end_date_active,sysdate)
254: and class_category = p_class_category) a
255: start with sub_class_code = p_curr_code

Line 777: from hz_class_code_relations

773: p_sub_class_code in varchar2,
774: p_end_date_active in date) is
775: cursor get_sub_sub_class_code is
776: select sub_class_code
777: from hz_class_code_relations
778: where class_category = p_class_category
779: and p_class_code = p_sub_class_code
780: and sysdate between start_date_active and nvl(end_date_active,sysdate);
781: