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 169: pay_magtape_generic.get_parameter_value(

165: 'TRANSFER_PAYROLL_ACTION_ID=P', ppa.payroll_action_id
166: from pay_payroll_actions ppa
167: ,hr_organization_information hoi
168: where ppa.payroll_action_id =
169: pay_magtape_generic.get_parameter_value(
170: 'TRANSFER_PAYROLL_ACTION_ID')
171: and exists (select 'x' from pay_assignment_Actions paa
172: where paa.payroll_action_id = ppa.payroll_action_id
173: and paa.tax_unit_id = hoi.organization_id

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

216: 'US COUNTY',
217: 'US CITY',
218: 'US SCHOOL DISTRICT'
219: )
220: and pai.tax_unit_id = pay_magtape_generic.get_parameter_value(
221: 'TRANSFER_TAX_UNIT_ID')
222: and exists (select 'x'
223: from pay_assignment_actions paa
224: where paa.payroll_action_id =

Line 225: pay_magtape_generic.get_parameter_value(

221: 'TRANSFER_TAX_UNIT_ID')
222: and exists (select 'x'
223: from pay_assignment_actions paa
224: where paa.payroll_action_id =
225: pay_magtape_generic.get_parameter_value(
226: 'TRANSFER_PAYROLL_ACTION_ID')
227: and paa.tax_unit_id =
228: pay_magtape_generic.get_parameter_value(
229: 'TRANSFER_TAX_UNIT_ID')

Line 228: pay_magtape_generic.get_parameter_value(

224: where paa.payroll_action_id =
225: pay_magtape_generic.get_parameter_value(
226: 'TRANSFER_PAYROLL_ACTION_ID')
227: and paa.tax_unit_id =
228: pay_magtape_generic.get_parameter_value(
229: 'TRANSFER_TAX_UNIT_ID')
230: and paa.serial_number = pai.action_context_id
231: )
232: and pay_us_fls_reporting_pkg.get_tax_exists(

Line 234: pay_magtape_generic.get_parameter_value

230: and paa.serial_number = pai.action_context_id
231: )
232: and pay_us_fls_reporting_pkg.get_tax_exists(
233: pai.jurisdiction_code,
234: pay_magtape_generic.get_parameter_value
235: ('TRANSFER_EFFECTIVE_DATE'),
236: fcl.lookup_code) = 'Y'
237: order by pai.jurisdiction_code,
238: decode(length(ltrim(rtrim(pai.action_information30))),

Line 256: pay_magtape_generic.get_parameter_value

252: /* Do not pick EE for FUTA if JD is Federal. Need to
253: check JD and Tax Type as FUTA and SUI have the
254: same Tax Type i.e. UI */
255: where pay_us_fls_reporting_pkg.get_tax_exists(
256: pay_magtape_generic.get_parameter_value
257: ('TRANSFER_JURISDICTION_CODE'),
258: pay_magtape_generic.get_parameter_value
259: ('TRANSFER_EFFECTIVE_DATE'),
260: pay_magtape_generic.get_parameter_value

Line 258: pay_magtape_generic.get_parameter_value

254: same Tax Type i.e. UI */
255: where pay_us_fls_reporting_pkg.get_tax_exists(
256: pay_magtape_generic.get_parameter_value
257: ('TRANSFER_JURISDICTION_CODE'),
258: pay_magtape_generic.get_parameter_value
259: ('TRANSFER_EFFECTIVE_DATE'),
260: pay_magtape_generic.get_parameter_value
261: ('TRANSFER_TAX_TYPE_CODE'),
262: 'EE') = 'Y'

Line 260: pay_magtape_generic.get_parameter_value

256: pay_magtape_generic.get_parameter_value
257: ('TRANSFER_JURISDICTION_CODE'),
258: pay_magtape_generic.get_parameter_value
259: ('TRANSFER_EFFECTIVE_DATE'),
260: pay_magtape_generic.get_parameter_value
261: ('TRANSFER_TAX_TYPE_CODE'),
262: 'EE') = 'Y'
263: UNION ALL
264: select 'TRANSFER_PAYMENT_RESPONSIBILITY=P' , 'ER',

Line 269: where pay_magtape_generic.get_parameter_value

265: 'TRANSFER_RESIDENCY=P' , 'R'
266: from dual
267: /* Return ER for all Jurisdiction where Tax Type is
268: not Income Tax, OPT or EIC */
269: where pay_magtape_generic.get_parameter_value
270: ('TRANSFER_TAX_TYPE_CODE') not in ('IT', 'OPT', 'EIC')
271: and pay_us_fls_reporting_pkg.get_tax_exists(
272: pay_magtape_generic.get_parameter_value
273: ('TRANSFER_JURISDICTION_CODE'),

Line 272: pay_magtape_generic.get_parameter_value

268: not Income Tax, OPT or EIC */
269: where pay_magtape_generic.get_parameter_value
270: ('TRANSFER_TAX_TYPE_CODE') not in ('IT', 'OPT', 'EIC')
271: and pay_us_fls_reporting_pkg.get_tax_exists(
272: pay_magtape_generic.get_parameter_value
273: ('TRANSFER_JURISDICTION_CODE'),
274: pay_magtape_generic.get_parameter_value
275: ('TRANSFER_EFFECTIVE_DATE'),
276: pay_magtape_generic.get_parameter_value

Line 274: pay_magtape_generic.get_parameter_value

270: ('TRANSFER_TAX_TYPE_CODE') not in ('IT', 'OPT', 'EIC')
271: and pay_us_fls_reporting_pkg.get_tax_exists(
272: pay_magtape_generic.get_parameter_value
273: ('TRANSFER_JURISDICTION_CODE'),
274: pay_magtape_generic.get_parameter_value
275: ('TRANSFER_EFFECTIVE_DATE'),
276: pay_magtape_generic.get_parameter_value
277: ('TRANSFER_TAX_TYPE_CODE'),
278: 'ER') = 'Y'

Line 276: pay_magtape_generic.get_parameter_value

272: pay_magtape_generic.get_parameter_value
273: ('TRANSFER_JURISDICTION_CODE'),
274: pay_magtape_generic.get_parameter_value
275: ('TRANSFER_EFFECTIVE_DATE'),
276: pay_magtape_generic.get_parameter_value
277: ('TRANSFER_TAX_TYPE_CODE'),
278: 'ER') = 'Y'
279: UNION ALL
280: select 'TRANSFER_PAYMENT_RESPONSIBILITY=P' , 'EE',

Line 288: where decode(substr(pay_magtape_generic.get_parameter_value

284: be 000, if <> 000 then return true else check if JD
285: is is school, if yes then retrun false.
286: All other cases return false
287: */
288: where decode(substr(pay_magtape_generic.get_parameter_value
289: ('TRANSFER_JURISDICTION_CODE'),4,3), '000',
290: decode(length(pay_magtape_generic.get_parameter_value
291: ('TRANSFER_JURISDICTION_CODE')), 8, -1, -1),
292: 1) = 1

Line 290: decode(length(pay_magtape_generic.get_parameter_value

286: All other cases return false
287: */
288: where decode(substr(pay_magtape_generic.get_parameter_value
289: ('TRANSFER_JURISDICTION_CODE'),4,3), '000',
290: decode(length(pay_magtape_generic.get_parameter_value
291: ('TRANSFER_JURISDICTION_CODE')), 8, -1, -1),
292: 1) = 1
293: and pay_us_fls_reporting_pkg.get_tax_exists(
294: pay_magtape_generic.get_parameter_value

Line 294: pay_magtape_generic.get_parameter_value

290: decode(length(pay_magtape_generic.get_parameter_value
291: ('TRANSFER_JURISDICTION_CODE')), 8, -1, -1),
292: 1) = 1
293: and pay_us_fls_reporting_pkg.get_tax_exists(
294: pay_magtape_generic.get_parameter_value
295: ('TRANSFER_JURISDICTION_CODE'),
296: pay_magtape_generic.get_parameter_value
297: ('TRANSFER_EFFECTIVE_DATE'),
298: pay_magtape_generic.get_parameter_value

Line 296: pay_magtape_generic.get_parameter_value

292: 1) = 1
293: and pay_us_fls_reporting_pkg.get_tax_exists(
294: pay_magtape_generic.get_parameter_value
295: ('TRANSFER_JURISDICTION_CODE'),
296: pay_magtape_generic.get_parameter_value
297: ('TRANSFER_EFFECTIVE_DATE'),
298: pay_magtape_generic.get_parameter_value
299: ('TRANSFER_TAX_TYPE_CODE'),
300: 'EE') = 'Y'

Line 298: pay_magtape_generic.get_parameter_value

294: pay_magtape_generic.get_parameter_value
295: ('TRANSFER_JURISDICTION_CODE'),
296: pay_magtape_generic.get_parameter_value
297: ('TRANSFER_EFFECTIVE_DATE'),
298: pay_magtape_generic.get_parameter_value
299: ('TRANSFER_TAX_TYPE_CODE'),
300: 'EE') = 'Y'
301: -- UNION ALL
302: -- select 'TRANSFER_PAYMENT_RESPONSIBILITY=P' , 'ER',

Line 307: -- where pay_magtape_generic.get_parameter_value

303: -- 'TRANSFER_RESIDENCY=P' , 'NR'
304: -- from dual
305: -- /* Return ER/NR for all local JD where Tax Type is
306: -- not Income Tax or EIC */
307: -- where pay_magtape_generic.get_parameter_value
308: -- ('TRANSFER_TAX_TYPE_CODE') not in ('IT', 'EIC')
309: -- and decode(substr(pay_magtape_generic.get_parameter_value
310: -- ('TRANSFER_JURISDICTION_CODE'),4,3), '000',
311: -- decode(length(pay_magtape_generic.get_parameter_value

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

305: -- /* Return ER/NR for all local JD where Tax Type is
306: -- not Income Tax or EIC */
307: -- where pay_magtape_generic.get_parameter_value
308: -- ('TRANSFER_TAX_TYPE_CODE') not in ('IT', 'EIC')
309: -- and decode(substr(pay_magtape_generic.get_parameter_value
310: -- ('TRANSFER_JURISDICTION_CODE'),4,3), '000',
311: -- decode(length(pay_magtape_generic.get_parameter_value
312: -- ('TRANSFER_JURISDICTION_CODE')), 8, 1, -1),
313: -- 1) = 1

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

307: -- where pay_magtape_generic.get_parameter_value
308: -- ('TRANSFER_TAX_TYPE_CODE') not in ('IT', 'EIC')
309: -- and decode(substr(pay_magtape_generic.get_parameter_value
310: -- ('TRANSFER_JURISDICTION_CODE'),4,3), '000',
311: -- decode(length(pay_magtape_generic.get_parameter_value
312: -- ('TRANSFER_JURISDICTION_CODE')), 8, 1, -1),
313: -- 1) = 1
314: ;
315: