[Home] [Help]
97: -- + length('LOCALITY_CODE=')),
98: 'TRANSFER_STATE_CODE=P', substr(sr.jurisdiction_code,1,2)
99: FROM pay_state_rules SR,
100: hr_organization_information HOI,
101: pay_payroll_actions PPA,
102: pay_payroll_actions PPA1
103: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
104: ('TRANSFER_PAYROLL_ACTION_ID')
105: AND ppa1.effective_date = ppa.effective_date
98: 'TRANSFER_STATE_CODE=P', substr(sr.jurisdiction_code,1,2)
99: FROM pay_state_rules SR,
100: hr_organization_information HOI,
101: pay_payroll_actions PPA,
102: pay_payroll_actions PPA1
103: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
104: ('TRANSFER_PAYROLL_ACTION_ID')
105: AND ppa1.effective_date = ppa.effective_date
106: --AND ppa1.report_qualifier = sr.state_code
145: 'TAX_UNIT_NAME=P' , substr(hou.name,1,80),-- Bug# 14286448 Gre length issue
146: 'TRANSFER_EMP_CODE=P', 'R'
147: FROM
148: hr_all_organization_units hou,
149: pay_payroll_actions ppa,
150: pay_assignment_actions AA
151: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
152: ('TRANSFER_PAYROLL_ACTION_ID')
153: AND ppa.report_type = 'YREND'
187: FROM per_all_people_f PE,
188: per_all_assignments_f SS,
189: pay_action_interlocks AI,
190: pay_assignment_actions AA,
191: pay_payroll_actions PA
192: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
193: ('TRANSFER_PAYROLL_ACTION_ID') AND
194: AA.payroll_action_id = PA.payroll_action_id AND
195: AA.tax_unit_id = pay_magtape_generic.get_parameter_value
217: ff_archive_items fai,
218: ff_contexts fc, -- JD
219: ff_database_items fdi,
220: ff_archive_item_contexts faic, -- JD
221: pay_payroll_actions ppa,
222: pay_assignment_actions paa
223: where
224: paa.assignment_action_id =
225: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID')