eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_PSI_FUNDS_AVAIL_SUM_PKG dependencies on FII_EA_UTIL_PKG

Line 62: fii_ea_util_pkg.reset_globals;

58: l_trend_sum_mv_obligated VARCHAR2(30);
59: l_trend_sum_mv_other VARCHAR2(30);
60:
61: BEGIN
62: fii_ea_util_pkg.reset_globals;
63: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
64:
65: fii_ea_util_pkg.get_viewby_id(l_aggrt_viewby_id, l_snap_aggrt_viewby_id, l_non_aggrt_viewby_id);
66: fii_ea_util_pkg.populate_security_gt_tables(l_aggrt_gt_is_empty, l_non_aggrt_gt_is_empty);

Line 63: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);

59: l_trend_sum_mv_other VARCHAR2(30);
60:
61: BEGIN
62: fii_ea_util_pkg.reset_globals;
63: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
64:
65: fii_ea_util_pkg.get_viewby_id(l_aggrt_viewby_id, l_snap_aggrt_viewby_id, l_non_aggrt_viewby_id);
66: fii_ea_util_pkg.populate_security_gt_tables(l_aggrt_gt_is_empty, l_non_aggrt_gt_is_empty);
67:

Line 65: fii_ea_util_pkg.get_viewby_id(l_aggrt_viewby_id, l_snap_aggrt_viewby_id, l_non_aggrt_viewby_id);

61: BEGIN
62: fii_ea_util_pkg.reset_globals;
63: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
64:
65: fii_ea_util_pkg.get_viewby_id(l_aggrt_viewby_id, l_snap_aggrt_viewby_id, l_non_aggrt_viewby_id);
66: fii_ea_util_pkg.populate_security_gt_tables(l_aggrt_gt_is_empty, l_non_aggrt_gt_is_empty);
67:
68: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
69: l_page_period_type := fii_ea_util_pkg.g_page_period_type;

Line 66: fii_ea_util_pkg.populate_security_gt_tables(l_aggrt_gt_is_empty, l_non_aggrt_gt_is_empty);

62: fii_ea_util_pkg.reset_globals;
63: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
64:
65: fii_ea_util_pkg.get_viewby_id(l_aggrt_viewby_id, l_snap_aggrt_viewby_id, l_non_aggrt_viewby_id);
66: fii_ea_util_pkg.populate_security_gt_tables(l_aggrt_gt_is_empty, l_non_aggrt_gt_is_empty);
67:
68: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
69: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
70: l_amount_type := fii_ea_util_pkg.g_amount_type;

Line 68: l_as_of_date := fii_ea_util_pkg.g_as_of_date;

64:
65: fii_ea_util_pkg.get_viewby_id(l_aggrt_viewby_id, l_snap_aggrt_viewby_id, l_non_aggrt_viewby_id);
66: fii_ea_util_pkg.populate_security_gt_tables(l_aggrt_gt_is_empty, l_non_aggrt_gt_is_empty);
67:
68: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
69: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
70: l_amount_type := fii_ea_util_pkg.g_amount_type;
71: l_time_comp := fii_ea_util_pkg.g_time_comp;
72: l_view_by := fii_ea_util_pkg.g_view_by;

Line 69: l_page_period_type := fii_ea_util_pkg.g_page_period_type;

65: fii_ea_util_pkg.get_viewby_id(l_aggrt_viewby_id, l_snap_aggrt_viewby_id, l_non_aggrt_viewby_id);
66: fii_ea_util_pkg.populate_security_gt_tables(l_aggrt_gt_is_empty, l_non_aggrt_gt_is_empty);
67:
68: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
69: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
70: l_amount_type := fii_ea_util_pkg.g_amount_type;
71: l_time_comp := fii_ea_util_pkg.g_time_comp;
72: l_view_by := fii_ea_util_pkg.g_view_by;
73: l_fud1_id := fii_ea_util_pkg.g_fud1_id;

