APPS.JE_PT_GL_PFTLS_PKG dependencies on JE_PROFIT_LOSS_RPT_GT

Line 115: INSERT INTO je_profit_loss_rpt_gt( parent_value

111: GROUP BY '||gc_natural_account||')';
112:
113: EXECUTE IMMEDIATE lc_stmt USING p_ledger_id,p_period_set_name,p_period_type,gd_prior_start_date,gd_prior_end_date;
114:
115: INSERT INTO je_profit_loss_rpt_gt( parent_value
116: ,amount
117: ,prior_amount)
118: SELECT parent_value
119: ,ABS(SUM(amount))

Line 131: FROM je_profit_loss_rpt_gt jplrg

127: SELECT NVL(SUM(jplrg.amount),0)
128: ,NVL(SUM(jplrg.prior_amount),0)
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'

Line 168: FROM je_profit_loss_rpt_gt jplrg

164: (CASE WHEN NVL(jplrg.amount,0)<=0 THEN 0 ELSE jplrg.amount END) ELSE p_irc_tax END)
165: ,(CASE WHEN NVL(jplrg.prior_amount,0)<=0 THEN 0 ELSE jplrg.prior_amount END)
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'