DBA Data[Home] [Help]

APPS.PAY_SG_DEDUCTIONS dependencies on PAY_BALANCE_PKG

Line 1164: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

1160: from ff_globals_f
1161: where global_name = 'CPF_ORD_MONTH_CAP_AMT'
1162: and p_date between effective_start_date and effective_end_date;
1163:
1164: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1165: g_context_tab pay_balance_pkg.t_context_tab;
1166: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1167: --
1168: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 1165: g_context_tab pay_balance_pkg.t_context_tab;

1161: where global_name = 'CPF_ORD_MONTH_CAP_AMT'
1162: and p_date between effective_start_date and effective_end_date;
1163:
1164: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1165: g_context_tab pay_balance_pkg.t_context_tab;
1166: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1167: --
1168: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1169: l_action_sequence pay_assignment_actions.action_sequence%TYPE;

Line 1166: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;

1162: and p_date between effective_start_date and effective_end_date;
1163:
1164: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1165: g_context_tab pay_balance_pkg.t_context_tab;
1166: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1167: --
1168: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1169: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
1170: l_assignment_id pay_assignment_actions.assignment_id%TYPE;

Line 1247: pay_balance_pkg.get_value ( l_assignment_action_id,

1243: fetch c_globals into l_ord_mon_cap_amt, l_ord_mon_cap_amt_tmp;
1244: close c_globals;
1245: end if;
1246:
1247: pay_balance_pkg.get_value ( l_assignment_action_id,
1248: g_balance_value_tab,
1249: g_context_tab,
1250: false,
1251: false,

Line 1374: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

1370: from ff_globals_f
1371: where global_name = 'CPF_ORD_MONTH_CAP_AMT'
1372: and p_date between effective_start_date and effective_end_date;
1373: --
1374: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1375: g_context_tab pay_balance_pkg.t_context_tab;
1376: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1377: --
1378: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 1375: g_context_tab pay_balance_pkg.t_context_tab;

1371: where global_name = 'CPF_ORD_MONTH_CAP_AMT'
1372: and p_date between effective_start_date and effective_end_date;
1373: --
1374: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1375: g_context_tab pay_balance_pkg.t_context_tab;
1376: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1377: --
1378: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1379: l_action_sequence pay_assignment_actions.action_sequence%TYPE;

Line 1376: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;

1372: and p_date between effective_start_date and effective_end_date;
1373: --
1374: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1375: g_context_tab pay_balance_pkg.t_context_tab;
1376: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1377: --
1378: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1379: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
1380: l_assignment_id pay_assignment_actions.assignment_id%TYPE;

Line 1455: pay_balance_pkg.get_value ( l_assignment_action_id,

1451: g_context_tab(1).tax_unit_id := l_tax_unit_id;
1452: g_context_tab(2).tax_unit_id := l_tax_unit_id;
1453: g_context_tab(3).tax_unit_id := l_tax_unit_id;
1454: --
1455: pay_balance_pkg.get_value ( l_assignment_action_id,
1456: g_balance_value_tab,
1457: g_context_tab,
1458: false,
1459: false,