3444: 11, decode(cp_jurisdiction_code,
3445: '00-000-0000', null,
3446: decode(cp_reporting_name,
3447: 'Head Tax Withheld', null,
3448: pay_us_employee_payslip_web.get_jurisdiction_name(
3449: cp_jurisdiction_code) || ' ')),
3450: 8, pay_us_employee_payslip_web.get_jurisdiction_name(
3451: substr(cp_jurisdiction_code,1,2)||'-000-0000') || ' ') ||
3452: decode(fl.description, '', null,
3446: decode(cp_reporting_name,
3447: 'Head Tax Withheld', null,
3448: pay_us_employee_payslip_web.get_jurisdiction_name(
3449: cp_jurisdiction_code) || ' ')),
3450: 8, pay_us_employee_payslip_web.get_jurisdiction_name(
3451: substr(cp_jurisdiction_code,1,2)||'-000-0000') || ' ') ||
3452: decode(fl.description, '', null,
3453: nvl(fl.description, cp_reporting_name)) || ' ' ||
3454: decode(length(cp_jurisdiction_code),
3452: decode(fl.description, '', null,
3453: nvl(fl.description, cp_reporting_name)) || ' ' ||
3454: decode(length(cp_jurisdiction_code),
3455: 8, decode(substr(cp_jurisdiction_code,1,2), '36', substr(cp_jurisdiction_code, 4),
3456: pay_us_employee_payslip_web.get_jurisdiction_name(cp_jurisdiction_code)),
3457: 11, decode(cp_reporting_name,
3458: 'Head Tax Withheld', pay_us_employee_payslip_web.get_jurisdiction_name(
3459: cp_jurisdiction_code)))display_name
3460: from fnd_common_lookups fl
3454: decode(length(cp_jurisdiction_code),
3455: 8, decode(substr(cp_jurisdiction_code,1,2), '36', substr(cp_jurisdiction_code, 4),
3456: pay_us_employee_payslip_web.get_jurisdiction_name(cp_jurisdiction_code)),
3457: 11, decode(cp_reporting_name,
3458: 'Head Tax Withheld', pay_us_employee_payslip_web.get_jurisdiction_name(
3459: cp_jurisdiction_code)))display_name
3460: from fnd_common_lookups fl
3461: where fl.lookup_type(+) = 'PAY_US_LABELS'
3462: and upper(cp_reporting_name) = fl.lookup_code(+) ;