eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_FLS_REPORTING_PKG dependencies on PAY_MAGTAPE_GENERIC

Line 177: pay_magtape_generic.get_parameter_value(

173: 'TRANSFER_PAYROLL_ACTION_ID=P', ppa.payroll_action_id
174: from pay_payroll_actions ppa
175: ,hr_organization_information hoi
176: where ppa.payroll_action_id =
177: pay_magtape_generic.get_parameter_value(
178: 'TRANSFER_PAYROLL_ACTION_ID')
179: and exists (select 'x' from pay_assignment_Actions paa
180: where paa.payroll_action_id = ppa.payroll_action_id
181: and paa.tax_unit_id = hoi.organization_id

Line 229: and pai.tax_unit_id = pay_magtape_generic.get_parameter_value(

225: 'US COUNTY',
226: 'US CITY',
227: 'US SCHOOL DISTRICT'
228: )
229: and pai.tax_unit_id = pay_magtape_generic.get_parameter_value(
230: 'TRANSFER_TAX_UNIT_ID')
231: and exists (select 'x'
232: from pay_assignment_actions paa
233: where paa.payroll_action_id =

Line 234: pay_magtape_generic.get_parameter_value(

230: 'TRANSFER_TAX_UNIT_ID')
231: and exists (select 'x'
232: from pay_assignment_actions paa
233: where paa.payroll_action_id =
234: pay_magtape_generic.get_parameter_value(
235: 'TRANSFER_PAYROLL_ACTION_ID')
236: and paa.tax_unit_id =
237: pay_magtape_generic.get_parameter_value(
238: 'TRANSFER_TAX_UNIT_ID')

Line 237: pay_magtape_generic.get_parameter_value(

233: where paa.payroll_action_id =
234: pay_magtape_generic.get_parameter_value(
235: 'TRANSFER_PAYROLL_ACTION_ID')
236: and paa.tax_unit_id =
237: pay_magtape_generic.get_parameter_value(
238: 'TRANSFER_TAX_UNIT_ID')
239: and paa.serial_number = pai.action_context_id
240: )
241: and pay_us_fls_reporting_pkg.get_tax_exists(

Line 243: pay_magtape_generic.get_parameter_value

239: and paa.serial_number = pai.action_context_id
240: )
241: and pay_us_fls_reporting_pkg.get_tax_exists(
242: pai.jurisdiction_code,
243: pay_magtape_generic.get_parameter_value
244: ('TRANSFER_EFFECTIVE_DATE'),
245: fcl.lookup_code) = 'Y'
246: order by pai.jurisdiction_code,
247: decode(length(ltrim(rtrim(pai.action_information30))),

Line 265: pay_magtape_generic.get_parameter_value

261: /* Do not pick EE for FUTA if JD is Federal. Need to
262: check JD and Tax Type as FUTA and SUI have the
263: same Tax Type i.e. UI */
264: where pay_us_fls_reporting_pkg.get_tax_exists(
265: pay_magtape_generic.get_parameter_value
266: ('TRANSFER_JURISDICTION_CODE'),
267: pay_magtape_generic.get_parameter_value
268: ('TRANSFER_EFFECTIVE_DATE'),
269: pay_magtape_generic.get_parameter_value

Line 267: pay_magtape_generic.get_parameter_value

263: same Tax Type i.e. UI */
264: where pay_us_fls_reporting_pkg.get_tax_exists(
265: pay_magtape_generic.get_parameter_value
266: ('TRANSFER_JURISDICTION_CODE'),
267: pay_magtape_generic.get_parameter_value
268: ('TRANSFER_EFFECTIVE_DATE'),
269: pay_magtape_generic.get_parameter_value
270: ('TRANSFER_TAX_TYPE_CODE'),
271: 'EE') = 'Y'

Line 269: pay_magtape_generic.get_parameter_value

265: pay_magtape_generic.get_parameter_value
266: ('TRANSFER_JURISDICTION_CODE'),
267: pay_magtape_generic.get_parameter_value
268: ('TRANSFER_EFFECTIVE_DATE'),
269: pay_magtape_generic.get_parameter_value
270: ('TRANSFER_TAX_TYPE_CODE'),
271: 'EE') = 'Y'
272: UNION ALL
273: select 'TRANSFER_PAYMENT_RESPONSIBILITY=P' , 'ER',

Line 278: where pay_magtape_generic.get_parameter_value

274: 'TRANSFER_RESIDENCY=P' , 'R'
275: from dual
276: /* Return ER for all Jurisdiction where Tax Type is
277: not Income Tax, OPT or EIC */
278: where pay_magtape_generic.get_parameter_value
279: ('TRANSFER_TAX_TYPE_CODE') not in ('IT', 'OPT', 'EIC')
280: and pay_us_fls_reporting_pkg.get_tax_exists(
281: pay_magtape_generic.get_parameter_value
282: ('TRANSFER_JURISDICTION_CODE'),

Line 281: pay_magtape_generic.get_parameter_value

277: not Income Tax, OPT or EIC */
278: where pay_magtape_generic.get_parameter_value
279: ('TRANSFER_TAX_TYPE_CODE') not in ('IT', 'OPT', 'EIC')
280: and pay_us_fls_reporting_pkg.get_tax_exists(
281: pay_magtape_generic.get_parameter_value
282: ('TRANSFER_JURISDICTION_CODE'),
283: pay_magtape_generic.get_parameter_value
284: ('TRANSFER_EFFECTIVE_DATE'),
285: pay_magtape_generic.get_parameter_value

Line 283: pay_magtape_generic.get_parameter_value

279: ('TRANSFER_TAX_TYPE_CODE') not in ('IT', 'OPT', 'EIC')
280: and pay_us_fls_reporting_pkg.get_tax_exists(
281: pay_magtape_generic.get_parameter_value
282: ('TRANSFER_JURISDICTION_CODE'),
283: pay_magtape_generic.get_parameter_value
284: ('TRANSFER_EFFECTIVE_DATE'),
285: pay_magtape_generic.get_parameter_value
286: ('TRANSFER_TAX_TYPE_CODE'),
287: 'ER') = 'Y'

Line 285: pay_magtape_generic.get_parameter_value

281: pay_magtape_generic.get_parameter_value
282: ('TRANSFER_JURISDICTION_CODE'),
283: pay_magtape_generic.get_parameter_value
284: ('TRANSFER_EFFECTIVE_DATE'),
285: pay_magtape_generic.get_parameter_value
286: ('TRANSFER_TAX_TYPE_CODE'),
287: 'ER') = 'Y'
288: UNION ALL
289: select 'TRANSFER_PAYMENT_RESPONSIBILITY=P' , 'EE',

Line 297: where decode(substr(pay_magtape_generic.get_parameter_value

293: be 000, if <> 000 then return true else check if JD
294: is is school, if yes then retrun false.
295: All other cases return false
296: */
297: where decode(substr(pay_magtape_generic.get_parameter_value
298: ('TRANSFER_JURISDICTION_CODE'),4,3), '000',
299: decode(length(pay_magtape_generic.get_parameter_value
300: ('TRANSFER_JURISDICTION_CODE')), 8, -1, -1),
301: 1) = 1

Line 299: decode(length(pay_magtape_generic.get_parameter_value

295: All other cases return false
296: */
297: where decode(substr(pay_magtape_generic.get_parameter_value
298: ('TRANSFER_JURISDICTION_CODE'),4,3), '000',
299: decode(length(pay_magtape_generic.get_parameter_value
300: ('TRANSFER_JURISDICTION_CODE')), 8, -1, -1),
301: 1) = 1
302: and pay_us_fls_reporting_pkg.get_tax_exists(
303: pay_magtape_generic.get_parameter_value

Line 303: pay_magtape_generic.get_parameter_value

299: decode(length(pay_magtape_generic.get_parameter_value
300: ('TRANSFER_JURISDICTION_CODE')), 8, -1, -1),
301: 1) = 1
302: and pay_us_fls_reporting_pkg.get_tax_exists(
303: pay_magtape_generic.get_parameter_value
304: ('TRANSFER_JURISDICTION_CODE'),
305: pay_magtape_generic.get_parameter_value
306: ('TRANSFER_EFFECTIVE_DATE'),
307: pay_magtape_generic.get_parameter_value

Line 305: pay_magtape_generic.get_parameter_value

301: 1) = 1
302: and pay_us_fls_reporting_pkg.get_tax_exists(
303: pay_magtape_generic.get_parameter_value
304: ('TRANSFER_JURISDICTION_CODE'),
305: pay_magtape_generic.get_parameter_value
306: ('TRANSFER_EFFECTIVE_DATE'),
307: pay_magtape_generic.get_parameter_value
308: ('TRANSFER_TAX_TYPE_CODE'),
309: 'EE') = 'Y'

Line 307: pay_magtape_generic.get_parameter_value

303: pay_magtape_generic.get_parameter_value
304: ('TRANSFER_JURISDICTION_CODE'),
305: pay_magtape_generic.get_parameter_value
306: ('TRANSFER_EFFECTIVE_DATE'),
307: pay_magtape_generic.get_parameter_value
308: ('TRANSFER_TAX_TYPE_CODE'),
309: 'EE') = 'Y'
310: -- UNION ALL
311: -- select 'TRANSFER_PAYMENT_RESPONSIBILITY=P' , 'ER',

Line 316: -- where pay_magtape_generic.get_parameter_value

312: -- 'TRANSFER_RESIDENCY=P' , 'NR'
313: -- from dual
314: -- /* Return ER/NR for all local JD where Tax Type is
315: -- not Income Tax or EIC */
316: -- where pay_magtape_generic.get_parameter_value
317: -- ('TRANSFER_TAX_TYPE_CODE') not in ('IT', 'EIC')
318: -- and decode(substr(pay_magtape_generic.get_parameter_value
319: -- ('TRANSFER_JURISDICTION_CODE'),4,3), '000',
320: -- decode(length(pay_magtape_generic.get_parameter_value

Line 318: -- and decode(substr(pay_magtape_generic.get_parameter_value

314: -- /* Return ER/NR for all local JD where Tax Type is
315: -- not Income Tax or EIC */
316: -- where pay_magtape_generic.get_parameter_value
317: -- ('TRANSFER_TAX_TYPE_CODE') not in ('IT', 'EIC')
318: -- and decode(substr(pay_magtape_generic.get_parameter_value
319: -- ('TRANSFER_JURISDICTION_CODE'),4,3), '000',
320: -- decode(length(pay_magtape_generic.get_parameter_value
321: -- ('TRANSFER_JURISDICTION_CODE')), 8, 1, -1),
322: -- 1) = 1

Line 320: -- decode(length(pay_magtape_generic.get_parameter_value

316: -- where pay_magtape_generic.get_parameter_value
317: -- ('TRANSFER_TAX_TYPE_CODE') not in ('IT', 'EIC')
318: -- and decode(substr(pay_magtape_generic.get_parameter_value
319: -- ('TRANSFER_JURISDICTION_CODE'),4,3), '000',
320: -- decode(length(pay_magtape_generic.get_parameter_value
321: -- ('TRANSFER_JURISDICTION_CODE')), 8, 1, -1),
322: -- 1) = 1
323: ;
324: