APPS.PAY_SOE_GLB dependencies on PAY_BALANCE_PKG

Line 583: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;

579: l_st2_needed_chr varchar2(10);
580: l_found boolean;
581: balCount number;
582: --
583: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
584: l_context_lst pay_balance_pkg.t_context_tab;
585: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
586: --
587: i number;

Line 584: l_context_lst pay_balance_pkg.t_context_tab;

580: l_found boolean;
581: balCount number;
582: --
583: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
584: l_context_lst pay_balance_pkg.t_context_tab;
585: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
586: --
587: i number;
588: --

Line 585: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;

581: balCount number;
582: --
583: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
584: l_context_lst pay_balance_pkg.t_context_tab;
585: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
586: --
587: i number;
588: --
589: --

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

657: select distinct
658: aa.tax_unit_id tax_unit_id
659: , rr.jurisdiction_code jurisdiction_code
660: , decode(l_si_needed_chr,
661: 'Y', pay_balance_pkg.find_context('SOURCE_ID'
662: ,rr.run_result_id)
663: ,null) source_id
664: , decode(l_st_needed_chr,
665: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'

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

661: 'Y', pay_balance_pkg.find_context('SOURCE_ID'
662: ,rr.run_result_id)
663: ,null) source_id
664: , decode(l_st_needed_chr,
665: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'
666: ,rr.run_result_id)
667: ,null) source_text
668: , decode(l_sn_needed_chr,
669: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'

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

665: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'
666: ,rr.run_result_id)
667: ,null) source_text
668: , decode(l_sn_needed_chr,
669: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'
670: ,rr.run_result_id)
671: ,null) source_number
672: , decode(l_st2_needed_chr,
673: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'

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

669: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'
670: ,rr.run_result_id)
671: ,null) source_number
672: , decode(l_st2_needed_chr,
673: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
674: ,rr.run_result_id)
675: ,null) source_text2
676: from pay_assignment_actions aa,
677: pay_payroll_actions pa,

Line 729: pay_balance_pkg.get_period_type_start

725: db.dimension_name;
726: l_balance_type_lst(db.defined_balance_id).defined_balance_id :=
727: db.defined_balance_id;
728: --
729: pay_balance_pkg.get_period_type_start
730: (p_period_type => db.period_type
731: ,p_effective_date => l_effective_date
732: ,p_payroll_id => l_payroll_id
733: ,p_start_date => l_temp_date);

Line 813: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id

809: if g_debug then
810: hr_utility.set_location('pay_soe_glb.getBalances', 50);
811: end if;
812: --
813: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id
814: ,p_defined_balance_lst => l_defined_balance_lst
815: ,p_context_lst => l_context_lst
816: ,p_output_table => l_output_table);
817: --