[Home] [Help]
97: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(PA.effective_date),
98: 'BUSINESS_GROUP_ID=C', PA.business_group_id,
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
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,
136: hr_organization_information hoi
137: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value
138: ('TRANSFER_PAYROLL_ACTION_ID')
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,
149: ff_user_entities fue
150: WHERE fai.context1 = paa.assignment_action_id
151: AND paa.payroll_action_id = AA.payroll_action_id
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,
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
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,
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
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,
282: per_all_people_f PE,
283: ff_archive_items fai,
284: ff_user_entities fue
415: */
416: select distinct 'JURISDICTION_CODE=C', context
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')
478: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
479: 'DATE_EARNED=C' , fnd_date.date_to_canonical(PA.effective_date),
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
501: 'TAX_UNIT_NAME=P' , hou.name,
502: 'FEIN=P' , hoi.org_information1
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
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
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