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

Line 83: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value

79: FROM pay_state_rules SR,
80: hr_organization_information HOI,
81: pay_payroll_actions PPA,
82: pay_payroll_actions PPA1
83: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
84: ('TRANSFER_PAYROLL_ACTION_ID')
85: AND ppa1.effective_date = ppa.effective_date
86: AND ppa1.report_qualifier = 'LOCAL'
87: AND HOI.organization_id =

Line 88: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')

84: ('TRANSFER_PAYROLL_ACTION_ID')
85: AND ppa1.effective_date = ppa.effective_date
86: AND ppa1.report_qualifier = 'LOCAL'
87: AND HOI.organization_id =
88: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')
89: AND SR.state_code =
90: pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
91: AND HOI.org_information_context = 'W2 Reporting Rules'
92: AND PPA.report_type = 'YREND'

Line 90: pay_magtape_generic.get_parameter_value('TRANSFER_STATE')

86: AND ppa1.report_qualifier = 'LOCAL'
87: AND HOI.organization_id =
88: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')
89: AND SR.state_code =
90: pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
91: AND HOI.org_information_context = 'W2 Reporting Rules'
92: AND PPA.report_type = 'YREND'
93: AND HOI.ORGANIZATION_ID =
94: substr(PPA.legislative_parameters,instr(PPA.legislative_parameters,'TRANSFER_GRE=')

Line 97: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')

93: AND HOI.ORGANIZATION_ID =
94: substr(PPA.legislative_parameters,instr(PPA.legislative_parameters,'TRANSFER_GRE=')
95: + length('TRANSFER_GRE='))
96: AND to_char(PPA.effective_date,'YYYY') =
97: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')
98: AND to_char(PPA.effective_date,'DD-MM') = '31-12';
99:
100: /* Context and Parameter Set in the cursor are
101: Parameters :

Line 117: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value

113: 'TAX_UNIT_NAME=P', hou.name
114: FROM hr_all_organization_units hou,
115: pay_payroll_actions ppa,
116: pay_assignment_actions aa
117: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value
118: ('TRANSFER_PAYROLL_ACTION_ID')
119: AND ppa.report_type = 'YREND'
120: AND to_char(ppa.effective_date, 'YYYY') =
121: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')

Line 121: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')

117: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value
118: ('TRANSFER_PAYROLL_ACTION_ID')
119: AND ppa.report_type = 'YREND'
120: AND to_char(ppa.effective_date, 'YYYY') =
121: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')
122: AND to_char(ppa.effective_date,'DD-MM') = '31-12'
123: AND aa.tax_unit_id = substr(ppa.legislative_parameters,
124: instr(ppa.legislative_parameters,
125: 'TRANSFER_GRE=') + length('TRANSFER_GRE='))

Line 150: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

146: pay_action_interlocks AI,
147: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions
148: pay_assignment_actions AA,
149: pay_payroll_actions PA
150: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
151: ('TRANSFER_PAYROLL_ACTION_ID')
152: AND AA.payroll_action_id = PA.payroll_action_id
153: AND AI.locking_action_id = AA.assignment_action_id
154: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value

Line 154: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value

150: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
151: ('TRANSFER_PAYROLL_ACTION_ID')
152: AND AA.payroll_action_id = PA.payroll_action_id
153: AND AI.locking_action_id = AA.assignment_action_id
154: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value
155: ('TAX_UNIT_ID')
156: AND SS.assignment_id = AA.assignment_id
157: AND PE.person_id = SS.person_id
158: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)

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

154: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value
155: ('TAX_UNIT_ID')
156: AND SS.assignment_id = AA.assignment_id
157: AND PE.person_id = SS.person_id
158: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
159: BETWEEN SS.effective_start_date and SS.effective_end_date
160: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
161: BETWEEN PE.effective_start_date and PE.effective_end_date
162: AND AI.locked_action_id = fai.context1

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

156: AND SS.assignment_id = AA.assignment_id
157: AND PE.person_id = SS.person_id
158: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
159: BETWEEN SS.effective_start_date and SS.effective_end_date
160: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
161: BETWEEN PE.effective_start_date and PE.effective_end_date
162: AND AI.locked_action_id = fai.context1
163: AND AI.locked_action_id = AA1.assignment_action_id
164: AND fdi.user_name = 'A_CITY_WITHHELD_PER_JD_GRE_YTD'

Line 170: pay_magtape_generic.get_parameter_value('TRANSFER_STATE_CODE')

166: AND faic.archive_item_id = fai.archive_item_id
167: AND fc.context_name = 'JURISDICTION_CODE'
168: AND faic.context_id = fc.context_id
169: AND substr(rtrim(ltrim(faic.context)),1,2) =
170: pay_magtape_generic.get_parameter_value('TRANSFER_STATE_CODE')
171: AND value <> '0'
172: AND ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') = 'NULL'
173: OR
174: ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') <> 'NULL'

Line 172: AND ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') = 'NULL'

168: AND faic.context_id = fc.context_id
169: AND substr(rtrim(ltrim(faic.context)),1,2) =
170: pay_magtape_generic.get_parameter_value('TRANSFER_STATE_CODE')
171: AND value <> '0'
172: AND ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') = 'NULL'
173: OR
174: ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') <> 'NULL'
175: AND EXISTS
176: ( SELECT '1'

Line 174: ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') <> 'NULL'

170: pay_magtape_generic.get_parameter_value('TRANSFER_STATE_CODE')
171: AND value <> '0'
172: AND ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') = 'NULL'
173: OR
174: ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') <> 'NULL'
175: AND EXISTS
176: ( SELECT '1'
177: FROM pay_us_city_tax_info_f puctif
178: WHERE substr(rtrim(ltrim(faic.context)),1,2)||'-000-'||substr(rtrim(ltrim(faic.context)),8,4) =

Line 183: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),1,2) ||'-000-'||

179: substr(puctif.jurisdiction_code,1,2)||'-000-'||substr(puctif.jurisdiction_code,8,4)
180: AND puctif.effective_start_date < PA.effective_date
181: AND puctif.effective_end_date >= PA.effective_date
182: AND substr(puctif.jurisdiction_code,1,2)||'-000-'||substr(puctif.jurisdiction_code,8,4) =
183: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),1,2) ||'-000-'||
184: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),8,11)
185: )
186: )
187: );

Line 184: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),8,11)

180: AND puctif.effective_start_date < PA.effective_date
181: AND puctif.effective_end_date >= PA.effective_date
182: AND substr(puctif.jurisdiction_code,1,2)||'-000-'||substr(puctif.jurisdiction_code,8,4) =
183: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),1,2) ||'-000-'||
184: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),8,11)
185: )
186: )
187: );
188:

Line 196: 'EE_DATE_EARNED=P', pay_magtape_generic.date_earned(PA.effective_date,

192: 'TRANSFER_ACT_ID=P', AA.assignment_action_id,
193: 'YE_ASSIGNMENT_ACTION_ID=P', AA1.assignment_action_id, -- YREND assignment action
194: 'YE_TAX_UNIT_ID=P', AA1.TAX_UNIT_ID,
195: 'EE_ASSIGNMENT_ID=P', AA.assignment_id,
196: 'EE_DATE_EARNED=P', pay_magtape_generic.date_earned(PA.effective_date,
197: AA.assignment_id),
198: 'EE_LOCALITY_JD_CODE=P', substr(ltrim(rtrim(faic.context)),1,2)||'-000-'||substr(ltrim(rtrim(faic.context)),8,4)
199: FROM ff_archive_items FAI,
200: ff_contexts FC, -- JD

Line 209: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

205: pay_action_interlocks AI,
206: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions
207: pay_assignment_actions AA,
208: pay_payroll_actions PA
209: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
210: ('TRANSFER_PAYROLL_ACTION_ID')
211: AND AA.payroll_action_id = PA.payroll_action_id
212: AND AI.locking_action_id = AA.assignment_action_id
213: AND SS.assignment_id = AA.assignment_id

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

211: AND AA.payroll_action_id = PA.payroll_action_id
212: AND AI.locking_action_id = AA.assignment_action_id
213: AND SS.assignment_id = AA.assignment_id
214: AND PE.person_id = SS.person_id
215: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
216: BETWEEN SS.effective_start_date and SS.effective_end_date
217: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
218: BETWEEN PE.effective_start_date and PE.effective_end_date
219: AND AI.locked_action_id = fai.context1

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

213: AND SS.assignment_id = AA.assignment_id
214: AND PE.person_id = SS.person_id
215: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
216: BETWEEN SS.effective_start_date and SS.effective_end_date
217: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
218: BETWEEN PE.effective_start_date and PE.effective_end_date
219: AND AI.locked_action_id = fai.context1
220: AND AI.locked_action_id = AA1.assignment_action_id
221: AND fdi.user_name = 'A_CITY_WITHHELD_PER_JD_GRE_YTD'

Line 227: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),1,2)

223: AND faic.archive_item_id = fai.archive_item_id
224: AND fc.context_name = 'JURISDICTION_CODE'
225: AND faic.context_id = fc.context_id
226: AND substr(rtrim(ltrim(faic.context)),1,2) =
227: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),1,2)
228: AND value <> '0'
229: AND ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') IS NULL
230: OR ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') IS NOT NULL
231: AND EXISTS

Line 229: AND ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') IS NULL

225: AND faic.context_id = fc.context_id
226: AND substr(rtrim(ltrim(faic.context)),1,2) =
227: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),1,2)
228: AND value <> '0'
229: AND ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') IS NULL
230: OR ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') IS NOT NULL
231: AND EXISTS
232: ( SELECT '1'
233: FROM pay_us_city_tax_info_f puctif

Line 230: OR ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') IS NOT NULL

226: AND substr(rtrim(ltrim(faic.context)),1,2) =
227: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),1,2)
228: AND value <> '0'
229: AND ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') IS NULL
230: OR ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') IS NOT NULL
231: AND EXISTS
232: ( SELECT '1'
233: FROM pay_us_city_tax_info_f puctif
234: WHERE substr(rtrim(ltrim(faic.context)),1,2)||'-000-'||substr(rtrim(ltrim(faic.context)),8,4) =

Line 239: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),1,2) ||'-000-'||

235: substr(puctif.jurisdiction_code,1,2)||'-000-'||substr(puctif.jurisdiction_code,8,4)
236: AND puctif.effective_start_date < PA.effective_date
237: AND puctif.effective_end_date >= PA.effective_date
238: AND substr(puctif.jurisdiction_code,1,2)||'-000-'||substr(puctif.jurisdiction_code,8,4) =
239: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),1,2) ||'-000-'||
240: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),8,11)
241: )
242: )
243: );

Line 240: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),8,11)

236: AND puctif.effective_start_date < PA.effective_date
237: AND puctif.effective_end_date >= PA.effective_date
238: AND substr(puctif.jurisdiction_code,1,2)||'-000-'||substr(puctif.jurisdiction_code,8,4) =
239: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),1,2) ||'-000-'||
240: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),8,11)
241: )
242: )
243: );
244: */

Line 248: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

244: */
245:
246: CURSOR local_w2_xml_curr_act_id IS
247: SELECT 'TRANSFER_ACT_ID=P',
248: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
249: FROM DUAL;
250:
251: CURSOR GET_XML_VER IS
252: SELECT 'ROOT_XML_TAG=P',

Line 255: pay_magtape_generic.get_parameter_value(

251: CURSOR GET_XML_VER IS
252: SELECT 'ROOT_XML_TAG=P',
253: '',
254: 'PAYROLL_ACTION_ID=P',
255: pay_magtape_generic.get_parameter_value(
256: 'TRANSFER_PAYROLL_ACTION_ID')
257: FROM dual;
258:
259: FUNCTION bal_db_item

Line 304: pay_magtape_generic.get_parameter_value( 'TRANSFER_ACT_ID' )

300: p_chunk IN NUMBER );
301:
302: CURSOR LOCAL_CURR_ACT_ID IS
303: SELECT 'TRANSFER_ACT_ID=P',
304: pay_magtape_generic.get_parameter_value( 'TRANSFER_ACT_ID' )
305: FROM DUAL;
306:
307: CURSOR LOCAL_MAG_ASG_ACT IS
308: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id

Line 310: WHERE payroll_action_id = pay_magtape_generic.get_parameter_value(

306:
307: CURSOR LOCAL_MAG_ASG_ACT IS
308: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
309: FROM pay_assignment_actions paa
310: WHERE payroll_action_id = pay_magtape_generic.get_parameter_value(
311: 'TRANSFER_PAYROLL_ACTION_ID');
312: --
313: -- Follwing Procedures are used for constructing XML for Submitter or RA Record
314: --