APPS.PAY_US_W2C_REPORTING_UTILS dependencies on PAY_PAYROLL_ACTIONS

Line 88: pay_payroll_actions PPA

84: 'TRANSFER_COUNTY=P', '-1',
85: 'TRANSFER_2678_FILER=P', HOI.org_information8,
86: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY'
87: FROM hr_organization_information HOI,
88: pay_payroll_actions PPA
89: WHERE HOI.organization_id =
90: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')
91: AND pay_magtape_generic.get_parameter_value('TRANSFER_STATE') = 'FED'
92: AND HOI.org_information_context = 'W2 Reporting Rules'

Line 129: pay_payroll_actions ppa,

125: 'TAX_UNIT_ID=P', paa.tax_unit_id,
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'

Line 164: pay_payroll_actions PA

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
168: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')

Line 177: pay_payroll_actions ppa1

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)
181: ORDER BY PE.last_name, PE.first_name, PE.middle_names;