[Home] [Help]
199: FUNCTION get_full_jurisdiction_name( p_jurisdiction_code in varchar2)
200: return varchar2;
201:
202: -- This Function has been Added for Bug# 6739242
203: -- For CA OT Enhancement pay_action_information started getting
204: -- Populated with Account Details that is NOT needed to be displayed
205: -- In Self Service Payslip
206: FUNCTION get_netpaydistr_segment(p_business_grp_id IN NUMBER
207: ,p_org_pay_meth_id IN NUMBER)
264: paf.payroll_id,
265: paf.assignment_id,
266: pai.action_information2
267: FROM
268: pay_action_information pai,
269: per_all_assignments_f paf
270: WHERE paf.person_id = to_number(v_person_id)
271: AND paf.assignment_id = pai.assignment_id
272: AND pai.action_information_category = 'EMPLOYEE PAYMENT INFORMATION'