Line 70: l_amount_type := fii_ea_util_pkg.g_amount_type;

66: fii_ea_util_pkg.populate_security_gt_tables(l_aggrt_gt_is_empty, l_non_aggrt_gt_is_empty);
67:
68: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
69: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
70: l_amount_type := fii_ea_util_pkg.g_amount_type;
71: l_time_comp := fii_ea_util_pkg.g_time_comp;
72: l_view_by := fii_ea_util_pkg.g_view_by;
73: l_fud1_id := fii_ea_util_pkg.g_fud1_id;
74: l_fud2_id := fii_ea_util_pkg.g_fud2_id;

Line 71: l_time_comp := fii_ea_util_pkg.g_time_comp;

67:
68: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
69: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
70: l_amount_type := fii_ea_util_pkg.g_amount_type;
71: l_time_comp := fii_ea_util_pkg.g_time_comp;
72: l_view_by := fii_ea_util_pkg.g_view_by;
73: l_fud1_id := fii_ea_util_pkg.g_fud1_id;
74: l_fud2_id := fii_ea_util_pkg.g_fud2_id;
75: l_snapshot := fii_ea_util_pkg.g_snapshot;

Line 72: l_view_by := fii_ea_util_pkg.g_view_by;

68: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
69: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
70: l_amount_type := fii_ea_util_pkg.g_amount_type;
71: l_time_comp := fii_ea_util_pkg.g_time_comp;
72: l_view_by := fii_ea_util_pkg.g_view_by;
73: l_fud1_id := fii_ea_util_pkg.g_fud1_id;
74: l_fud2_id := fii_ea_util_pkg.g_fud2_id;
75: l_snapshot := fii_ea_util_pkg.g_snapshot;
76:

Line 73: l_fud1_id := fii_ea_util_pkg.g_fud1_id;

69: l_page_period_type := fii_ea_util_pkg.g_page_period_type;
70: l_amount_type := fii_ea_util_pkg.g_amount_type;
71: l_time_comp := fii_ea_util_pkg.g_time_comp;
72: l_view_by := fii_ea_util_pkg.g_view_by;
73: l_fud1_id := fii_ea_util_pkg.g_fud1_id;
74: l_fud2_id := fii_ea_util_pkg.g_fud2_id;
75: l_snapshot := fii_ea_util_pkg.g_snapshot;
76:
77: /*l_xtd and l_compare_to are apart of the column names of the mvs in the pmv sql*/

Line 74: l_fud2_id := fii_ea_util_pkg.g_fud2_id;

70: l_amount_type := fii_ea_util_pkg.g_amount_type;
71: l_time_comp := fii_ea_util_pkg.g_time_comp;
72: l_view_by := fii_ea_util_pkg.g_view_by;
73: l_fud1_id := fii_ea_util_pkg.g_fud1_id;
74: l_fud2_id := fii_ea_util_pkg.g_fud2_id;
75: l_snapshot := fii_ea_util_pkg.g_snapshot;
76:
77: /*l_xtd and l_compare_to are apart of the column names of the mvs in the pmv sql*/
78: IF l_page_period_type = 'FII_TIME_ENT_PERIOD' THEN

Line 75: l_snapshot := fii_ea_util_pkg.g_snapshot;

71: l_time_comp := fii_ea_util_pkg.g_time_comp;
72: l_view_by := fii_ea_util_pkg.g_view_by;
73: l_fud1_id := fii_ea_util_pkg.g_fud1_id;
74: l_fud2_id := fii_ea_util_pkg.g_fud2_id;
75: l_snapshot := fii_ea_util_pkg.g_snapshot;
76:
77: /*l_xtd and l_compare_to are apart of the column names of the mvs in the pmv sql*/
78: IF l_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
79: l_xtd := 'MTD';

Line 110: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);

