APPS.PAY_AE_SOE dependencies on HR_GENERAL

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

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

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

425: pay_soe_util.setValue('04'
426: ,l_balance_type_lst(l_output_table(i).defined_balance_id).defined_balance_name
427: ,FALSE,FALSE);
428: pay_soe_util.setValue('05',
429: hr_general.decode_organization(to_char(l_output_table(i).tax_unit_id))
430: ,FALSE,FALSE);
431: pay_soe_util.setValue('06',to_char(l_output_table(i).tax_unit_id),FALSE,FALSE);
432: pay_soe_util.setValue('07',l_output_table(i).jurisdiction_code,FALSE,FALSE);
433: pay_soe_util.setValue('08',l_output_table(i).source_id,FALSE,FALSE);

Line 559: SELECT hr_general.decode_lookup('AE_LOAN_TYPE',result_value)

555: --------------------------------------------------------------------
556: FUNCTION ae_loan_type (p_assignment_action_id NUMBER, p_run_result_id NUMBER , p_effective_date date)
557: RETURN VARCHAR2 IS
558: CURSOR csr_loan_type IS
559: SELECT hr_general.decode_lookup('AE_LOAN_TYPE',result_value)
560: FROM pay_run_results rr
561: ,pay_run_result_values rrv
562: ,pay_input_values_f iv
563: ,pay_input_values_f_tl ivt