eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_W2C_REPORTING_UTILS dependencies on PAY_MAGTAPE_GENERIC

Line 88: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')

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'
91: AND PPA.report_type = 'YREND'
92: AND HOI.ORGANIZATION_ID =

Line 89: AND pay_magtape_generic.get_parameter_value('TRANSFER_STATE') = 'FED'

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'
91: AND PPA.report_type = 'YREND'
92: AND HOI.ORGANIZATION_ID =
93: substr(PPA.legislative_parameters,instr(PPA.legislative_parameters,'TRANSFER_GRE=') + length('TRANSFER_GRE='))

Line 95: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')

91: AND PPA.report_type = 'YREND'
92: AND HOI.ORGANIZATION_ID =
93: substr(PPA.legislative_parameters,instr(PPA.legislative_parameters,'TRANSFER_GRE=') + length('TRANSFER_GRE='))
94: AND to_char(PPA.effective_date,'YYYY') =
95: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')
96: AND to_char(PPA.effective_date,'DD-MM') = '31-12';
97:
98: --
99: -- Sets up the tax unit context for each employer to be reported on W-2c Mag.

Line 129: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value

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'
132: AND to_char(ppa.effective_date,'YYYY') =
133: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')

Line 133: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')

129: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value
130: ('TRANSFER_PAYROLL_ACTION_ID')
131: AND ppa.report_type = 'YREND'
132: AND to_char(ppa.effective_date,'YYYY') =
133: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')
134: AND to_char(ppa.effective_date,'DD-MM') = '31-12'
135: AND paa.tax_unit_id =
136: substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'TRANSFER_GRE=') + length('TRANSFER_GRE='))
137: AND hou.organization_id = paa.tax_unit_id

Line 154: pay_magtape_generic.date_earned(PA.effective_date, AA.assignment_id)),

150: CURSOR w2c_mmrf2_employee IS
151: SELECT 'ASSIGNMENT_ACTION_ID=C', to_number(substr(AA.serial_number,1,15)), -- latest W2c Pre-Process Assignment Action Id
152: 'ASSIGNMENT_ID=C', AA.assignment_id,
153: 'DATE_EARNED=C', fnd_date.date_to_canonical(
154: pay_magtape_generic.date_earned(PA.effective_date, AA.assignment_id)),
155: 'JURISDICTION_CODE=C', pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
156: 'TRANSFER_OLD_ASG_ACTID=P', to_number(substr(AA.serial_number,16,15)), -- Originally Reported Assignment Action Id
157: 'TRANSFER_NEW_ASG_ACTID=P', to_number(substr(AA.serial_number,1,15)), -- Corrected Assignment Action Id
158: 'TRANSFER_TAX_UNIT_ID=P', AA.tax_unit_id

Line 155: 'JURISDICTION_CODE=C', pay_magtape_generic.get_parameter_value('TRANSFER_JD'),

151: SELECT 'ASSIGNMENT_ACTION_ID=C', to_number(substr(AA.serial_number,1,15)), -- latest W2c Pre-Process Assignment Action Id
152: 'ASSIGNMENT_ID=C', AA.assignment_id,
153: 'DATE_EARNED=C', fnd_date.date_to_canonical(
154: pay_magtape_generic.date_earned(PA.effective_date, AA.assignment_id)),
155: 'JURISDICTION_CODE=C', pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
156: 'TRANSFER_OLD_ASG_ACTID=P', to_number(substr(AA.serial_number,16,15)), -- Originally Reported Assignment Action Id
157: 'TRANSFER_NEW_ASG_ACTID=P', to_number(substr(AA.serial_number,1,15)), -- Corrected Assignment Action Id
158: 'TRANSFER_TAX_UNIT_ID=P', AA.tax_unit_id
159: FROM per_all_people_f PE,

Line 163: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

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')
167: AND SS.assignment_id = AA.assignment_id

Line 166: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')

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')
167: AND SS.assignment_id = AA.assignment_id
168: AND PE.person_id = SS.person_id
169: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
170: BETWEEN SS.effective_start_date and SS.effective_end_date

Line 169: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_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')
167: AND SS.assignment_id = AA.assignment_id
168: AND PE.person_id = SS.person_id
169: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
170: BETWEEN SS.effective_start_date and SS.effective_end_date
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,

Line 171: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)

167: AND SS.assignment_id = AA.assignment_id
168: AND PE.person_id = SS.person_id
169: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
170: BETWEEN SS.effective_start_date and SS.effective_end_date
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