APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PAY_US_EMPLOYEE_PAYSLIP_WEB

Line 1786: pay_us_employee_payslip_web.get_jurisdiction_name(cp_jurisdiction_code) || ' ')),

1782: 11,DECODE(cp_jurisdiction_code,
1783: '00-000-0000', NULL,
1784: DECODE(cp_reporting_name,
1785: 'Head Tax Withheld', NULL,
1786: pay_us_employee_payslip_web.get_jurisdiction_name(cp_jurisdiction_code) || ' ')),
1787: 8, pay_us_employee_payslip_web.get_jurisdiction_name(
1788: SUBSTR(cp_jurisdiction_code,1,2)||'-000-0000') || ' ')||
1789: DECODE(fl.description,
1790: '', NULL,

Line 1787: 8, pay_us_employee_payslip_web.get_jurisdiction_name(

1783: '00-000-0000', NULL,
1784: DECODE(cp_reporting_name,
1785: 'Head Tax Withheld', NULL,
1786: pay_us_employee_payslip_web.get_jurisdiction_name(cp_jurisdiction_code) || ' ')),
1787: 8, pay_us_employee_payslip_web.get_jurisdiction_name(
1788: SUBSTR(cp_jurisdiction_code,1,2)||'-000-0000') || ' ')||
1789: DECODE(fl.description,
1790: '', NULL,
1791: NVL(fl.description, cp_reporting_name)) || ' ' ||

Line 1795: pay_us_employee_payslip_web.get_jurisdiction_name(cp_jurisdiction_code)),

1791: NVL(fl.description, cp_reporting_name)) || ' ' ||
1792: DECODE(LENGTH(cp_jurisdiction_code),
1793: 8, DECODE(SUBSTR(cp_jurisdiction_code,1,2),
1794: '36', SUBSTR(cp_jurisdiction_code, 4),
1795: pay_us_employee_payslip_web.get_jurisdiction_name(cp_jurisdiction_code)),
1796: 11, DECODE(cp_reporting_name,
1797: 'Head Tax Withheld', pay_us_employee_payslip_web.get_jurisdiction_name(
1798: cp_jurisdiction_code))) display_name
1799: FROM fnd_common_lookups fl

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

1793: 8, DECODE(SUBSTR(cp_jurisdiction_code,1,2),
1794: '36', SUBSTR(cp_jurisdiction_code, 4),
1795: pay_us_employee_payslip_web.get_jurisdiction_name(cp_jurisdiction_code)),
1796: 11, DECODE(cp_reporting_name,
1797: 'Head Tax Withheld', pay_us_employee_payslip_web.get_jurisdiction_name(
1798: cp_jurisdiction_code))) display_name
1799: FROM fnd_common_lookups fl
1800: WHERE fl.lookup_type(+) = 'PAY_US_LABELS'
1801: AND upper(cp_reporting_name) = fl.lookup_code(+);

Line 4124: pay_us_employee_payslip_web.get_check_number(csr_get_sim_arch_info_rec.action_information17

4120: AND pay_payroll_xml_extract_pkg.g_leg_code = 'US' THEN
4121:
4122: build_sql(sqlstr,l_cntr_sql,
4123: 'csr_get_sim_arch_info_rec.action_information4 :=
4124: pay_us_employee_payslip_web.get_check_number(csr_get_sim_arch_info_rec.action_information17
4125: ,csr_get_sim_arch_info_rec.action_information15);');
4126:
4127: build_sql(sqlstr,l_cntr_sql,
4128: 'csr_get_sim_arch_info_rec.action_information7 :=