APPS.PAY_US_MMREF_REPORTING_MT dependencies on PAY_PAYROLL_ACTIONS

Line 59: pay_payroll_actions PPA,

55: 'BUSINESS_GROUP_ID=C',PPA.business_group_id,
56: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY'
57: FROM pay_state_rules SR,
58: hr_organization_information HOI,
59: pay_payroll_actions PPA,
60: pay_payroll_actions PPA1
61: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
62: ('TRANSFER_PAYROLL_ACTION_ID')
63: AND ppa1.effective_date = ppa.effective_date

Line 60: pay_payroll_actions PPA1

56: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY'
57: FROM pay_state_rules SR,
58: hr_organization_information HOI,
59: pay_payroll_actions PPA,
60: pay_payroll_actions PPA1
61: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
62: ('TRANSFER_PAYROLL_ACTION_ID')
63: AND ppa1.effective_date = ppa.effective_date
64: AND ppa1.report_qualifier = sr.state_code

Line 110: pay_payroll_actions PPA

106: 'TRANSFER_2678_FILER=P', HOI.org_information8,
107: 'PAYROLL_ACTION_ID=C',ppa.payroll_action_id, -- payroll_action_id of YREND
108: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY'
109: FROM hr_organization_information HOI,
110: pay_payroll_actions PPA
111: WHERE HOI.organization_id =
112: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')
113: AND pay_magtape_generic.get_parameter_value('TRANSFER_STATE') = 'FED'
114: AND HOI.org_information_context = 'W2 Reporting Rules'

Line 155: pay_payroll_actions ppa,

151: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
152: 'TAX_UNIT_NAME=P' , hou.name,
153: 'TRANSFER_EMP_CODE=P', 'R'
154: FROM hr_all_organization_units hou,
155: pay_payroll_actions ppa,
156: pay_assignment_actions AA
157: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
158: ('TRANSFER_PAYROLL_ACTION_ID')
159: AND ppa.report_type = 'YREND'

Line 179: pay_payroll_actions ppa,

175: 'TAX_UNIT_NAME=P' , hou.name,
176: 'TRANSFER_EMP_CODE=P', 'R',
177: 'TRANSFER_TAX_UNIT_ID=P', AA.tax_unit_id
178: FROM hr_all_organization_units hou,
179: pay_payroll_actions ppa,
180: pay_assignment_actions AA
181: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
182: ('TRANSFER_PAYROLL_ACTION_ID')
183: AND ppa.report_type = 'YREND'

Line 204: pay_payroll_actions ppa,

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

Line 226: pay_payroll_actions ppa,

222: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
223: 'TAX_UNIT_NAME=P', hou.name,
224: 'TRANSFER_EMP_CODE=P' , 'Q'
225: FROM hr_all_organization_units hou,
226: pay_payroll_actions ppa,
227: pay_assignment_actions AA
228: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
229: ('TRANSFER_PAYROLL_ACTION_ID')
230: AND ppa.report_type = 'YREND'

Line 276: pay_payroll_actions PA

272: FROM per_all_people_f PE,
273: per_all_assignments_f SS,
274: pay_action_interlocks AI,
275: pay_assignment_actions AA,
276: pay_payroll_actions PA
277: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
278: ('TRANSFER_PAYROLL_ACTION_ID')
279: AND AA.payroll_action_id = PA.payroll_action_id
280: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value

Line 309: pay_payroll_actions PA,

305: per_all_assignments_f SS,
306: pay_action_interlocks AI,
307: pay_assignment_actions AA,
308: pay_assignment_actions paa,
309: pay_payroll_actions PA,
310: ff_archive_items arch,
311: ff_user_entities fue
312: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
313: ('TRANSFER_PAYROLL_ACTION_ID')

Line 356: pay_payroll_actions PA

352: FROM per_all_people_f PE,
353: per_all_assignments_f SS,
354: pay_action_interlocks AI,
355: pay_assignment_actions AA,
356: pay_payroll_actions PA
357: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
358: ('TRANSFER_PAYROLL_ACTION_ID')
359: AND AA.payroll_action_id = PA.payroll_action_id
360: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value

Line 445: pay_payroll_actions PA

441: FROM per_all_people_f PE,
442: per_all_assignments_f SS,
443: pay_action_interlocks AI,
444: pay_assignment_actions AA,
445: pay_payroll_actions PA
446: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
447: ('TRANSFER_PAYROLL_ACTION_ID')
448: AND aa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
449: AND AA.payroll_action_id = PA.payroll_action_id