DBA Data[Home] [Help]

APPS.PAY_US_ACTION_ARCH dependencies on PAY_US_EMPLOYEE_PAYSLIP_WEB

Line 2876: pay_us_employee_payslip_web.get_jurisdiction_name(

2872: 11, decode(cp_jurisdiction_code,
2873: '00-000-0000', null,
2874: decode(cp_reporting_name,
2875: 'Head Tax Withheld', null,
2876: pay_us_employee_payslip_web.get_jurisdiction_name(
2877: cp_jurisdiction_code) || ' ')),
2878: 8, pay_us_employee_payslip_web.get_jurisdiction_name(
2879: substr(cp_jurisdiction_code,1,2)||'-000-0000') || ' ') ||
2880: decode(fl.description, '', null,

Line 2878: 8, pay_us_employee_payslip_web.get_jurisdiction_name(

2874: decode(cp_reporting_name,
2875: 'Head Tax Withheld', null,
2876: pay_us_employee_payslip_web.get_jurisdiction_name(
2877: cp_jurisdiction_code) || ' ')),
2878: 8, pay_us_employee_payslip_web.get_jurisdiction_name(
2879: substr(cp_jurisdiction_code,1,2)||'-000-0000') || ' ') ||
2880: decode(fl.description, '', null,
2881: nvl(fl.description, cp_reporting_name)) || ' ' ||
2882: decode(length(cp_jurisdiction_code),

Line 2884: pay_us_employee_payslip_web.get_jurisdiction_name(cp_jurisdiction_code)),

2880: decode(fl.description, '', null,
2881: nvl(fl.description, cp_reporting_name)) || ' ' ||
2882: decode(length(cp_jurisdiction_code),
2883: 8, decode(substr(cp_jurisdiction_code,1,2), '36', substr(cp_jurisdiction_code, 4),
2884: pay_us_employee_payslip_web.get_jurisdiction_name(cp_jurisdiction_code)),
2885: 11, decode(cp_reporting_name,
2886: 'Head Tax Withheld', pay_us_employee_payslip_web.get_jurisdiction_name(
2887: cp_jurisdiction_code)))display_name
2888: from fnd_common_lookups fl

Line 2886: 'Head Tax Withheld', pay_us_employee_payslip_web.get_jurisdiction_name(

2882: decode(length(cp_jurisdiction_code),
2883: 8, decode(substr(cp_jurisdiction_code,1,2), '36', substr(cp_jurisdiction_code, 4),
2884: pay_us_employee_payslip_web.get_jurisdiction_name(cp_jurisdiction_code)),
2885: 11, decode(cp_reporting_name,
2886: 'Head Tax Withheld', pay_us_employee_payslip_web.get_jurisdiction_name(
2887: cp_jurisdiction_code)))display_name
2888: from fnd_common_lookups fl
2889: where fl.lookup_type(+) = 'PAY_US_LABELS'
2890: and upper(cp_reporting_name) = fl.lookup_code(+) ;