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_MMREF_LOCAL dependencies on PAY_MAGTAPE_GENERIC

Line 103: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value

99: FROM pay_state_rules SR,
100: hr_organization_information HOI,
101: pay_payroll_actions PPA,
102: pay_payroll_actions PPA1
103: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
104: ('TRANSFER_PAYROLL_ACTION_ID')
105: AND ppa1.effective_date = ppa.effective_date
106: --AND ppa1.report_qualifier = sr.state_code
107: --CPE

Line 110: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')

106: --AND ppa1.report_qualifier = sr.state_code
107: --CPE
108: AND substr(ppa1.report_qualifier,1,2) = sr.state_code
109: AND HOI.organization_id =
110: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')
111: AND SR.state_code =
112: pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
113: AND HOI.org_information_context = 'W2 Reporting Rules'
114: AND PPA.report_type = 'YREND'

Line 112: pay_magtape_generic.get_parameter_value('TRANSFER_STATE')

108: AND substr(ppa1.report_qualifier,1,2) = sr.state_code
109: AND HOI.organization_id =
110: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')
111: AND SR.state_code =
112: pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
113: AND HOI.org_information_context = 'W2 Reporting Rules'
114: AND PPA.report_type = 'YREND'
115: AND HOI.ORGANIZATION_ID =
116: substr(PPA.legislative_parameters,instr(PPA.legislative_parameters,'TRANSFER_GRE=')

Line 119: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')

115: AND HOI.ORGANIZATION_ID =
116: substr(PPA.legislative_parameters,instr(PPA.legislative_parameters,'TRANSFER_GRE=')
117: + length('TRANSFER_GRE='))
118: AND to_char(PPA.effective_date,'YYYY') =
119: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')
120: AND to_char(PPA.effective_date,'DD-MM') = '31-12';
121:
122:
123:

Line 151: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value

147: FROM
148: hr_all_organization_units hou,
149: pay_payroll_actions ppa,
150: pay_assignment_actions AA
151: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
152: ('TRANSFER_PAYROLL_ACTION_ID')
153: AND ppa.report_type = 'YREND'
154: AND to_char(ppa.effective_date,'YYYY') =
155: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')

Line 155: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')

151: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
152: ('TRANSFER_PAYROLL_ACTION_ID')
153: AND ppa.report_type = 'YREND'
154: AND to_char(ppa.effective_date,'YYYY') =
155: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')
156: AND to_char(ppa.effective_date,'DD-MM') = '31-12'
157: AND AA.tax_unit_id =
158: substr(ppa.legislative_parameters,
159: instr(ppa.legislative_parameters,

Line 182: fnd_date.date_to_canonical(pay_magtape_generic.date_earned(PA.effective_date,

178: SELECT
179: 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id, -- YREND assignment action
180: 'ASSIGNMENT_ID=C', AA.assignment_id,
181: 'DATE_EARNED=C',
182: fnd_date.date_to_canonical(pay_magtape_generic.date_earned(PA.effective_date,
183: AA.assignment_id)),
184: 'JURISDICTION_CODE=C',
185: pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
186: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id

Line 185: pay_magtape_generic.get_parameter_value('TRANSFER_JD'),

181: 'DATE_EARNED=C',
182: fnd_date.date_to_canonical(pay_magtape_generic.date_earned(PA.effective_date,
183: AA.assignment_id)),
184: 'JURISDICTION_CODE=C',
185: pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
186: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
187: FROM per_all_people_f PE,
188: per_all_assignments_f SS,
189: pay_action_interlocks AI,

Line 192: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

188: per_all_assignments_f SS,
189: pay_action_interlocks AI,
190: pay_assignment_actions AA,
191: pay_payroll_actions PA
192: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
193: ('TRANSFER_PAYROLL_ACTION_ID') AND
194: AA.payroll_action_id = PA.payroll_action_id AND
195: AA.tax_unit_id = pay_magtape_generic.get_parameter_value
196: ('TAX_UNIT_ID') AND

Line 195: AA.tax_unit_id = pay_magtape_generic.get_parameter_value

191: pay_payroll_actions PA
192: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
193: ('TRANSFER_PAYROLL_ACTION_ID') AND
194: AA.payroll_action_id = PA.payroll_action_id AND
195: AA.tax_unit_id = pay_magtape_generic.get_parameter_value
196: ('TAX_UNIT_ID') AND
197: AI.locking_action_id = AA.assignment_action_id AND
198: SS.assignment_id = AA.assignment_id AND
199: PE.person_id = SS.person_id AND

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

196: ('TAX_UNIT_ID') AND
197: AI.locking_action_id = AA.assignment_action_id AND
198: SS.assignment_id = AA.assignment_id AND
199: PE.person_id = SS.person_id AND
200: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN
201: SS.effective_start_date and SS.effective_end_date AND
202: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN
203: PE.effective_start_date and PE.effective_end_date
204: ORDER BY PE.last_name, PE.first_name, PE.middle_names;

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

198: SS.assignment_id = AA.assignment_id AND
199: PE.person_id = SS.person_id AND
200: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN
201: SS.effective_start_date and SS.effective_end_date AND
202: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN
203: PE.effective_start_date and PE.effective_end_date
204: ORDER BY PE.last_name, PE.first_name, PE.middle_names;
205:
206:

Line 225: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID')

221: pay_payroll_actions ppa,
222: pay_assignment_actions paa
223: where
224: paa.assignment_action_id =
225: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID')
226: and paa.assignment_action_id = fai.context1
227: and fdi.user_name = 'A_CITY_WITHHELD_PER_JD_GRE_YTD'
228: and fdi.user_entity_id = fai.user_entity_id
229: and faic.archive_item_id = fai.archive_item_id

Line 245: pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE')||'%'

241: WHERE rtrim(ltrim(faic.context)) = puctif.jurisdiction_code
242: AND puctif.effective_start_date < ppa.effective_date
243: AND puctif.effective_end_date >= ppa.effective_date
244: AND puctif.city_information1 like
245: pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE')||'%'
246: )
247: order by faic.context ;
248:
249: