APPS.PAY_DK_SOE dependencies on PAY_BALANCE_PKG

Line 546: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;

542:
543: /* Added for display of Pension Provider balances */
544: l_org_needed_chr varchar2(10);
545: --
546: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
547: l_context_lst pay_balance_pkg.t_context_tab;
548: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
549: --
550: i number;

Line 547: l_context_lst pay_balance_pkg.t_context_tab;

543: /* Added for display of Pension Provider balances */
544: l_org_needed_chr varchar2(10);
545: --
546: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
547: l_context_lst pay_balance_pkg.t_context_tab;
548: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
549: --
550: i number;
551: /* Added for display of Pension Provider balances */

Line 548: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;

544: l_org_needed_chr varchar2(10);
545: --
546: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
547: l_context_lst pay_balance_pkg.t_context_tab;
548: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
549: --
550: i number;
551: /* Added for display of Pension Provider balances */
552: j number;

Line 553: temp pay_balance_pkg.t_detailed_bal_out_tab;

549: --
550: i number;
551: /* Added for display of Pension Provider balances */
552: j number;
553: temp pay_balance_pkg.t_detailed_bal_out_tab;
554: --
555: --
556: cursor getAction is
557: select pa.payroll_id

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

610: select distinct
611: aa.tax_unit_id tax_unit_id
612: , rr.jurisdiction_code jurisdiction_code
613: , decode(l_si_needed_chr,
614: 'Y', pay_balance_pkg.find_context('SOURCE_ID'
615: ,rr.run_result_id)
616: ,null) source_id
617: , decode(l_st_needed_chr,
618: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'

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

614: 'Y', pay_balance_pkg.find_context('SOURCE_ID'
615: ,rr.run_result_id)
616: ,null) source_id
617: , decode(l_st_needed_chr,
618: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'
619: ,rr.run_result_id)
620: ,null) source_text
621: , decode(l_sn_needed_chr,
622: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'

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

618: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'
619: ,rr.run_result_id)
620: ,null) source_text
621: , decode(l_sn_needed_chr,
622: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'
623: ,rr.run_result_id)
624: ,null) source_number
625: , decode(l_st2_needed_chr,
626: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'

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

622: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'
623: ,rr.run_result_id)
624: ,null) source_number
625: , decode(l_st2_needed_chr,
626: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
627: ,rr.run_result_id)
628: ,null) source_text2
629: /* Added for display of Pension Provider balances */
630: , decode(l_org_needed_chr,

Line 631: 'Y', pay_balance_pkg.find_context('ORGANIZATION_ID'

627: ,rr.run_result_id)
628: ,null) source_text2
629: /* Added for display of Pension Provider balances */
630: , decode(l_org_needed_chr,
631: 'Y', pay_balance_pkg.find_context('ORGANIZATION_ID'
632: ,rr.run_result_id)
633: ,null) organization_id
634: from pay_assignment_actions aa,
635: pay_payroll_actions pa,

Line 707: pay_balance_pkg.get_period_type_start

703: db.dimension_name;
704: l_balance_type_lst(db.defined_balance_id).defined_balance_id :=
705: db.defined_balance_id;
706: --
707: pay_balance_pkg.get_period_type_start
708: (p_period_type => db.period_type
709: ,p_effective_date => l_effective_date
710: ,p_payroll_id => l_payroll_id
711: ,p_start_date => l_temp_date);

Line 804: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id

800: if g_debug then
801: hr_utility.set_location('pay_dk_soe.getBalances', 50);
802: end if;
803: --
804: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id
805: ,p_defined_balance_lst => l_defined_balance_lst
806: ,p_context_lst => l_context_lst
807: ,p_output_table => l_output_table);
808: --