DBA Data[Home] [Help]

APPS.PAY_US_ACTION_ARCH dependencies on PAY_US_EMPLOYEE_PAYSLIP_WEB

Line 3448: pay_us_employee_payslip_web.get_jurisdiction_name(

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,

Line 3450: 8, pay_us_employee_payslip_web.get_jurisdiction_name(

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),

Line 3456: pay_us_employee_payslip_web.get_jurisdiction_name(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

Line 3458: 'Head Tax Withheld', pay_us_employee_payslip_web.get_jurisdiction_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
3461: where fl.lookup_type(+) = 'PAY_US_LABELS'
3462: and upper(cp_reporting_name) = fl.lookup_code(+) ;