106: A is the only node granted access to a user. To display the direct record, use the self
107: record for A to find budgets against A in the base mv. This is only for financial
108: category and user defined dimension 1. */
109: IF l_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
110: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
111: l_cat_decode :=
112: ' and fin_hier.parent_fin_cat_id = DECODE(fin_hier.parent_fin_cat_id, :CATEGORY_ID,
113: fin_hier.child_fin_cat_id, fin_hier.parent_fin_cat_id)';
114: l_if_leaf_flag := fii_ea_util_pkg.g_fin_cat_is_leaf;

Line 114: l_if_leaf_flag := fii_ea_util_pkg.g_fin_cat_is_leaf;

110: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
111: l_cat_decode :=
112: ' and fin_hier.parent_fin_cat_id = DECODE(fin_hier.parent_fin_cat_id, :CATEGORY_ID,
113: fin_hier.child_fin_cat_id, fin_hier.parent_fin_cat_id)';
114: l_if_leaf_flag := fii_ea_util_pkg.g_fin_cat_is_leaf;
115: ELSIF l_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
116: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);
117: l_fud1_decode :=
118: ' and fud1_hier.parent_value_id = DECODE(fud1_hier.parent_value_id, :UDD1_ID,

Line 116: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);

112: ' and fin_hier.parent_fin_cat_id = DECODE(fin_hier.parent_fin_cat_id, :CATEGORY_ID,
113: fin_hier.child_fin_cat_id, fin_hier.parent_fin_cat_id)';
114: l_if_leaf_flag := fii_ea_util_pkg.g_fin_cat_is_leaf;
115: ELSIF l_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
116: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);
117: l_fud1_decode :=
118: ' and fud1_hier.parent_value_id = DECODE(fud1_hier.parent_value_id, :UDD1_ID,
119: fud1_hier.child_value_id, fud1_hier.parent_value_id)';
120: l_if_leaf_flag := fii_ea_util_pkg.g_ud1_is_leaf;

Line 120: l_if_leaf_flag := fii_ea_util_pkg.g_ud1_is_leaf;

116: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);
117: l_fud1_decode :=
118: ' and fud1_hier.parent_value_id = DECODE(fud1_hier.parent_value_id, :UDD1_ID,
119: fud1_hier.child_value_id, fud1_hier.parent_value_id)';
120: l_if_leaf_flag := fii_ea_util_pkg.g_ud1_is_leaf;
121: ELSE
122: l_if_leaf_flag := 'Y';
123: END IF;
124:

