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