APPS.FEM_GL_POST_BAL_PKG dependencies on FEM_INTG_EXEC_PARAMS_GT

Line 291: v_sql_stmt := v_sql_stmt || ', fem_intg_exec_params_gt param' ||

287: ' sum(bpi.ytd_credit_balance_e) '||
288: ' FROM fem_bal_post_interim_gt bpi';
289:
290: IF p_load_type = 'OGL' THEN
291: v_sql_stmt := v_sql_stmt || ', fem_intg_exec_params_gt param' ||
292: ', gl_code_combinations cc';
293: END IF;
294:
295: v_sql_stmt := v_sql_stmt ||

Line 434: ' FEM_INTG_EXEC_PARAMS_GT param, ' ||

430: 'sum(pi.ptd_credit_balance_e) ptd_credit_balance_e, ' ||
431: 'sum(pi.ytd_debit_balance_e) ytd_debit_balance_e, ' ||
432: 'sum(pi.ytd_credit_balance_e) ytd_credit_balance_e ' ||
433: 'FROM FEM_BAL_POST_INTERIM_GT pi, ' ||
434: ' FEM_INTG_EXEC_PARAMS_GT param, ' ||
435: ' GL_CODE_COMBINATIONS cc ' ||
436: 'WHERE pi.dataset_code = param.output_dataset_code ' ||
437: 'AND pi.cal_period_id = param.cal_period_id ' ||
438: 'AND pi.posting_error_flag = ''N'' ' ||

Line 781: FROM FEM_INTG_EXEC_PARAMS_GT param

777: AND per_prev.quarter_num = per_curr.quarter_num
778: )
779: WHERE EXISTS
780: (SELECT 1
781: FROM FEM_INTG_EXEC_PARAMS_GT param
782: WHERE param.output_dataset_code = fb.dataset_code
783: AND param.cal_period_id = fb.cal_period_id
784: AND param.error_code IS NULL
785: AND param.request_id IS NOT NULL)