DBA Data[Home] [Help]

APPS.JE_PT_GL_PFTLS_PKG dependencies on FND_FLEX_VALUE_SETS

Line 133: FROM fnd_flex_value_sets ffvs,

129: INTO ln_cur_amt
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:

Line 146: FROM fnd_flex_value_sets ffvs,

142: INTO ln_amt
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;

Line 170: FROM fnd_flex_value_sets ffvs,

166: INTO gn_cur_tax_amt
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