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_SQWL_ARCHIVE dependencies on PAY_MAGTAPE_GENERIC

Line 103: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value

99: 'TRANSFER_BUSINESS_GROUP_ID=P', PA.business_group_id
100: from pay_state_rules SR,
101: pay_assignment_actions AA,
102: pay_payroll_actions PA
103: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value
104: ('TRANSFER_PAYROLL_ACTION_ID')
105: and PA.payroll_action_id = AA.payroll_action_id
106: and SR.state_code = pay_magtape_generic.get_parameter_value
107: ('TRANSFER_STATE');

Line 106: and SR.state_code = pay_magtape_generic.get_parameter_value

102: pay_payroll_actions PA
103: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value
104: ('TRANSFER_PAYROLL_ACTION_ID')
105: and PA.payroll_action_id = AA.payroll_action_id
106: and SR.state_code = pay_magtape_generic.get_parameter_value
107: ('TRANSFER_STATE');
108:
109: -- Used by California (Multi Wage Plan) for State Quarterly Wage Listing.
110: -- Added by Ashu Gupta (ashgupta) on 10-FEB-2000

Line 131: 'TRANSFER_REPORT_FORMAT=P', pay_magtape_generic.get_parameter_value

127: 'DATE_EARNED=C' , fnd_date.date_to_canonical(PA.effective_date),
128: 'BUSINESS_GROUP_ID=C', PA.business_group_id,
129: 'TRANSFER_COMPANY_SUI_ID=P', hoi.org_information2,
130: 'TRANSFER_WAGE_PLAN_CODE=P', hoi.org_information3,
131: 'TRANSFER_REPORT_FORMAT=P', pay_magtape_generic.get_parameter_value
132: ('TRANSFER_REPORT_CATEGORY')
133: from pay_payroll_actions PA,
134: pay_assignment_actions AA,
135: pay_state_rules SR,

Line 137: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value

133: from pay_payroll_actions PA,
134: pay_assignment_actions AA,
135: pay_state_rules SR,
136: hr_organization_information hoi
137: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value
138: ('TRANSFER_PAYROLL_ACTION_ID')
139: and PA.payroll_action_id = AA.payroll_action_id
140: and SR.state_code = pay_magtape_generic.get_parameter_value
141: ('TRANSFER_STATE')

Line 140: and SR.state_code = pay_magtape_generic.get_parameter_value

136: hr_organization_information hoi
137: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value
138: ('TRANSFER_PAYROLL_ACTION_ID')
139: and PA.payroll_action_id = AA.payroll_action_id
140: and SR.state_code = pay_magtape_generic.get_parameter_value
141: ('TRANSFER_STATE')
142: and hoi.org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
143: and hoi.organization_id = AA.tax_unit_id
144: and hoi.org_information1 = pay_magtape_generic.get_parameter_value

Line 144: and hoi.org_information1 = pay_magtape_generic.get_parameter_value

140: and SR.state_code = pay_magtape_generic.get_parameter_value
141: ('TRANSFER_STATE')
142: and hoi.org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
143: and hoi.organization_id = AA.tax_unit_id
144: and hoi.org_information1 = pay_magtape_generic.get_parameter_value
145: ('TRANSFER_STATE')
146: and EXISTS (SELECT /*+ ordered */NULL
147: FROM pay_assignment_actions paa,
148: ff_archive_items fai,

Line 170: pay_magtape_generic.get_parameter_value

166: -- current relative to the period being reported on.
167: --
168: cursor sqwl_transmitter is
169: select 'TAX_UNIT_ID=C',
170: pay_magtape_generic.get_parameter_value
171: ('TRANSFER_TRANS_LEGAL_CO_ID'),
172: 'JURISDICTION_CODE=C',
173: SR.jurisdiction_code,
174: 'PAYROLL_ACTION_ID=C',

Line 175: pay_magtape_generic.get_parameter_value

171: ('TRANSFER_TRANS_LEGAL_CO_ID'),
172: 'JURISDICTION_CODE=C',
173: SR.jurisdiction_code,
174: 'PAYROLL_ACTION_ID=C',
175: pay_magtape_generic.get_parameter_value
176: ('TRANSFER_PAYROLL_ACTION_ID'),
177: 'TRANSFER_SUI_WAGE_BASE=P',
178: nvl(FFAI.value,' ')
179: from pay_state_rules SR,

Line 182: where SR.state_code = pay_magtape_generic.get_parameter_value

178: nvl(FFAI.value,' ')
179: from pay_state_rules SR,
180: ff_archive_items ffai,
181: ff_database_items fdi
182: where SR.state_code = pay_magtape_generic.get_parameter_value
183: ('TRANSFER_STATE')
184: and ffai.user_entity_id = fdi.user_entity_id
185: and fdi.user_name = 'A_SUI_TAXABLE_WAGE_BASE'
186: and ffai.context1 = pay_magtape_generic.get_parameter_value

Line 186: and ffai.context1 = pay_magtape_generic.get_parameter_value

182: where SR.state_code = pay_magtape_generic.get_parameter_value
183: ('TRANSFER_STATE')
184: and ffai.user_entity_id = fdi.user_entity_id
185: and fdi.user_name = 'A_SUI_TAXABLE_WAGE_BASE'
186: and ffai.context1 = pay_magtape_generic.get_parameter_value
187: ('TRANSFER_PAYROLL_ACTION_ID');
188:
189: cursor sqwl_employee is
190: select 'TRANSFER_ASS_ACTION_ID=C', AA.assignment_action_id,

Line 194: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned

190: select 'TRANSFER_ASS_ACTION_ID=C', AA.assignment_action_id,
191: 'ASSIGNMENT_ACTION_ID=C' , AA.assignment_action_id,
192: 'ASSIGNMENT_ID=C' , AA.assignment_id,
193: 'ASSIGNMENT_ID=P' , AA.assignment_id, /* Bug 976472 */
194: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned
195: (PA.effective_date, AA.assignment_id))
196: from per_all_people_f PE,
197: per_all_assignments_f SS,
198: pay_assignment_actions AA,

Line 200: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value

196: from per_all_people_f PE,
197: per_all_assignments_f SS,
198: pay_assignment_actions AA,
199: pay_payroll_actions PA
200: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
201: ('TRANSFER_PAYROLL_ACTION_ID')
202: and AA.payroll_action_id = PA.payroll_action_id
203: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value
204: ('TAX_UNIT_ID')

Line 203: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value

199: pay_payroll_actions PA
200: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
201: ('TRANSFER_PAYROLL_ACTION_ID')
202: and AA.payroll_action_id = PA.payroll_action_id
203: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value
204: ('TAX_UNIT_ID')
205: and SS.assignment_id = AA.assignment_id
206: and PE.person_id = SS.person_id
207: /* commented for bug 2464463

Line 208: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between

204: ('TAX_UNIT_ID')
205: and SS.assignment_id = AA.assignment_id
206: and PE.person_id = SS.person_id
207: /* commented for bug 2464463
208: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between
209: SS.effective_start_date and SS.effective_end_date
210: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between
211: PE.effective_start_date and PE.effective_end_date
212: */

Line 210: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between

206: and PE.person_id = SS.person_id
207: /* commented for bug 2464463
208: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between
209: SS.effective_start_date and SS.effective_end_date
210: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between
211: PE.effective_start_date and PE.effective_end_date
212: */
213:
214: /* Added for bug 2464463 */

Line 235: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned

231: select 'TRANSFER_ASS_ACTION_ID=C', AA.assignment_action_id,
232: 'ASSIGNMENT_ACTION_ID=C' , AA.assignment_action_id,
233: 'ASSIGNMENT_ID=C' , AA.assignment_id,
234: 'ASSIGNMENT_ID=P' , AA.assignment_id, /* Bug 976472 */
235: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned
236: (PA.effective_date, AA.assignment_id))
237: from per_all_people_f PE,
238: per_all_assignments_f SS,
239: pay_assignment_actions AA,

Line 241: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value

237: from per_all_people_f PE,
238: per_all_assignments_f SS,
239: pay_assignment_actions AA,
240: pay_payroll_actions PA
241: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
242: ('TRANSFER_PAYROLL_ACTION_ID')
243: and AA.payroll_action_id = PA.payroll_action_id
244: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value
245: ('TAX_UNIT_ID')

Line 244: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value

240: pay_payroll_actions PA
241: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
242: ('TRANSFER_PAYROLL_ACTION_ID')
243: and AA.payroll_action_id = PA.payroll_action_id
244: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value
245: ('TAX_UNIT_ID')
246: and SS.assignment_id = AA.assignment_id
247: and PE.person_id = SS.person_id
248: AND nvl(AA.serial_number,'0') <> 'X'

