APPS.FEM_INTG_BAL_ENG_LOAD_PKG dependencies on FEM_INTG_BPI_CURR_GT

Line 1325: INSERT INTO fem_intg_bpi_curr_gt(

1321: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_func_ccy_code',
1322: p_token2 => 'VAR_VAL',
1323: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_func_ccy_code);
1324:
1325: INSERT INTO fem_intg_bpi_curr_gt(
1326: dataset_code, cal_period_id, code_combination_id, financial_elem_id,
1327: delta_run_id, xtd_balance_f_sum, qtd_balance_f_sum, ytd_balance_f_sum)
1328: SELECT /*+ full(fem_bal_post_interim_gt) */
1329: dataset_code, cal_period_id, code_combination_id,

Line 1356: FROM FEM_INTG_BPI_CURR_GT bpi_beq

1352: bpi.ytd_balance_e - nvl(bpi_beq.ytd_balance_f_sum,0),
1353: bpi.xtd_balance_e - nvl(bpi_beq.xtd_balance_f_sum,0),
1354: bpi.qtd_balance_e - nvl(bpi_beq.qtd_balance_f_sum,0),
1355: bpi.ytd_balance_e - nvl(bpi_beq.ytd_balance_f_sum,0)
1356: FROM FEM_INTG_BPI_CURR_GT bpi_beq
1357: WHERE bpi_beq.dataset_code = bpi.dataset_code
1358: AND bpi_beq.cal_period_id = bpi.cal_period_id
1359: AND bpi_beq.code_combination_id = bpi.code_combination_id
1360: AND bpi_beq.financial_elem_id = bpi.financial_elem_id

Line 1368: FROM fem_intg_bpi_curr_gt bpi_beq

1364: WHERE bpi.currency_code = FEM_GL_POST_PROCESS_PKG.pv_func_ccy_code
1365: AND bpi.posting_error_flag = 'N'
1366: AND EXISTS
1367: (SELECT 1
1368: FROM fem_intg_bpi_curr_gt bpi_beq
1369: WHERE bpi_beq.dataset_code = bpi.dataset_code
1370: AND bpi_beq.cal_period_id = bpi.cal_period_id
1371: AND bpi_beq.code_combination_id = bpi.code_combination_id
1372: AND bpi_beq.financial_elem_id = bpi.financial_elem_id