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.PAY_ZA_TYE_ARCHIVE_PKG dependencies on PAY_BALANCE_PKG

Line 476: g_defined_balance_lst_normal pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval

472: -- Global variables
473: -----------------------------
474: g_code_list code_list_table ;
475: g_code_bal code_balances_table;
476: g_defined_balance_lst_normal pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval
477: g_defined_balance_lst_lmpsm pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval
478:
479: g_tax_year varchar2(4);
480:

Line 477: g_defined_balance_lst_lmpsm pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval

473: -----------------------------
474: g_code_list code_list_table ;
475: g_code_bal code_balances_table;
476: g_defined_balance_lst_normal pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval
477: g_defined_balance_lst_lmpsm pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval
478:
479: g_tax_year varchar2(4);
480:
481: /*--------------------------------------------------------------------------

Line 3185: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval

3181: l_paye number := 0;
3182: l_taxbale_pkg_cmp number := 0;
3183: l_annual_taxbale_pkg_cmp number := 0;
3184: l_proc varchar2(100) := g_package||'fetch_balances';
3185: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
3186: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
3187: l_site number := 0; -- 9877034 fix
3188: l_period_recon varchar2(30); -- 9877034 fix
3189: l_leg_param varchar2(1000); -- 9877034 fix

Line 3186: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval

3182: l_taxbale_pkg_cmp number := 0;
3183: l_annual_taxbale_pkg_cmp number := 0;
3184: l_proc varchar2(100) := g_package||'fetch_balances';
3185: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
3186: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
3187: l_site number := 0; -- 9877034 fix
3188: l_period_recon varchar2(30); -- 9877034 fix
3189: l_leg_param varchar2(1000); -- 9877034 fix
3190:

Line 3225: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id

3221: l_context_lst(1).source_number2 :=null;
3222: l_context_lst(1).organization_id :=null;
3223:
3224: -- Fetch values for Normal Income codes using batch balance retrieval
3225: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id
3226: , p_defined_balance_lst => g_defined_balance_lst_normal
3227: , p_context_lst => l_context_lst
3228: , p_output_table => l_output_table
3229: );

Line 3381: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id

3377: l_context_lst(1).source_number2 :=null;
3378: l_context_lst(1).organization_id :=null;
3379:
3380: -- Fetch values for Lumpsum codes using batch balance retrieval
3381: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id
3382: ,p_defined_balance_lst => g_defined_balance_lst_lmpsm
3383: ,p_context_lst => l_context_lst
3384: ,p_output_table => l_output_table
3385: );

Line 3534: pay_balance_pkg.set_context('SOURCE_TEXT',l_dir_num_sdl);

3530: -- reset pl/sql tables, total and count variables
3531: l_context_lst.delete;
3532:
3533: -- set context list
3534: pay_balance_pkg.set_context('SOURCE_TEXT',l_dir_num_sdl);
3535:
3536: -- fetch SDL for the dir num
3537: t_code(4142||'-'||l_dir_num_sdl).value := nvl(get_balance_value('Skills Levy LS', '_ASG_LMPSM_TAX_YTD' ,p_assignment_action_id),0);
3538: t_code(4142||'-'||l_dir_num_sdl).group_value := t_code(4142||'-'||l_dir_num_sdl).value;

Line 4323: select pay_balance_pkg.get_value(p_def_bal_id, --p_def_bal_id

4319: where balance_name = p_bal_name
4320: and legislation_code = 'ZA';
4321:
4322: cursor c_get_bal_value( p_def_bal_id in number) is
4323: select pay_balance_pkg.get_value(p_def_bal_id, --p_def_bal_id
4324: p_asg_act_id, --assignment_action_id
4325: null,
4326: null,
4327: null,