Line 272: 'DATE_EARNED=C' , fnd_date.date_to_canonical(pay_magtape_generic.date_earned

268: select /*+ ORDERED */ 'TRANSFER_ASS_ACTION_ID=C', AA.assignment_action_id,
269: 'ASSIGNMENT_ACTION_ID=C' , AA.assignment_action_id,
270: 'ASSIGNMENT_ID=C' , AA.assignment_id,
271: 'ASSIGNMENT_ID=P' , AA.assignment_id,
272: 'DATE_EARNED=C' , fnd_date.date_to_canonical(pay_magtape_generic.date_earned
273: (PA.effective_date,
274: AA.assignment_id)),
275: 'TRANSFER_WAGE_PLAN_CODE=P',pay_magtape_generic.get_parameter_value
276: ('TRANSFER_WAGE_PLAN_CODE'),

Line 275: 'TRANSFER_WAGE_PLAN_CODE=P',pay_magtape_generic.get_parameter_value

271: 'ASSIGNMENT_ID=P' , AA.assignment_id,
272: 'DATE_EARNED=C' , fnd_date.date_to_canonical(pay_magtape_generic.date_earned
273: (PA.effective_date,
274: AA.assignment_id)),
275: 'TRANSFER_WAGE_PLAN_CODE=P',pay_magtape_generic.get_parameter_value
276: ('TRANSFER_WAGE_PLAN_CODE'),
277: 'TRANSFER_REPORT_FORMAT=P', pay_magtape_generic.get_parameter_value
278: ('TRANSFER_REPORT_CATEGORY')
279: from pay_payroll_actions PA,

Line 277: 'TRANSFER_REPORT_FORMAT=P', pay_magtape_generic.get_parameter_value

273: (PA.effective_date,
274: AA.assignment_id)),
275: 'TRANSFER_WAGE_PLAN_CODE=P',pay_magtape_generic.get_parameter_value
276: ('TRANSFER_WAGE_PLAN_CODE'),
277: 'TRANSFER_REPORT_FORMAT=P', pay_magtape_generic.get_parameter_value
278: ('TRANSFER_REPORT_CATEGORY')
279: from pay_payroll_actions PA,
280: pay_assignment_actions AA,
281: per_all_assignments_f SS,

Line 285: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value

281: per_all_assignments_f SS,
282: per_all_people_f PE,
283: ff_archive_items fai,
284: ff_user_entities fue
285: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
286: ('TRANSFER_PAYROLL_ACTION_ID')
287: and AA.payroll_action_id = PA.payroll_action_id
288: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value
289: ('TAX_UNIT_ID')

Line 288: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value

284: ff_user_entities fue
285: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
286: ('TRANSFER_PAYROLL_ACTION_ID')
287: and AA.payroll_action_id = PA.payroll_action_id
288: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value
289: ('TAX_UNIT_ID')
290: and SS.assignment_id = AA.assignment_id
291: and PE.person_id = SS.person_id
292: /* commented for bug 2464463

Line 293: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between

289: ('TAX_UNIT_ID')
290: and SS.assignment_id = AA.assignment_id
291: and PE.person_id = SS.person_id
292: /* commented for bug 2464463
293: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between
294: SS.effective_start_date and SS.effective_end_date
295: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between
296: PE.effective_start_date and PE.effective_end_date
297: */

Line 295: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between

291: and PE.person_id = SS.person_id
292: /* commented for bug 2464463
293: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between
294: SS.effective_start_date and SS.effective_end_date
295: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between
296: PE.effective_start_date and PE.effective_end_date
297: */
298: /* Added for bug 2464463 */
299: AND SS.effective_start_date =

Line 312: pay_magtape_generic.get_parameter_value('TRANSFER_WAGE_PLAN_CODE')

308: between PE.effective_start_date and PE.effective_end_date
309: /* End of Change for bug 2464463 */
310: AND aa.assignment_action_id = fai.context1
311: and fai.value =
312: pay_magtape_generic.get_parameter_value('TRANSFER_WAGE_PLAN_CODE')
313: and fai.user_entity_id = fue.user_entity_id
314: and fue.user_entity_name = 'A_SCL_ASG_US_CA_WAGE_PLAN_CODE'
315: and NOT EXISTS (SELECT value
316: FROM ff_archive_items fai1

Line 340: where paf.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')

336: 'JURISDICTION_CODE=C', pcty.jurisdiction_code
337: from pay_us_emp_city_tax_rules_f pcty,
338: per_assignments_f paf1,
339: per_assignments_f paf
340: where paf.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
341: and paf.effective_end_date >=
342: to_date('01-01-2001','DD-MM-YYYY')
343: and paf.effective_start_date <=
344: to_date('31-03-2001','DD-MM-YYYY')

Line 370: where paf.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')

366: 'JURISDICTION_CODE=C', pcty.jurisdiction_code
367: from pay_us_emp_city_tax_rules_f pcty,
368: per_assignments_f paf1,
369: per_assignments_f paf
370: where paf.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
371: and paf.effective_end_date >= (
372: select
373: decode(
374: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),

Line 374: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),

370: where paf.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
371: and paf.effective_end_date >= (
372: select
373: decode(
374: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),
375: '4',
376: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),
377: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')
378: )