Line 403: FII_EA_UTIL_PKG.bind_variable(

399: || l_union_sql
400: || l_inner_sql_sys_nonagg
401: || l_outer_sql_e;
402:
403: FII_EA_UTIL_PKG.bind_variable(
404: p_sqlstmt => sqlstmt,
405: p_page_parameter_tbl => p_page_parameter_tbl,
406: p_sql_output => funds_avail_sql,
407: p_bind_output_table => funds_avail_output);

Line 414: IF fii_ea_util_pkg.g_if_trend_sum_mv = 'Y' THEN

410:
411: /* currency views on top of fii_gl_trend_sum_mv don't have posted_date column,
412: so, we're hitting fii_gl_trend_sum_mv directly by using the below mentioned work-around */
413:
414: IF fii_ea_util_pkg.g_if_trend_sum_mv = 'Y' THEN
415:
416: l_prim_or_sec := 'PRIM_';
417: l_trend_sum_mv_commitment := 'COMMITTED_AMOUNT_PRIM';
418: l_trend_sum_mv_obligated := 'OBLIGATED_AMOUNT_PRIM';

Line 488: IF fii_ea_util_pkg.g_if_trend_sum_mv = 'Y' THEN

484: NVL(SUM(CASE WHEN inner_inline_view.report_date = :ASOF_DATE
485: AND BITAND(inner_inline_view.record_type_id, :ACTUAL_BITAND) = :ACTUAL_BITAND
486: THEN '||l_prim_or_sec||'ACTUAL_G ELSE 0 END), 0) FII_PSI_ACTUALS_A';
487:
488: IF fii_ea_util_pkg.g_if_trend_sum_mv = 'Y' THEN
489:
490: l_inner_sql_nonsys_agg :=
491: ' SELECT ' || l_aggrt_viewby_id || ' VIEWBYID,
492: ' || l_inner_sql_nonsys || '

Line 584: FII_EA_UTIL_PKG.bind_variable(

580: || l_union_sql
581: || l_inner_sql_nonsys_nonagg
582: || l_outer_sql_e;
583:
584: FII_EA_UTIL_PKG.bind_variable(
585: p_sqlstmt => sqlstmt,
586: p_page_parameter_tbl => p_page_parameter_tbl,
587: p_sql_output => funds_avail_sql,
588: p_bind_output_table => funds_avail_output);

Line 601: sqlstmt_temp := REPLACE(sqlstmt_temp, ':DIR_MSG', to_char(fii_ea_util_pkg.g_dir_msg));

597: || l_union_sql
598: || l_inner_sql_nonsys_nonagg
599: || l_outer_sql_e;
600:
601: sqlstmt_temp := REPLACE(sqlstmt_temp, ':DIR_MSG', to_char(fii_ea_util_pkg.g_dir_msg));
602: sqlstmt_temp := REPLACE(sqlstmt_temp, ':BOUNDARY_END', '''' || to_char(fii_ea_util_pkg.g_boundary_end, 'DD/MM/YYYY') || '''');
603: sqlstmt_temp := REPLACE(sqlstmt_temp, ':AMOUNT_TYPE_BITAND', to_char(fii_ea_util_pkg.g_amount_type_BITAND));
604: sqlstmt_temp := REPLACE(sqlstmt_temp, ':PRIOR_BOUNDARY_END', '''' || to_char(fii_ea_util_pkg.g_prior_boundary_end, 'DD/MM/YYYY') || '''');
605: sqlstmt_temp := REPLACE(sqlstmt_temp, ':ASOF_DATE', '''' || to_char(fii_ea_util_pkg.g_as_of_date, 'DD/MM/YYYY') || '''');

Line 602: sqlstmt_temp := REPLACE(sqlstmt_temp, ':BOUNDARY_END', '''' || to_char(fii_ea_util_pkg.g_boundary_end, 'DD/MM/YYYY') || '''');

598: || l_inner_sql_nonsys_nonagg
599: || l_outer_sql_e;
600:
601: sqlstmt_temp := REPLACE(sqlstmt_temp, ':DIR_MSG', to_char(fii_ea_util_pkg.g_dir_msg));
602: sqlstmt_temp := REPLACE(sqlstmt_temp, ':BOUNDARY_END', '''' || to_char(fii_ea_util_pkg.g_boundary_end, 'DD/MM/YYYY') || '''');
603: sqlstmt_temp := REPLACE(sqlstmt_temp, ':AMOUNT_TYPE_BITAND', to_char(fii_ea_util_pkg.g_amount_type_BITAND));
604: sqlstmt_temp := REPLACE(sqlstmt_temp, ':PRIOR_BOUNDARY_END', '''' || to_char(fii_ea_util_pkg.g_prior_boundary_end, 'DD/MM/YYYY') || '''');
605: sqlstmt_temp := REPLACE(sqlstmt_temp, ':ASOF_DATE', '''' || to_char(fii_ea_util_pkg.g_as_of_date, 'DD/MM/YYYY') || '''');
606: sqlstmt_temp := REPLACE(sqlstmt_temp, ':PREVIOUS_ASOF_DATE', '''' || to_char(fii_ea_util_pkg.g_previous_asof_date, 'DD/MM/YYYY') || '''');

Line 603: sqlstmt_temp := REPLACE(sqlstmt_temp, ':AMOUNT_TYPE_BITAND', to_char(fii_ea_util_pkg.g_amount_type_BITAND));

599: || l_outer_sql_e;
600:
601: sqlstmt_temp := REPLACE(sqlstmt_temp, ':DIR_MSG', to_char(fii_ea_util_pkg.g_dir_msg));
602: sqlstmt_temp := REPLACE(sqlstmt_temp, ':BOUNDARY_END', '''' || to_char(fii_ea_util_pkg.g_boundary_end, 'DD/MM/YYYY') || '''');
603: sqlstmt_temp := REPLACE(sqlstmt_temp, ':AMOUNT_TYPE_BITAND', to_char(fii_ea_util_pkg.g_amount_type_BITAND));
604: sqlstmt_temp := REPLACE(sqlstmt_temp, ':PRIOR_BOUNDARY_END', '''' || to_char(fii_ea_util_pkg.g_prior_boundary_end, 'DD/MM/YYYY') || '''');
605: sqlstmt_temp := REPLACE(sqlstmt_temp, ':ASOF_DATE', '''' || to_char(fii_ea_util_pkg.g_as_of_date, 'DD/MM/YYYY') || '''');
606: sqlstmt_temp := REPLACE(sqlstmt_temp, ':PREVIOUS_ASOF_DATE', '''' || to_char(fii_ea_util_pkg.g_previous_asof_date, 'DD/MM/YYYY') || '''');
607: sqlstmt_temp := REPLACE(sqlstmt_temp, ':ACTUAL_BITAND', to_char(fii_ea_util_pkg.g_actual_BITAND));

Line 604: sqlstmt_temp := REPLACE(sqlstmt_temp, ':PRIOR_BOUNDARY_END', '''' || to_char(fii_ea_util_pkg.g_prior_boundary_end, 'DD/MM/YYYY') || '''');

600:
601: sqlstmt_temp := REPLACE(sqlstmt_temp, ':DIR_MSG', to_char(fii_ea_util_pkg.g_dir_msg));
602: sqlstmt_temp := REPLACE(sqlstmt_temp, ':BOUNDARY_END', '''' || to_char(fii_ea_util_pkg.g_boundary_end, 'DD/MM/YYYY') || '''');
603: sqlstmt_temp := REPLACE(sqlstmt_temp, ':AMOUNT_TYPE_BITAND', to_char(fii_ea_util_pkg.g_amount_type_BITAND));
604: sqlstmt_temp := REPLACE(sqlstmt_temp, ':PRIOR_BOUNDARY_END', '''' || to_char(fii_ea_util_pkg.g_prior_boundary_end, 'DD/MM/YYYY') || '''');
605: sqlstmt_temp := REPLACE(sqlstmt_temp, ':ASOF_DATE', '''' || to_char(fii_ea_util_pkg.g_as_of_date, 'DD/MM/YYYY') || '''');
606: sqlstmt_temp := REPLACE(sqlstmt_temp, ':PREVIOUS_ASOF_DATE', '''' || to_char(fii_ea_util_pkg.g_previous_asof_date, 'DD/MM/YYYY') || '''');
607: sqlstmt_temp := REPLACE(sqlstmt_temp, ':ACTUAL_BITAND', to_char(fii_ea_util_pkg.g_actual_BITAND));
608:

Line 605: sqlstmt_temp := REPLACE(sqlstmt_temp, ':ASOF_DATE', '''' || to_char(fii_ea_util_pkg.g_as_of_date, 'DD/MM/YYYY') || '''');

601: sqlstmt_temp := REPLACE(sqlstmt_temp, ':DIR_MSG', to_char(fii_ea_util_pkg.g_dir_msg));
602: sqlstmt_temp := REPLACE(sqlstmt_temp, ':BOUNDARY_END', '''' || to_char(fii_ea_util_pkg.g_boundary_end, 'DD/MM/YYYY') || '''');
603: sqlstmt_temp := REPLACE(sqlstmt_temp, ':AMOUNT_TYPE_BITAND', to_char(fii_ea_util_pkg.g_amount_type_BITAND));
604: sqlstmt_temp := REPLACE(sqlstmt_temp, ':PRIOR_BOUNDARY_END', '''' || to_char(fii_ea_util_pkg.g_prior_boundary_end, 'DD/MM/YYYY') || '''');
605: sqlstmt_temp := REPLACE(sqlstmt_temp, ':ASOF_DATE', '''' || to_char(fii_ea_util_pkg.g_as_of_date, 'DD/MM/YYYY') || '''');
606: sqlstmt_temp := REPLACE(sqlstmt_temp, ':PREVIOUS_ASOF_DATE', '''' || to_char(fii_ea_util_pkg.g_previous_asof_date, 'DD/MM/YYYY') || '''');
607: sqlstmt_temp := REPLACE(sqlstmt_temp, ':ACTUAL_BITAND', to_char(fii_ea_util_pkg.g_actual_BITAND));
608:
609: EXECUTE IMMEDIATE(sqlstmt_temp);

Line 606: sqlstmt_temp := REPLACE(sqlstmt_temp, ':PREVIOUS_ASOF_DATE', '''' || to_char(fii_ea_util_pkg.g_previous_asof_date, 'DD/MM/YYYY') || '''');

602: sqlstmt_temp := REPLACE(sqlstmt_temp, ':BOUNDARY_END', '''' || to_char(fii_ea_util_pkg.g_boundary_end, 'DD/MM/YYYY') || '''');
603: sqlstmt_temp := REPLACE(sqlstmt_temp, ':AMOUNT_TYPE_BITAND', to_char(fii_ea_util_pkg.g_amount_type_BITAND));
604: sqlstmt_temp := REPLACE(sqlstmt_temp, ':PRIOR_BOUNDARY_END', '''' || to_char(fii_ea_util_pkg.g_prior_boundary_end, 'DD/MM/YYYY') || '''');
605: sqlstmt_temp := REPLACE(sqlstmt_temp, ':ASOF_DATE', '''' || to_char(fii_ea_util_pkg.g_as_of_date, 'DD/MM/YYYY') || '''');
606: sqlstmt_temp := REPLACE(sqlstmt_temp, ':PREVIOUS_ASOF_DATE', '''' || to_char(fii_ea_util_pkg.g_previous_asof_date, 'DD/MM/YYYY') || '''');
607: sqlstmt_temp := REPLACE(sqlstmt_temp, ':ACTUAL_BITAND', to_char(fii_ea_util_pkg.g_actual_BITAND));
608:
609: EXECUTE IMMEDIATE(sqlstmt_temp);
610:

Line 607: sqlstmt_temp := REPLACE(sqlstmt_temp, ':ACTUAL_BITAND', to_char(fii_ea_util_pkg.g_actual_BITAND));

603: sqlstmt_temp := REPLACE(sqlstmt_temp, ':AMOUNT_TYPE_BITAND', to_char(fii_ea_util_pkg.g_amount_type_BITAND));
604: sqlstmt_temp := REPLACE(sqlstmt_temp, ':PRIOR_BOUNDARY_END', '''' || to_char(fii_ea_util_pkg.g_prior_boundary_end, 'DD/MM/YYYY') || '''');
605: sqlstmt_temp := REPLACE(sqlstmt_temp, ':ASOF_DATE', '''' || to_char(fii_ea_util_pkg.g_as_of_date, 'DD/MM/YYYY') || '''');
606: sqlstmt_temp := REPLACE(sqlstmt_temp, ':PREVIOUS_ASOF_DATE', '''' || to_char(fii_ea_util_pkg.g_previous_asof_date, 'DD/MM/YYYY') || '''');
607: sqlstmt_temp := REPLACE(sqlstmt_temp, ':ACTUAL_BITAND', to_char(fii_ea_util_pkg.g_actual_BITAND));
608:
609: EXECUTE IMMEDIATE(sqlstmt_temp);
610:
611: funds_avail_sql :=