APPS.PAY_US_MMREF_REPORTING dependencies on PAY_PAYROLL_ACTIONS

Line 116: pay_payroll_actions PPA,

112: 'BUSINESS_GROUP_ID=C',PPA.business_group_id,
113: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY'
114: FROM pay_state_rules SR,
115: hr_organization_information HOI,
116: pay_payroll_actions PPA,
117: pay_payroll_actions PPA1
118: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
119: ('TRANSFER_PAYROLL_ACTION_ID')
120: AND ppa1.effective_date = ppa.effective_date

Line 117: pay_payroll_actions PPA1

113: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY'
114: FROM pay_state_rules SR,
115: hr_organization_information HOI,
116: pay_payroll_actions PPA,
117: pay_payroll_actions PPA1
118: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
119: ('TRANSFER_PAYROLL_ACTION_ID')
120: AND ppa1.effective_date = ppa.effective_date
121: AND ppa1.report_qualifier = sr.state_code

Line 167: pay_payroll_actions PPA

163: 'TRANSFER_2678_FILER=P', HOI.org_information8,
164: 'PAYROLL_ACTION_ID=C',ppa.payroll_action_id, -- payroll_action_id of YREND
165: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY'
166: FROM hr_organization_information HOI,
167: pay_payroll_actions PPA
168: WHERE HOI.organization_id =
169: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')
170: AND pay_magtape_generic.get_parameter_value('TRANSFER_STATE') = 'FED'
171: AND HOI.org_information_context = 'W2 Reporting Rules'

Line 212: pay_payroll_actions ppa,

208: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
209: 'TAX_UNIT_NAME=P' , substr(hou.name,1,80), -- Bug# 14286448 Gre length issue
210: 'TRANSFER_EMP_CODE=P', 'R'
211: FROM hr_all_organization_units hou,
212: pay_payroll_actions ppa,
213: pay_assignment_actions AA
214: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
215: ('TRANSFER_PAYROLL_ACTION_ID')
216: AND ppa.report_type = 'YREND'

Line 237: pay_payroll_actions ppa,

233: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
234: 'TAX_UNIT_NAME=P', substr(hou.name,1,80), -- Bug# 14286448 Gre length issue
235: 'TRANSFER_EMP_CODE=P' , 'R'
236: FROM hr_all_organization_units hou,
237: pay_payroll_actions ppa,
238: pay_assignment_actions AA
239: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
240: ('TRANSFER_PAYROLL_ACTION_ID')
241: AND ppa.report_type = 'YREND'

Line 259: pay_payroll_actions ppa,

255: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
256: 'TAX_UNIT_NAME=P', substr(hou.name,1,80), -- Bug# 14286448 Gre length issue
257: 'TRANSFER_EMP_CODE=P' , 'Q'
258: FROM hr_all_organization_units hou,
259: pay_payroll_actions ppa,
260: pay_assignment_actions AA
261: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
262: ('TRANSFER_PAYROLL_ACTION_ID')
263: AND ppa.report_type = 'YREND'

Line 292: FROM pay_payroll_actions PA,

288: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
289: (PA.effective_date, AA.assignment_id)),
290: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
291: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
292: FROM pay_payroll_actions PA,
293: pay_assignment_actions AA,
294: pay_action_interlocks AI,
295: per_all_assignments_f SS,
296: per_all_people_f PE

Line 330: pay_payroll_actions PA,

326: per_all_assignments_f SS,
327: pay_action_interlocks AI,
328: pay_assignment_actions AA,
329: pay_assignment_actions paa,
330: pay_payroll_actions PA,
331: ff_archive_items arch,
332: ff_user_entities fue
333: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
334: ('TRANSFER_PAYROLL_ACTION_ID')

Line 377: pay_payroll_actions PA

373: FROM per_all_people_f PE,
374: per_all_assignments_f SS,
375: pay_action_interlocks AI,
376: pay_assignment_actions AA,
377: pay_payroll_actions PA
378: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
379: ('TRANSFER_PAYROLL_ACTION_ID')
380: AND AA.payroll_action_id = PA.payroll_action_id
381: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value