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 553: SELECT hr_general.decode_lookup('AE_LOAN_TYPE',result_value)

549: --------------------------------------------------------------------
550: FUNCTION ae_loan_type (p_assignment_action_id NUMBER, p_run_result_id NUMBER , p_effective_date date)
551: RETURN VARCHAR2 IS
552: CURSOR csr_loan_type IS
553: SELECT hr_general.decode_lookup('AE_LOAN_TYPE',result_value)
554: FROM pay_run_results rr
555: ,pay_run_result_values rrv
556: ,pay_input_values_f iv
557: ,pay_input_values_f_tl ivt