APPS.PAY_KW_SOE dependencies on HR_GENERAL

Line 15: ,hr_general.decode_organization(:tax_unit_id) COL07

11: ,loc.location_code COL03
12: ,grd.name COL04
13: ,pay.payroll_name COL05
14: ,pos.name COL06
15: ,hr_general.decode_organization(:tax_unit_id) COL07
16: ,pg.group_name COL08
17: ,peo.national_identifier COL09
18: ,hl.meaning COL10
19: ,asg.assignment_number COL11

Line 419: hr_general.decode_organization(to_char(l_output_table(i).tax_unit_id))

415: pay_soe_util.setValue('04'
416: ,l_balance_type_lst(l_output_table(i).defined_balance_id).defined_balance_name
417: ,FALSE,FALSE);
418: pay_soe_util.setValue('05',
419: hr_general.decode_organization(to_char(l_output_table(i).tax_unit_id))
420: ,FALSE,FALSE);
421: pay_soe_util.setValue('06',to_char(l_output_table(i).tax_unit_id),FALSE,FALSE);
422: pay_soe_util.setValue('07',l_output_table(i).jurisdiction_code,FALSE,FALSE);
423: pay_soe_util.setValue('08',l_output_table(i).source_id,FALSE,FALSE);

Line 543: SELECT hr_general.decode_lookup('KW_LOAN_TYPE',result_value)

539: --------------------------------------------------------------------
540: FUNCTION kw_loan_type (p_assignment_action_id NUMBER, p_run_result_id NUMBER , p_effective_date date)
541: RETURN VARCHAR2 IS
542: CURSOR csr_loan_type IS
543: SELECT hr_general.decode_lookup('KW_LOAN_TYPE',result_value)
544: FROM pay_run_results rr
545: ,pay_run_result_values rrv
546: ,pay_input_values_f iv
547: ,pay_input_values_f_tl ivt