APPS.JE_PT_GL_PFTLS_PKG dependencies on FND_FLEX_VALUES

Line 13: ,fnd_flex_values ffv

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
17: AND ffvnh.child_flex_value_high)

Line 134: fnd_flex_values ffv

130: ,ln_pre_amt
131: FROM je_profit_loss_rpt_gt jplrg
132: WHERE jplrg.parent_value IN (SELECT ffv.flex_value
133: FROM fnd_flex_value_sets ffvs,
134: fnd_flex_values ffv
135: WHERE ffvs.flex_value_set_name = 'JE_PT_PL_INCSTK_FGWP'
136: AND ffvs.flex_value_set_id=ffv.flex_value_set_id );
137:
138: /* Amount for the item:Increase in stocks of finished goods and in work in progress */

Line 147: fnd_flex_values ffv

143: ,ln_pamt
144: FROM je_parent_child_gt jpcg
145: WHERE jpcg.parent_value IN (SELECT ffv.flex_value
146: FROM fnd_flex_value_sets ffvs,
147: fnd_flex_values ffv
148: WHERE ffvs.flex_value_set_name = 'JE_PT_PL_INCSTCK_FGWP'
149: AND ffvs.flex_value_set_id=ffv.flex_value_set_id)
150: GROUP BY jpcg.parent_value;
151: EXCEPTION

Line 171: fnd_flex_values ffv

167: ,gn_pre_tax_amt
168: FROM je_profit_loss_rpt_gt jplrg
169: WHERE jplrg.parent_value IN (SELECT ffv.flex_value
170: FROM fnd_flex_value_sets ffvs,
171: fnd_flex_values ffv
172: WHERE ffvs.flex_value_set_name = 'JE_PT_PL_INCM_TAX'
173: AND ffvs.flex_value_set_id=ffv.flex_value_set_id);
174: EXCEPTION
175: WHEN NO_DATA_FOUND THEN

Line 208: FROM fnd_flex_values ffv

204: AND ffvnh.parent_flex_value BETWEEN f1.child_flex_value_low
205: AND f1.child_flex_value_high)
206: UNION
207: SELECT ffv.flex_value parent_flex_value
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