APPS.JE_PT_GL_PFTLS_PKG dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

Line 12: FROM fnd_flex_value_norm_hierarchy ffvnh

8: /* cursor to find direct children */
9: CURSOR children_csr(p_parent_node VARCHAR2) IS
10: SELECT ffvnh.parent_flex_value parent_flex_value
11: ,ffv.flex_value flex_value,ffv.summary_flag
12: FROM fnd_flex_value_norm_hierarchy ffvnh
13: ,fnd_flex_values ffv
14: WHERE ffvnh.flex_value_set_id=gn_flex_value_set_id
15: AND ffv.flex_value_set_id=ffvnh.flex_value_set_id
16: AND (ffv.flex_value BETWEEN ffvnh.child_flex_value_low

Line 198: FROM fnd_flex_value_norm_hierarchy ffvnh

194: ln_lev NUMBER :=1;
195: /*Cursor to find the parent accounts */
196: CURSOR top_parent_csr(p_flex_value_set_id NUMBER) IS
197: SELECT ffvnh.parent_flex_value parent_flex_value
198: FROM fnd_flex_value_norm_hierarchy ffvnh
199: WHERE ffvnh.flex_value_set_id=p_flex_value_set_id
200: AND NOT EXISTS
201: (SELECT 1
202: FROM fnd_flex_value_norm_hierarchy f1

Line 202: FROM fnd_flex_value_norm_hierarchy f1

198: FROM fnd_flex_value_norm_hierarchy ffvnh
199: WHERE ffvnh.flex_value_set_id=p_flex_value_set_id
200: AND NOT EXISTS
201: (SELECT 1
202: FROM fnd_flex_value_norm_hierarchy f1
203: WHERE f1.flex_value_set_id=p_flex_value_set_id
204: AND ffvnh.parent_flex_value BETWEEN f1.child_flex_value_low
205: AND f1.child_flex_value_high)
206: UNION

Line 212: FROM fnd_flex_value_norm_hierarchy f1

208: FROM fnd_flex_values ffv
209: WHERE flex_value_set_id=p_flex_value_set_id
210: AND NOT EXISTS
211: (SELECT 1
212: FROM fnd_flex_value_norm_hierarchy f1
213: WHERE flex_value_set_id=p_flex_value_set_id
214: AND ffv.flex_value BETWEEN f1.child_flex_value_low
215: AND f1.child_flex_value_high);
216: