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 101: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value

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

Line 104: and SR.state_code = pay_magtape_generic.get_parameter_value

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

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

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

Line 135: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value

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

Line 138: and SR.state_code = pay_magtape_generic.get_parameter_value

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

Line 142: and hoi.org_information1 = pay_magtape_generic.get_parameter_value

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

Line 168: pay_magtape_generic.get_parameter_value

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

Line 173: pay_magtape_generic.get_parameter_value

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

Line 180: where SR.state_code = pay_magtape_generic.get_parameter_value

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

Line 184: and ffai.context1 = pay_magtape_generic.get_parameter_value

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

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

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

Line 198: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value

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

Line 201: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value

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

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

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

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

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

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

231: select /*+ ORDERED */ '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,
235: 'DATE_EARNED=C' , fnd_date.date_to_canonical(pay_magtape_generic.date_earned
236: (PA.effective_date,
237: AA.assignment_id)),
238: 'TRANSFER_WAGE_PLAN_CODE=P',pay_magtape_generic.get_parameter_value
239: ('TRANSFER_WAGE_PLAN_CODE'),

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

234: 'ASSIGNMENT_ID=P' , AA.assignment_id,
235: 'DATE_EARNED=C' , fnd_date.date_to_canonical(pay_magtape_generic.date_earned
236: (PA.effective_date,
237: AA.assignment_id)),
238: 'TRANSFER_WAGE_PLAN_CODE=P',pay_magtape_generic.get_parameter_value
239: ('TRANSFER_WAGE_PLAN_CODE'),
240: 'TRANSFER_REPORT_FORMAT=P', pay_magtape_generic.get_parameter_value
241: ('TRANSFER_REPORT_CATEGORY')
242: from pay_payroll_actions PA,

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

236: (PA.effective_date,
237: AA.assignment_id)),
238: 'TRANSFER_WAGE_PLAN_CODE=P',pay_magtape_generic.get_parameter_value
239: ('TRANSFER_WAGE_PLAN_CODE'),
240: 'TRANSFER_REPORT_FORMAT=P', pay_magtape_generic.get_parameter_value
241: ('TRANSFER_REPORT_CATEGORY')
242: from pay_payroll_actions PA,
243: pay_assignment_actions AA,
244: per_all_assignments_f SS,

Line 248: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value

244: per_all_assignments_f SS,
245: per_all_people_f PE,
246: ff_archive_items fai,
247: ff_user_entities fue
248: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
249: ('TRANSFER_PAYROLL_ACTION_ID')
250: and AA.payroll_action_id = PA.payroll_action_id
251: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value
252: ('TAX_UNIT_ID')

Line 251: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value

247: ff_user_entities fue
248: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
249: ('TRANSFER_PAYROLL_ACTION_ID')
250: and AA.payroll_action_id = PA.payroll_action_id
251: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value
252: ('TAX_UNIT_ID')
253: and SS.assignment_id = AA.assignment_id
254: and PE.person_id = SS.person_id
255: /* commented for bug 2464463

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

252: ('TAX_UNIT_ID')
253: and SS.assignment_id = AA.assignment_id
254: and PE.person_id = SS.person_id
255: /* commented for bug 2464463
256: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between
257: SS.effective_start_date and SS.effective_end_date
258: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between
259: PE.effective_start_date and PE.effective_end_date
260: */

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

254: and PE.person_id = SS.person_id
255: /* commented for bug 2464463
256: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between
257: SS.effective_start_date and SS.effective_end_date
258: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between
259: PE.effective_start_date and PE.effective_end_date
260: */
261: /* Added for bug 2464463 */
262: AND SS.effective_start_date =

Line 275: pay_magtape_generic.get_parameter_value('TRANSFER_WAGE_PLAN_CODE')

271: between PE.effective_start_date and PE.effective_end_date
272: /* End of Change for bug 2464463 */
273: AND aa.assignment_action_id = fai.context1
274: and fai.value =
275: pay_magtape_generic.get_parameter_value('TRANSFER_WAGE_PLAN_CODE')
276: and fai.user_entity_id = fue.user_entity_id
277: and fue.user_entity_name = 'A_SCL_ASG_US_CA_WAGE_PLAN_CODE'
278: and NOT EXISTS (SELECT value
279: FROM ff_archive_items fai1

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

299: 'JURISDICTION_CODE=C', pcty.jurisdiction_code
300: from pay_us_emp_city_tax_rules_f pcty,
301: per_assignments_f paf1,
302: per_assignments_f paf
303: where paf.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
304: and paf.effective_end_date >=
305: to_date('01-01-2001','DD-MM-YYYY')
306: and paf.effective_start_date <=
307: to_date('31-03-2001','DD-MM-YYYY')

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

329: 'JURISDICTION_CODE=C', pcty.jurisdiction_code
330: from pay_us_emp_city_tax_rules_f pcty,
331: per_assignments_f paf1,
332: per_assignments_f paf
333: where paf.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
334: and paf.effective_end_date >= (
335: select
336: decode(
337: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),

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

333: where paf.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
334: and paf.effective_end_date >= (
335: select
336: decode(
337: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),
338: '4',
339: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),
340: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')
341: )

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

335: select
336: decode(
337: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),
338: '4',
339: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),
340: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')
341: )
342: from dual
343: )

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

336: decode(
337: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),
338: '4',
339: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),
340: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')
341: )
342: from dual
343: )
344: and paf.effective_start_date <=

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

341: )
342: from dual
343: )
344: and paf.effective_start_date <=
345: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE'),'DD-MM-YYYY')
346: and paf1.person_id = paf.person_id
347: and paf1.effective_end_date >=(
348: select
349: decode(

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

346: and paf1.person_id = paf.person_id
347: and paf1.effective_end_date >=(
348: select
349: decode(
350: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),
351: '4',
352: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),
353: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')
354: )

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

348: select
349: decode(
350: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),
351: '4',
352: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),
353: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')
354: )
355: from dual
356: )

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

349: decode(
350: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),
351: '4',
352: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),
353: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')
354: )
355: from dual
356: )
357: and paf1.effective_start_date <=

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

354: )
355: from dual
356: )
357: and paf1.effective_start_date <=
358: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE'),'DD-MM-YYYY')
359: and pcty.assignment_id = paf1.assignment_id
360: and pcty.effective_start_date <=
361: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE'),'DD-MM-YYYY')
362: and pcty.effective_end_date >=(

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

357: and paf1.effective_start_date <=
358: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE'),'DD-MM-YYYY')
359: and pcty.assignment_id = paf1.assignment_id
360: and pcty.effective_start_date <=
361: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE'),'DD-MM-YYYY')
362: and pcty.effective_end_date >=(
363: select
364: decode(
365: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),

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

361: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE'),'DD-MM-YYYY')
362: and pcty.effective_end_date >=(
363: select
364: decode(
365: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),
366: '4',
367: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),
368: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')
369: )

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

363: select
364: decode(
365: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),
366: '4',
367: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),
368: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')
369: )
370: from dual
371: )

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

364: decode(
365: to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER') ,'MMYYYY'),'Q'),
366: '4',
367: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Y'),
368: trunc(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY'),'Q')
369: )
370: from dual
371: )
372: and pcty.jurisdiction_code in ('33-005-2010',

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

380: from ff_archive_items fai,
381: ff_archive_item_contexts faic,
382: pay_assignment_actions paa,
383: pay_payroll_actions ppa
384: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
385: and ppa.payroll_action_id = paa.payroll_action_id
386: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
387: and fai.context1 = paa.assignment_action_id
388: and faic.archive_item_id = fai.archive_item_id

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

382: pay_assignment_actions paa,
383: pay_payroll_actions ppa
384: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
385: and ppa.payroll_action_id = paa.payroll_action_id
386: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
387: and fai.context1 = paa.assignment_action_id
388: and faic.archive_item_id = fai.archive_item_id
389: and faic.context in ('33-005-2010',
390: '33-047-2010',

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

401: /* for bug 2752145, commented the join with hr_organization_information,
402: this to remove the dependency on W2 reporting rules for SQWL */
403: cursor mmrf_sqwl_transmitter is
404: select 'TAX_UNIT_ID=C',
405: pay_magtape_generic.get_parameter_value ('TRANSFER_TRANS_LEGAL_CO_ID'),
406: 'JURISDICTION_CODE=C', SR.jurisdiction_code,
407: 'TRANSFER_JD=P', SR.jurisdiction_code,
408: 'ASSIGNMENT_ID=C' , '-1',
409: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),

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

407: 'TRANSFER_JD=P', SR.jurisdiction_code,
408: 'ASSIGNMENT_ID=C' , '-1',
409: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
410: 'PAYROLL_ACTION_ID=C',
411: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),
412: -- 'TRANSFER_2678_FILER=P', HOI.org_information8,
413: 'BUSINESS_GROUP_ID=C' , PPA.business_group_id,
414: 'TRANSFER_BUSINESS_GROUP_ID=P',PPA.business_group_id,
415: 'TRANSFER_SUI_WAGE_BASE=P', nvl(FFAI.value,' '),

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

