APPS.PAY_SA_SOE dependencies on HR_GENERAL

Line 65: ,hr_general.decode_lookup(''YES_NO'', scl.segment3) COL03

61: /* bug # 10241638 - setting the parameter calendar_aware=>2 for international calendar support */
62:
63: l_sql :=
64: 'SELECT scl.segment2 COL02
65: ,hr_general.decode_lookup(''YES_NO'', scl.segment3) COL03
66: ,fnd_date.date_to_displaydate(fnd_date.canonical_to_date(scl.segment4), 2)
67: COL04
68: ,hr_general.decode_lookup(''YES_NO'', scl.segment5) COL05
69: ,fnd_date.date_to_displaydate(fnd_date.canonical_to_date(scl.segment6), 2)

Line 68: ,hr_general.decode_lookup(''YES_NO'', scl.segment5) COL05

64: 'SELECT scl.segment2 COL02
65: ,hr_general.decode_lookup(''YES_NO'', scl.segment3) COL03
66: ,fnd_date.date_to_displaydate(fnd_date.canonical_to_date(scl.segment4), 2)
67: COL04
68: ,hr_general.decode_lookup(''YES_NO'', scl.segment5) COL05
69: ,fnd_date.date_to_displaydate(fnd_date.canonical_to_date(scl.segment6), 2)
70: COL06 '
71: || ' ,TO_CHAR(TO_CHAR(pay_sa_soe.get_reference_salary(:effective_date,
72: :assignment_action_id)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL07

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

92: ,loc.location_code COL03
93: ,grd.name COL04
94: ,pay.payroll_name COL05
95: ,pos.name COL06
96: ,hr_general.decode_organization(:tax_unit_id) COL07
97: ,pg.group_name COL08
98: ,peo.national_identifier COL09
99: ,hl.meaning COL10
100: ,asg.assignment_number COL11

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

460: pay_soe_util.setValue('04'
461: ,l_balance_type_lst(l_output_table(i).defined_balance_id).defined_balance_name
462: ,FALSE,FALSE);
463: pay_soe_util.setValue('05',
464: hr_general.decode_organization(to_char(l_output_table(i).tax_unit_id))
465: ,FALSE,FALSE);
466: pay_soe_util.setValue('06',to_char(l_output_table(i).tax_unit_id),FALSE,FALSE);
467: pay_soe_util.setValue('07',l_output_table(i).jurisdiction_code,FALSE,FALSE);
468: pay_soe_util.setValue('08',l_output_table(i).source_id,FALSE,FALSE);