APPS.PAY_US_W2C_REPORTING_UTILS dependencies on PAY_PAYROLL_ACTIONS

Line 86: pay_payroll_actions PPA

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

Line 127: pay_payroll_actions ppa,

123: 'TAX_UNIT_ID=P', paa.tax_unit_id,
124: 'TAX_UNIT_NAME=P', hou.name
125: FROM
126: hr_all_organization_units hou,
127: pay_payroll_actions ppa,
128: pay_assignment_actions paa
129: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value
130: ('TRANSFER_PAYROLL_ACTION_ID')
131: AND ppa.report_type = 'YREND'

Line 162: pay_payroll_actions PA

158: 'TRANSFER_TAX_UNIT_ID=P', AA.tax_unit_id
159: FROM per_all_people_f PE,
160: per_all_assignments_f SS,
161: pay_assignment_actions AA,
162: pay_payroll_actions PA
163: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
164: ('TRANSFER_PAYROLL_ACTION_ID')
165: AND AA.payroll_action_id = PA.payroll_action_id
166: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')

Line 175: pay_payroll_actions ppa1

171: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
172: BETWEEN PE.effective_start_date and PE.effective_end_date
173: AND exists (select 'x' from pay_action_interlocks pai,
174: pay_assignment_actions paa1,
175: pay_payroll_actions ppa1
176: where paa1.assignment_action_id = AA.assignment_action_id
177: and paa1.assignment_action_id = pai.locking_action_id
178: and ppa1.payroll_action_id = paa1.payroll_action_id)
179: ORDER BY PE.last_name, PE.first_name, PE.middle_names;