983: from ff_globals_f
984: where global_name = 'CPF_ORD_MONTH_CAP_AMT'
985: and p_date_earned between effective_start_date and effective_end_date;
986: --
987: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
988: g_context_tab pay_balance_pkg.t_context_tab;
989: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
990: --
991: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
984: where global_name = 'CPF_ORD_MONTH_CAP_AMT'
985: and p_date_earned between effective_start_date and effective_end_date;
986: --
987: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
988: g_context_tab pay_balance_pkg.t_context_tab;
989: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
990: --
991: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
992: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
985: and p_date_earned between effective_start_date and effective_end_date;
986: --
987: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
988: g_context_tab pay_balance_pkg.t_context_tab;
989: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
990: --
991: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
992: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
993: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
1043: g_context_tab(1).tax_unit_id := l_tax_unit_id;
1044: g_context_tab(2).tax_unit_id := l_tax_unit_id;
1045: g_context_tab(3).tax_unit_id := l_tax_unit_id;
1046: --
1047: pay_balance_pkg.get_value ( l_assignment_action_id,
1048: g_balance_value_tab,
1049: g_context_tab,
1050: false,
1051: false,
1168: from ff_globals_f
1169: where global_name = 'CPF_ORD_MONTH_CAP_AMT'
1170: and p_date_earned between effective_start_date and effective_end_date;
1171: --
1172: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1173: g_context_tab pay_balance_pkg.t_context_tab;
1174: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1175: --
1176: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1169: where global_name = 'CPF_ORD_MONTH_CAP_AMT'
1170: and p_date_earned between effective_start_date and effective_end_date;
1171: --
1172: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1173: g_context_tab pay_balance_pkg.t_context_tab;
1174: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1175: --
1176: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1177: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
1170: and p_date_earned between effective_start_date and effective_end_date;
1171: --
1172: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1173: g_context_tab pay_balance_pkg.t_context_tab;
1174: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1175: --
1176: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1177: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
1178: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
1226: g_context_tab(1).tax_unit_id := l_tax_unit_id;
1227: g_context_tab(2).tax_unit_id := l_tax_unit_id;
1228: g_context_tab(3).tax_unit_id := l_tax_unit_id;
1229: --
1230: pay_balance_pkg.get_value ( l_assignment_action_id,
1231: g_balance_value_tab,
1232: g_context_tab,
1233: false,
1234: false,