DBA Data[Home] [Help]

APPS.FUN_BAL_PKG dependencies on FUN_BAL_GENERATE_LINES

Line 2890: FROM fun_bal_inter_int_gt sum_lines, fun_bal_generate_lines gen

2886: 'D', sum_lines.accounted_amt_dr),
2887: NULL),
2888: DECODE(gen.value, 'C', sum_lines.pay_acct, 'D', sum_lines.rec_acct, NULL),
2889: 'Y'
2890: FROM fun_bal_inter_int_gt sum_lines, fun_bal_generate_lines gen
2891: WHERE gen.value = DECODE(sum_lines.intercompany_mode,
2892: 1, DECODE(sum_lines.type, gen.value, 'X', gen.value),
2893: 2, DECODE(sum_lines.le_id, sum_lines.driving_dr_le_id, 'X', gen.value),
2894: 3, DECODE(sum_lines.le_id, sum_lines.driving_cr_le_id, 'X', gen.value),

Line 3698: FROM FUN_BAL_INTRA_INT_GT intra_lines, FUN_BAL_GENERATE_LINES gen

3694: 4, gen.value,
3695: 5, gen.value,
3696: -1),
3697: intra_lines.le_id, intra_lines.template_id, 'R'
3698: FROM FUN_BAL_INTRA_INT_GT intra_lines, FUN_BAL_GENERATE_LINES gen
3699: WHERE gen.value = DECODE(intra_lines.intracompany_mode,
3700: 1, DECODE(gen.value, 'C', DECODE(intra_lines.bal_seg_val,
3701: intra_lines.driving_cr_bsv, 'X', gen.value),
3702: 'D', DECODE(intra_lines.bal_seg_val,