APPS.JE_PT_GL_PFTLS_PKG dependencies on JE_PARENT_CHILD_GT

Line 37: INSERT INTO je_parent_child_gt(parent_value,child_value)

33: FOR i IN parent_value_rec.first..parent_value_rec.last
34: LOOP
35: IF (p_summary_flag = 'N' OR x_lev=1)
36: THEN
37: INSERT INTO je_parent_child_gt(parent_value,child_value)
38: VALUES (parent_value_rec(i),p_parent);
39: END IF;
40: END LOOP;
41:

Line 67: lc_stmt := 'UPDATE je_parent_child_gt jpcg

63: BEGIN
64:
65: /* Statement to update the Global temporary table amounts with parent and child accouns period to date balances */
66:
67: lc_stmt := 'UPDATE je_parent_child_gt jpcg
68: SET amount = (SELECT sum(nvl(gb.period_net_dr,0)-nvl(gb.period_net_cr,0))
69: FROM gl_balances gb
70: ,gl_code_combinations gcc
71: WHERE gcc.code_combination_id=gb.code_combination_id

Line 91: lc_stmt := 'UPDATE je_parent_child_gt jpcg

87: GROUP BY '||gc_natural_account||')';
88:
89: EXECUTE IMMEDIATE lc_stmt USING p_ledger_id,p_period_set_name,p_period_type,gd_start_date,gd_end_date;
90:
91: lc_stmt := 'UPDATE je_parent_child_gt jpcg
92: SET prior_amount = (SELECT sum(nvl(gb.period_net_dr,0)-nvl(gb.period_net_cr,0))
93: FROM gl_balances gb
94: ,gl_code_combinations gcc
95: WHERE gcc.code_combination_id=gb.code_combination_id

Line 121: FROM je_parent_child_gt

117: ,prior_amount)
118: SELECT parent_value
119: ,ABS(SUM(amount))
120: ,ABS(SUM(prior_amount))
121: FROM je_parent_child_gt
122: GROUP BY parent_value
123: ORDER BY parent_value;
124:
125: /* Amount for the item:Increase in stocks of finished goods and in work in progress */

Line 144: FROM je_parent_child_gt jpcg

140: SELECT NVL(SUM(jpcg.amount),0)
141: ,NVL(SUM(jpcg.prior_amount),0)
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'