APPS.PAY_US_MMREF_REPORTING dependencies on PAY_PAYROLL_ACTIONS

Line 109: pay_payroll_actions PPA,

105: 'BUSINESS_GROUP_ID=C',PPA.business_group_id,
106: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY'
107: FROM pay_state_rules SR,
108: hr_organization_information HOI,
109: pay_payroll_actions PPA,
110: pay_payroll_actions PPA1
111: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
112: ('TRANSFER_PAYROLL_ACTION_ID')
113: AND ppa1.effective_date = ppa.effective_date

Line 110: pay_payroll_actions PPA1

106: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY'
107: FROM pay_state_rules SR,
108: hr_organization_information HOI,
109: pay_payroll_actions PPA,
110: pay_payroll_actions PPA1
111: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
112: ('TRANSFER_PAYROLL_ACTION_ID')
113: AND ppa1.effective_date = ppa.effective_date
114: AND ppa1.report_qualifier = sr.state_code

Line 160: pay_payroll_actions PPA

156: 'TRANSFER_2678_FILER=P', HOI.org_information8,
157: 'PAYROLL_ACTION_ID=C',ppa.payroll_action_id, -- payroll_action_id of YREND
158: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY'
159: FROM hr_organization_information HOI,
160: pay_payroll_actions PPA
161: WHERE HOI.organization_id =
162: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')
163: AND pay_magtape_generic.get_parameter_value('TRANSFER_STATE') = 'FED'
164: AND HOI.org_information_context = 'W2 Reporting Rules'

Line 205: pay_payroll_actions ppa,

201: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
202: 'TAX_UNIT_NAME=P' , hou.name,
203: 'TRANSFER_EMP_CODE=P', 'R'
204: FROM hr_all_organization_units hou,
205: pay_payroll_actions ppa,
206: pay_assignment_actions AA
207: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
208: ('TRANSFER_PAYROLL_ACTION_ID')
209: AND ppa.report_type = 'YREND'

Line 230: pay_payroll_actions ppa,

226: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
227: 'TAX_UNIT_NAME=P', hou.name,
228: 'TRANSFER_EMP_CODE=P' , 'R'
229: FROM hr_all_organization_units hou,
230: pay_payroll_actions ppa,
231: pay_assignment_actions AA
232: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
233: ('TRANSFER_PAYROLL_ACTION_ID')
234: AND ppa.report_type = 'YREND'

Line 252: pay_payroll_actions ppa,

248: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
249: 'TAX_UNIT_NAME=P', hou.name,
250: 'TRANSFER_EMP_CODE=P' , 'Q'
251: FROM hr_all_organization_units hou,
252: pay_payroll_actions ppa,
253: pay_assignment_actions AA
254: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
255: ('TRANSFER_PAYROLL_ACTION_ID')
256: AND ppa.report_type = 'YREND'

Line 282: FROM pay_payroll_actions PA,

278: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
279: (PA.effective_date, AA.assignment_id)),
280: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
281: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
282: FROM pay_payroll_actions PA,
283: pay_assignment_actions AA,
284: pay_action_interlocks AI,
285: per_all_assignments_f SS,
286: per_all_people_f PE

Line 320: pay_payroll_actions PA,

316: per_all_assignments_f SS,
317: pay_action_interlocks AI,
318: pay_assignment_actions AA,
319: pay_assignment_actions paa,
320: pay_payroll_actions PA,
321: ff_archive_items arch,
322: ff_user_entities fue
323: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
324: ('TRANSFER_PAYROLL_ACTION_ID')

Line 367: pay_payroll_actions PA

363: FROM per_all_people_f PE,
364: per_all_assignments_f SS,
365: pay_action_interlocks AI,
366: pay_assignment_actions AA,
367: pay_payroll_actions PA
368: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
369: ('TRANSFER_PAYROLL_ACTION_ID')
370: AND AA.payroll_action_id = PA.payroll_action_id
371: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value