Line 376: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),

372: select
373: decode(
374: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),
375: '4',
376: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),
377: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')
378: )
379: from dual
380: )

Line 377: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')

373: decode(
374: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),
375: '4',
376: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),
377: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')
378: )
379: from dual
380: )
381: and paf.effective_start_date <=

Line 382: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE'),'DD-MM-YYYY')

378: )
379: from dual
380: )
381: and paf.effective_start_date <=
382: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE'),'DD-MM-YYYY')
383: and paf1.person_id = paf.person_id
384: and paf1.effective_end_date >=(
385: select
386: decode(

Line 387: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),

383: and paf1.person_id = paf.person_id
384: and paf1.effective_end_date >=(
385: select
386: decode(
387: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),
388: '4',
389: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),
390: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')
391: )

Line 389: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),

385: select
386: decode(
387: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),
388: '4',
389: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),
390: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')
391: )
392: from dual
393: )

Line 390: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')

386: decode(
387: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),
388: '4',
389: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),
390: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')
391: )
392: from dual
393: )
394: and paf1.effective_start_date <=

Line 395: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE'),'DD-MM-YYYY')

391: )
392: from dual
393: )
394: and paf1.effective_start_date <=
395: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE'),'DD-MM-YYYY')
396: and pcty.assignment_id = paf1.assignment_id
397: and pcty.effective_start_date <=
398: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE'),'DD-MM-YYYY')
399: and pcty.effective_end_date >=(

Line 398: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE'),'DD-MM-YYYY')

394: and paf1.effective_start_date <=
395: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE'),'DD-MM-YYYY')
396: and pcty.assignment_id = paf1.assignment_id
397: and pcty.effective_start_date <=
398: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE'),'DD-MM-YYYY')
399: and pcty.effective_end_date >=(
400: select
401: decode(
402: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),

Line 402: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),

398: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE'),'DD-MM-YYYY')
399: and pcty.effective_end_date >=(
400: select
401: decode(
402: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),
403: '4',
404: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),
405: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')
406: )

Line 404: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),

400: select
401: decode(
402: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),
403: '4',
404: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),
405: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')
406: )
407: from dual
408: )

Line 405: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')

401: decode(
402: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),
403: '4',
404: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),
405: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')
406: )
407: from dual
408: )
409: and pcty.jurisdiction_code in ('33-005-2010',

Line 421: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

417: from ff_archive_items fai,
418: ff_archive_item_contexts faic,
419: pay_assignment_actions paa,
420: pay_payroll_actions ppa
421: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
422: and ppa.payroll_action_id = paa.payroll_action_id
423: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
424: and fai.context1 = paa.assignment_action_id
425: and faic.archive_item_id = fai.archive_item_id

Line 423: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')

419: pay_assignment_actions paa,
420: pay_payroll_actions ppa
421: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
422: and ppa.payroll_action_id = paa.payroll_action_id
423: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
424: and fai.context1 = paa.assignment_action_id
425: and faic.archive_item_id = fai.archive_item_id
426: and faic.context in ('33-005-2010',
427: '33-047-2010',

Line 442: pay_magtape_generic.get_parameter_value ('TRANSFER_TRANS_LEGAL_CO_ID'),

438: /* for bug 2752145, commented the join with hr_organization_information,
439: this to remove the dependency on W2 reporting rules for SQWL */
440: cursor mmrf_sqwl_transmitter is
441: select 'TAX_UNIT_ID=C',
442: pay_magtape_generic.get_parameter_value ('TRANSFER_TRANS_LEGAL_CO_ID'),
443: 'JURISDICTION_CODE=C', SR.jurisdiction_code,
444: 'TRANSFER_JD=P', SR.jurisdiction_code,
445: 'ASSIGNMENT_ID=C' , '-1',
446: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),

Line 448: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),

