[Home] [Help]
101: -- by subsequent cursors to restrict to employees within the employer.
102: --
103: /* Context and Parameter in the cursor are
104: Payroll_action_id table looks for value related to Year End pre-processor
105: while the pay_assignment_actions looks for assignment actions of Mag. tapes
106: Context :
107: TAX_UNIT_ID - Submitter's Tax Unit ID
108: JURISDICTION_CODE - Set to Dummy Value as This is federal Cursor
109: ASSIGNMENT_ID - Required for call to function - context not used
124: 'TAX_UNIT_NAME=P', hou.name
125: FROM
126: hr_all_organization_units hou,
127: pay_payroll_actions ppa,
128: pay_assignment_actions paa
129: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value
130: ('TRANSFER_PAYROLL_ACTION_ID')
131: AND ppa.report_type = 'YREND'
132: AND to_char(ppa.effective_date,'YYYY') =
157: 'TRANSFER_NEW_ASG_ACTID=P', to_number(substr(AA.serial_number,1,15)), -- Corrected Assignment Action Id
158: 'TRANSFER_TAX_UNIT_ID=P', AA.tax_unit_id
159: FROM per_all_people_f PE,
160: per_all_assignments_f SS,
161: pay_assignment_actions AA,
162: pay_payroll_actions PA
163: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
164: ('TRANSFER_PAYROLL_ACTION_ID')
165: AND AA.payroll_action_id = PA.payroll_action_id
170: BETWEEN SS.effective_start_date and SS.effective_end_date
171: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
172: BETWEEN PE.effective_start_date and PE.effective_end_date
173: AND exists (select 'x' from pay_action_interlocks pai,
174: pay_assignment_actions paa1,
175: pay_payroll_actions ppa1
176: where paa1.assignment_action_id = AA.assignment_action_id
177: and paa1.assignment_action_id = pai.locking_action_id
178: and ppa1.payroll_action_id = paa1.payroll_action_id)