412: -- 'TRANSFER_2678_FILER=P', HOI.org_information8,
413: 'BUSINESS_GROUP_ID=C' , PPA.business_group_id,
414: 'TRANSFER_BUSINESS_GROUP_ID=P',PPA.business_group_id,
415: 'TRANSFER_SUI_WAGE_BASE=P', nvl(FFAI.value,' '),
416: 'TRANSFER_REPORT_CATEGORY=P', pay_magtape_generic.get_parameter_value
417: ('TRANSFER_REPORT_CATEGORY')
418: from pay_state_rules SR,
419: ff_archive_items ffai,
420: ff_database_items fdi,

Line 423: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value

419: ff_archive_items ffai,
420: ff_database_items fdi,
421: -- hr_organization_information hoi,
422: pay_payroll_actions ppa
423: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
424: ('TRANSFER_PAYROLL_ACTION_ID')
425: -- and hoi.organization_id = pay_magtape_generic.get_parameter_value
426: -- ('TRANSFER_TRANS_LEGAL_CO_ID')
427: -- and hoi.org_information_context = 'W2 Reporting Rules'

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

421: -- hr_organization_information hoi,
422: pay_payroll_actions ppa
423: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
424: ('TRANSFER_PAYROLL_ACTION_ID')
425: -- and hoi.organization_id = pay_magtape_generic.get_parameter_value
426: -- ('TRANSFER_TRANS_LEGAL_CO_ID')
427: -- and hoi.org_information_context = 'W2 Reporting Rules'
428: and SR.state_code = pay_magtape_generic.get_parameter_value
429: ('TRANSFER_STATE')

Line 428: and SR.state_code = pay_magtape_generic.get_parameter_value

424: ('TRANSFER_PAYROLL_ACTION_ID')
425: -- and hoi.organization_id = pay_magtape_generic.get_parameter_value
426: -- ('TRANSFER_TRANS_LEGAL_CO_ID')
427: -- and hoi.org_information_context = 'W2 Reporting Rules'
428: and SR.state_code = pay_magtape_generic.get_parameter_value
429: ('TRANSFER_STATE')
430: and ffai.user_entity_id = fdi.user_entity_id
431: and fdi.user_name = 'A_SUI_TAXABLE_WAGE_BASE'
432: and ffai.context1 = pay_magtape_generic.get_parameter_value

Line 432: and ffai.context1 = pay_magtape_generic.get_parameter_value

428: and SR.state_code = pay_magtape_generic.get_parameter_value
429: ('TRANSFER_STATE')
430: and ffai.user_entity_id = fdi.user_entity_id
431: and fdi.user_name = 'A_SUI_TAXABLE_WAGE_BASE'
432: and ffai.context1 = pay_magtape_generic.get_parameter_value
433: ('TRANSFER_PAYROLL_ACTION_ID');
434:
435:
436:

Line 447: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value

443: 'TAX_UNIT_NAME=P' , hou.name
444: from hr_all_organization_units hou,
445: pay_assignment_actions AA,
446: pay_payroll_actions PA
447: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value
448: ('TRANSFER_PAYROLL_ACTION_ID')
449: and PA.payroll_action_id = AA.payroll_action_id
450: and AA.tax_unit_id = hou.organization_id
451: order by hou.name;

Line 468: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value

464: from hr_all_organization_units hou,
465: hr_organization_information hoi,
466: pay_assignment_actions AA,
467: pay_payroll_actions PA
468: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value
469: ('TRANSFER_PAYROLL_ACTION_ID')
470: and PA.payroll_action_id = AA.payroll_action_id
471: and AA.tax_unit_id = hou.organization_id
472: and hoi.organization_id = hou.organization_id

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