444: 'TRANSFER_JD=P', SR.jurisdiction_code,
445: 'ASSIGNMENT_ID=C' , '-1',
446: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
447: 'PAYROLL_ACTION_ID=C',
448: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),
449: -- 'TRANSFER_2678_FILER=P', HOI.org_information8,
450: 'BUSINESS_GROUP_ID=C' , PPA.business_group_id,
451: 'TRANSFER_BUSINESS_GROUP_ID=P',PPA.business_group_id,
452: 'TRANSFER_SUI_WAGE_BASE=P', nvl(FFAI.value,' '),

Line 453: 'TRANSFER_REPORT_CATEGORY=P', pay_magtape_generic.get_parameter_value

449: -- 'TRANSFER_2678_FILER=P', HOI.org_information8,
450: 'BUSINESS_GROUP_ID=C' , PPA.business_group_id,
451: 'TRANSFER_BUSINESS_GROUP_ID=P',PPA.business_group_id,
452: 'TRANSFER_SUI_WAGE_BASE=P', nvl(FFAI.value,' '),
453: 'TRANSFER_REPORT_CATEGORY=P', pay_magtape_generic.get_parameter_value
454: ('TRANSFER_REPORT_CATEGORY')
455: from pay_state_rules SR,
456: ff_archive_items ffai,
457: ff_database_items fdi,

Line 460: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value

456: ff_archive_items ffai,
457: ff_database_items fdi,
458: -- hr_organization_information hoi,
459: pay_payroll_actions ppa
460: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
461: ('TRANSFER_PAYROLL_ACTION_ID')
462: -- and hoi.organization_id = pay_magtape_generic.get_parameter_value
463: -- ('TRANSFER_TRANS_LEGAL_CO_ID')
464: -- and hoi.org_information_context = 'W2 Reporting Rules'

Line 462: -- and hoi.organization_id = pay_magtape_generic.get_parameter_value

458: -- hr_organization_information hoi,
459: pay_payroll_actions ppa
460: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
461: ('TRANSFER_PAYROLL_ACTION_ID')
462: -- and hoi.organization_id = pay_magtape_generic.get_parameter_value
463: -- ('TRANSFER_TRANS_LEGAL_CO_ID')
464: -- and hoi.org_information_context = 'W2 Reporting Rules'
465: and SR.state_code = pay_magtape_generic.get_parameter_value
466: ('TRANSFER_STATE')

Line 465: and SR.state_code = pay_magtape_generic.get_parameter_value

461: ('TRANSFER_PAYROLL_ACTION_ID')
462: -- and hoi.organization_id = pay_magtape_generic.get_parameter_value
463: -- ('TRANSFER_TRANS_LEGAL_CO_ID')
464: -- and hoi.org_information_context = 'W2 Reporting Rules'
465: and SR.state_code = pay_magtape_generic.get_parameter_value
466: ('TRANSFER_STATE')
467: and ffai.user_entity_id = fdi.user_entity_id
468: and fdi.user_name = 'A_SUI_TAXABLE_WAGE_BASE'
469: and ffai.context1 = pay_magtape_generic.get_parameter_value

Line 469: and ffai.context1 = pay_magtape_generic.get_parameter_value

465: and SR.state_code = pay_magtape_generic.get_parameter_value
466: ('TRANSFER_STATE')
467: and ffai.user_entity_id = fdi.user_entity_id
468: and fdi.user_name = 'A_SUI_TAXABLE_WAGE_BASE'
469: and ffai.context1 = pay_magtape_generic.get_parameter_value
470: ('TRANSFER_PAYROLL_ACTION_ID');
471:
472:
473:

Line 484: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value

480: 'TAX_UNIT_NAME=P' , substr(hou.name,1,81)
481: from hr_all_organization_units hou,
482: pay_assignment_actions AA,
483: pay_payroll_actions PA
484: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value
485: ('TRANSFER_PAYROLL_ACTION_ID')
486: and PA.payroll_action_id = AA.payroll_action_id
487: and AA.tax_unit_id = hou.organization_id
488: order by substr(hou.name,1,81); /* Bug 12664972 internal_prm_values table in package pay_mag_tape

Line 507: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value

503: from hr_all_organization_units hou,
504: hr_organization_information hoi,
505: pay_assignment_actions AA,
506: pay_payroll_actions PA
507: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value
508: ('TRANSFER_PAYROLL_ACTION_ID')
509: and PA.payroll_action_id = AA.payroll_action_id
510: and AA.tax_unit_id = hou.organization_id
511: and hoi.organization_id = hou.organization_id

Line 520: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned(PA.effective_date, AA.assignment_id))

516: select 'TRANSFER_ASS_ACTION_ID=C', AA.assignment_action_id,
517: 'ASSIGNMENT_ACTION_ID=C' , AA.assignment_action_id,
518: 'ASSIGNMENT_ID=C' , AA.assignment_id,
519: 'ASSIGNMENT_ID=P' , AA.assignment_id, /* Bug 976472 */
520: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned(PA.effective_date, AA.assignment_id))
521: from per_all_people_f PE,
522: per_all_assignments_f SS,
523: pay_assignment_actions AA,
524: pay_payroll_actions PA

