APPS.PAY_SA_SOE dependencies on HR_GENERAL

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

58: -- COL07 : GOSI Reference Earnings
59: --
60: l_sql :=
61: 'SELECT scl.segment2 COL02
62: ,hr_general.decode_lookup(''YES_NO'', scl.segment3) COL03
63: ,fnd_date.date_to_displaydate(fnd_date.canonical_to_date(scl.segment4))
64: COL04
65: ,hr_general.decode_lookup(''YES_NO'', scl.segment5) COL05
66: ,fnd_date.date_to_displaydate(fnd_date.canonical_to_date(scl.segment6))

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

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

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

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

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

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