APPS.PAY_SOE_GLB dependencies on PAY_BALANCE_PKG

Line 517: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;

513: l_st2_needed_chr varchar2(10);
514: l_found boolean;
515: balCount number;
516: --
517: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
518: l_context_lst pay_balance_pkg.t_context_tab;
519: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
520: --
521: i number;

Line 518: l_context_lst pay_balance_pkg.t_context_tab;

514: l_found boolean;
515: balCount number;
516: --
517: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
518: l_context_lst pay_balance_pkg.t_context_tab;
519: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
520: --
521: i number;
522: --

Line 519: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;

515: balCount number;
516: --
517: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
518: l_context_lst pay_balance_pkg.t_context_tab;
519: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
520: --
521: i number;
522: --
523: --

Line 595: 'Y', pay_balance_pkg.find_context('SOURCE_ID'

591: select distinct
592: aa.tax_unit_id tax_unit_id
593: , rr.jurisdiction_code jurisdiction_code
594: , decode(l_si_needed_chr,
595: 'Y', pay_balance_pkg.find_context('SOURCE_ID'
596: ,rr.run_result_id)
597: ,null) source_id
598: , decode(l_st_needed_chr,
599: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'

Line 599: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'

595: 'Y', pay_balance_pkg.find_context('SOURCE_ID'
596: ,rr.run_result_id)
597: ,null) source_id
598: , decode(l_st_needed_chr,
599: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'
600: ,rr.run_result_id)
601: ,null) source_text
602: , decode(l_sn_needed_chr,
603: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'

Line 603: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'

599: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'
600: ,rr.run_result_id)
601: ,null) source_text
602: , decode(l_sn_needed_chr,
603: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'
604: ,rr.run_result_id)
605: ,null) source_number
606: , decode(l_st2_needed_chr,
607: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'

Line 607: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'

603: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'
604: ,rr.run_result_id)
605: ,null) source_number
606: , decode(l_st2_needed_chr,
607: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
608: ,rr.run_result_id)
609: ,null) source_text2
610: from pay_assignment_actions aa,
611: pay_payroll_actions pa,

Line 659: pay_balance_pkg.get_period_type_start

655: db.dimension_name;
656: l_balance_type_lst(db.defined_balance_id).defined_balance_id :=
657: db.defined_balance_id;
658: --
659: pay_balance_pkg.get_period_type_start
660: (p_period_type => db.period_type
661: ,p_effective_date => l_effective_date
662: ,p_payroll_id => l_payroll_id
663: ,p_start_date => l_temp_date);

Line 743: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id

739: if g_debug then
740: hr_utility.set_location('pay_soe_glb.getBalances', 50);
741: end if;
742: --
743: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id
744: ,p_defined_balance_lst => l_defined_balance_lst
745: ,p_context_lst => l_context_lst
746: ,p_output_table => l_output_table);
747: --