Line 525: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value

521: from per_all_people_f PE,
522: per_all_assignments_f SS,
523: pay_assignment_actions AA,
524: pay_payroll_actions PA
525: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
526: ('TRANSFER_PAYROLL_ACTION_ID')
527: and AA.payroll_action_id = PA.payroll_action_id
528: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value
529: ('TAX_UNIT_ID')

Line 528: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value

524: pay_payroll_actions PA
525: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
526: ('TRANSFER_PAYROLL_ACTION_ID')
527: and AA.payroll_action_id = PA.payroll_action_id
528: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value
529: ('TAX_UNIT_ID')
530: and SS.assignment_id = AA.assignment_id
531: and PE.person_id = SS.person_id
532: /* commented for bug 2464463

Line 533: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between

529: ('TAX_UNIT_ID')
530: and SS.assignment_id = AA.assignment_id
531: and PE.person_id = SS.person_id
532: /* commented for bug 2464463
533: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between
534: SS.effective_start_date and SS.effective_end_date
535: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between
536: PE.effective_start_date and PE.effective_end_date
537: */

Line 535: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between

531: and PE.person_id = SS.person_id
532: /* commented for bug 2464463
533: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between
534: SS.effective_start_date and SS.effective_end_date
535: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between
536: PE.effective_start_date and PE.effective_end_date
537: */
538: /* Added for bug 2464463 */
539: AND SS.effective_start_date =

Line 559: where SR.state_code = pay_magtape_generic.get_parameter_value('TRANSFER_STATE')

555: 'TRANSFER_AMOUNT_WITHHELD_ME=P', hoi.org_information3,
556: 'TRANSFER_PAYMENT_DEPOSITED_ME=P', hoi.org_information4
557: from pay_state_rules SR,
558: hr_organization_information hoi
559: where SR.state_code = pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
560: and hoi.org_information_context = 'SQWL Employer Rules 3'
561: and hoi.organization_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
562: and hoi.org_information1 = pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
563: and to_date(hoi.org_information2,'YYYY/MM/DD HH24:MI:SS') between

Line 561: and hoi.organization_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')

557: from pay_state_rules SR,
558: hr_organization_information hoi
559: where SR.state_code = pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
560: and hoi.org_information_context = 'SQWL Employer Rules 3'
561: and hoi.organization_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
562: and hoi.org_information1 = pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
563: and to_date(hoi.org_information2,'YYYY/MM/DD HH24:MI:SS') between
564: add_months(last_day(to_date(
565: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER')

Line 562: and hoi.org_information1 = pay_magtape_generic.get_parameter_value('TRANSFER_STATE')

558: hr_organization_information hoi
559: where SR.state_code = pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
560: and hoi.org_information_context = 'SQWL Employer Rules 3'
561: and hoi.organization_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
562: and hoi.org_information1 = pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
563: and to_date(hoi.org_information2,'YYYY/MM/DD HH24:MI:SS') between
564: add_months(last_day(to_date(
565: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER')
566: ,'MMYYYY')),-3) + 1

Line 565: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER')

561: and hoi.organization_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
562: and hoi.org_information1 = pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
563: and to_date(hoi.org_information2,'YYYY/MM/DD HH24:MI:SS') between
564: add_months(last_day(to_date(
565: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER')
566: ,'MMYYYY')),-3) + 1
567: and last_day(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY')) ;
568:
569: -- ***********SQWL Cursors Ends *************************

Line 567: and last_day(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY')) ;

563: and to_date(hoi.org_information2,'YYYY/MM/DD HH24:MI:SS') between
564: add_months(last_day(to_date(
565: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER')
566: ,'MMYYYY')),-3) + 1
567: and last_day(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY')) ;
568:
569: -- ***********SQWL Cursors Ends *************************
570:
571: TYPE char240_data_type_table IS TABLE OF VARCHAR2(240)