477: select 'TRANSFER_ASS_ACTION_ID=C', AA.assignment_action_id,
478: 'ASSIGNMENT_ACTION_ID=C' , AA.assignment_action_id,
479: 'ASSIGNMENT_ID=C' , AA.assignment_id,
480: 'ASSIGNMENT_ID=P' , AA.assignment_id, /* Bug 976472 */
481: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned(PA.effective_date, AA.assignment_id))
482: from per_all_people_f PE,
483: per_all_assignments_f SS,
484: pay_assignment_actions AA,
485: pay_payroll_actions PA

Line 486: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value

482: from per_all_people_f PE,
483: per_all_assignments_f SS,
484: pay_assignment_actions AA,
485: pay_payroll_actions PA
486: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
487: ('TRANSFER_PAYROLL_ACTION_ID')
488: and AA.payroll_action_id = PA.payroll_action_id
489: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value
490: ('TAX_UNIT_ID')

Line 489: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value

485: pay_payroll_actions PA
486: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
487: ('TRANSFER_PAYROLL_ACTION_ID')
488: and AA.payroll_action_id = PA.payroll_action_id
489: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value
490: ('TAX_UNIT_ID')
491: and SS.assignment_id = AA.assignment_id
492: and PE.person_id = SS.person_id
493: /* commented for bug 2464463

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

490: ('TAX_UNIT_ID')
491: and SS.assignment_id = AA.assignment_id
492: and PE.person_id = SS.person_id
493: /* commented for bug 2464463
494: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between
495: SS.effective_start_date and SS.effective_end_date
496: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between
497: PE.effective_start_date and PE.effective_end_date
498: */

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

492: and PE.person_id = SS.person_id
493: /* commented for bug 2464463
494: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between
495: SS.effective_start_date and SS.effective_end_date
496: and pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) between
497: PE.effective_start_date and PE.effective_end_date
498: */
499: /* Added for bug 2464463 */
500: AND SS.effective_start_date =

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

516: 'TRANSFER_AMOUNT_WITHHELD_ME=P', hoi.org_information3,
517: 'TRANSFER_PAYMENT_DEPOSITED_ME=P', hoi.org_information4
518: from pay_state_rules SR,
519: hr_organization_information hoi
520: where SR.state_code = pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
521: and hoi.org_information_context = 'SQWL Employer Rules 3'
522: and hoi.organization_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
523: and hoi.org_information1 = pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
524: and to_date(hoi.org_information2,'YYYY/MM/DD HH24:MI:SS') between

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

518: from pay_state_rules SR,
519: hr_organization_information hoi
520: where SR.state_code = pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
521: and hoi.org_information_context = 'SQWL Employer Rules 3'
522: and hoi.organization_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
523: and hoi.org_information1 = pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
524: and to_date(hoi.org_information2,'YYYY/MM/DD HH24:MI:SS') between
525: add_months(last_day(to_date(
526: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER')

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

519: hr_organization_information hoi
520: where SR.state_code = pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
521: and hoi.org_information_context = 'SQWL Employer Rules 3'
522: and hoi.organization_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
523: and hoi.org_information1 = pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
524: and to_date(hoi.org_information2,'YYYY/MM/DD HH24:MI:SS') between
525: add_months(last_day(to_date(
526: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER')
527: ,'MMYYYY')),-3) + 1

Line 526: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER')

522: and hoi.organization_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
523: and hoi.org_information1 = pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
524: and to_date(hoi.org_information2,'YYYY/MM/DD HH24:MI:SS') between
525: add_months(last_day(to_date(
526: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER')
527: ,'MMYYYY')),-3) + 1
528: and last_day(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY')) ;
529:
530: -- ***********SQWL Cursors Ends *************************

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

524: and to_date(hoi.org_information2,'YYYY/MM/DD HH24:MI:SS') between
525: add_months(last_day(to_date(
526: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER')
527: ,'MMYYYY')),-3) + 1
528: and last_day(to_date(pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_QUARTER'),'MMYYYY')) ;
529:
530: -- ***********SQWL Cursors Ends *************************
531:
532: TYPE char240_data_type_table IS TABLE OF VARCHAR2(240)