[Home] [Help]
1: package body pay_sg_soe as
2: /* $Header: pysgsoe.pkb 120.3 2008/05/28 01:41:37 jalin noship $ */
3: ------------------------------------------------------------------------
4: -- Selects the Salary for the Person.
5: -- clone of hr_general.get_salary but fetch at a given date
96: -- for the SOE window
97: ------------------------------------------------------------------------
98: /* Bug:2883606. This procedure is modified to retrieve balance values
99: directly from pay_balance_pkg.get_value instead of retrieving it from
100: the view pay_sg_soe_balances_v */
101:
102: procedure current_and_ytd_balances
103: (p_prepaid_tag in varchar,
104: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
332: -- for the Pay Advice report
333: ------------------------------------------------------------------------
334: /* Bug:2883606. This procedure is modified to retrieve balance values
335: directly from pay_balance_pkg.get_value instead of retrieving it from
336: the view pay_sg_soe_balances_v */
337:
338: procedure current_and_ytd_balances
339: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
340: p_balance_name in pay_balance_types.balance_name%type,
606: v_tax_id := get_tax_id(p_assignment_action_id);
607:
608: pay_balance_pkg.set_context('TAX_UNIT_ID',v_tax_id);
609: -- Call procedure to get Current and YTD balances for Payment Summary Totals
610: hr_utility.trace('JL pay_sg_soe, p_assignment_action_id:'||p_assignment_action_id);
611: current_and_ytd_balances (p_prepaid_tag => p_prepaid_tag,
612: p_assignment_action_id => p_assignment_action_id,
613: p_balance_name => 'Gross Pay',
614: p_person_id => p_person_id,
1070: close csr_get_payroll_id;
1071: return v_currency_code;
1072: end get_assignment_currency_code;
1073:
1074: end pay_sg_soe;