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 88: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value

84: FROM pay_state_rules SR,
85: hr_organization_information HOI,
86: pay_payroll_actions PPA,
87: pay_payroll_actions PPA1
88: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
89: ('TRANSFER_PAYROLL_ACTION_ID')
90: AND ppa1.effective_date = ppa.effective_date
91: AND ppa1.report_qualifier = 'LOCAL'
92: AND HOI.organization_id =

Line 93: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')

89: ('TRANSFER_PAYROLL_ACTION_ID')
90: AND ppa1.effective_date = ppa.effective_date
91: AND ppa1.report_qualifier = 'LOCAL'
92: AND HOI.organization_id =
93: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')
94: AND SR.state_code =
95: pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
96: AND HOI.org_information_context = 'W2 Reporting Rules'
97: AND PPA.report_type = 'YREND'

Line 95: pay_magtape_generic.get_parameter_value('TRANSFER_STATE')

91: AND ppa1.report_qualifier = 'LOCAL'
92: AND HOI.organization_id =
93: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')
94: AND SR.state_code =
95: pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
96: AND HOI.org_information_context = 'W2 Reporting Rules'
97: AND PPA.report_type = 'YREND'
98: AND HOI.ORGANIZATION_ID =
99: substr(PPA.legislative_parameters,instr(PPA.legislative_parameters,'TRANSFER_GRE=')

Line 102: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')

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

Line 122: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value

118: 'TAX_UNIT_NAME=P', substr(hou.name,1,80) -- Bug# 14286448 Gre length issue
119: FROM hr_all_organization_units hou,
120: pay_payroll_actions ppa,
121: pay_assignment_actions aa
122: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value
123: ('TRANSFER_PAYROLL_ACTION_ID')
124: AND ppa.report_type = 'YREND'
125: AND to_char(ppa.effective_date, 'YYYY') =
126: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')

Line 126: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')

122: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value
123: ('TRANSFER_PAYROLL_ACTION_ID')
124: AND ppa.report_type = 'YREND'
125: AND to_char(ppa.effective_date, 'YYYY') =
126: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')
127: AND to_char(ppa.effective_date,'DD-MM') = '31-12'
128: AND aa.tax_unit_id = substr(ppa.legislative_parameters,
129: instr(ppa.legislative_parameters,
130: 'TRANSFER_GRE=') + length('TRANSFER_GRE='))

Line 155: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

151: pay_action_interlocks AI,
152: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions
153: pay_assignment_actions AA,
154: pay_payroll_actions PA
155: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
156: ('TRANSFER_PAYROLL_ACTION_ID')
157: AND AA.payroll_action_id = PA.payroll_action_id
158: AND AI.locking_action_id = AA.assignment_action_id
159: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value

Line 159: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value

155: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
156: ('TRANSFER_PAYROLL_ACTION_ID')
157: AND AA.payroll_action_id = PA.payroll_action_id
158: AND AI.locking_action_id = AA.assignment_action_id
159: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value
160: ('TAX_UNIT_ID')
161: AND SS.assignment_id = AA.assignment_id
162: AND PE.person_id = SS.person_id
163: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)

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

159: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value
160: ('TAX_UNIT_ID')
161: AND SS.assignment_id = AA.assignment_id
162: AND PE.person_id = SS.person_id
163: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
164: BETWEEN SS.effective_start_date and SS.effective_end_date
165: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
166: BETWEEN PE.effective_start_date and PE.effective_end_date
167: AND AI.locked_action_id = fai.context1

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

161: AND SS.assignment_id = AA.assignment_id
162: AND PE.person_id = SS.person_id
163: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
164: BETWEEN SS.effective_start_date and SS.effective_end_date
165: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
166: BETWEEN PE.effective_start_date and PE.effective_end_date
167: AND AI.locked_action_id = fai.context1
168: AND AI.locked_action_id = AA1.assignment_action_id
169: AND fdi.user_name = 'A_CITY_WITHHELD_PER_JD_GRE_YTD'

Line 175: pay_magtape_generic.get_parameter_value('TRANSFER_STATE_CODE')

171: AND faic.archive_item_id = fai.archive_item_id
172: AND fc.context_name = 'JURISDICTION_CODE'
173: AND faic.context_id = fc.context_id
174: AND substr(rtrim(ltrim(faic.context)),1,2) =
175: pay_magtape_generic.get_parameter_value('TRANSFER_STATE_CODE')
176: AND value <> '0'
177: AND ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') = 'NULL'
178: OR
179: ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') <> 'NULL'

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

173: AND faic.context_id = fc.context_id
174: AND substr(rtrim(ltrim(faic.context)),1,2) =
175: pay_magtape_generic.get_parameter_value('TRANSFER_STATE_CODE')
176: AND value <> '0'
177: AND ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') = 'NULL'
178: OR
179: ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') <> 'NULL'
180: AND EXISTS
181: ( SELECT '1'

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

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

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

184: substr(puctif.jurisdiction_code,1,2)||'-000-'||substr(puctif.jurisdiction_code,8,4)
185: AND puctif.effective_start_date < PA.effective_date
186: AND puctif.effective_end_date >= PA.effective_date
187: AND substr(puctif.jurisdiction_code,1,2)||'-000-'||substr(puctif.jurisdiction_code,8,4) =
188: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),1,2) ||'-000-'||
189: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),8,11)
190: )
191: )
192: )

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

185: AND puctif.effective_start_date < PA.effective_date
186: AND puctif.effective_end_date >= PA.effective_date
187: AND substr(puctif.jurisdiction_code,1,2)||'-000-'||substr(puctif.jurisdiction_code,8,4) =
188: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),1,2) ||'-000-'||
189: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),8,11)
190: )
191: )
192: )
193: union

Line 206: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

202: pay_action_interlocks AI,
203: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions
204: pay_assignment_actions AA,
205: pay_payroll_actions PA
206: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
207: ('TRANSFER_PAYROLL_ACTION_ID')
208: AND AA.payroll_action_id = PA.payroll_action_id
209: AND AI.locking_action_id = AA.assignment_action_id
210: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value

Line 210: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value

206: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
207: ('TRANSFER_PAYROLL_ACTION_ID')
208: AND AA.payroll_action_id = PA.payroll_action_id
209: AND AI.locking_action_id = AA.assignment_action_id
210: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value
211: ('TAX_UNIT_ID')
212: AND SS.assignment_id = AA.assignment_id
213: AND PE.person_id = SS.person_id
214: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)

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

210: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value
211: ('TAX_UNIT_ID')
212: AND SS.assignment_id = AA.assignment_id
213: AND PE.person_id = SS.person_id
214: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
215: BETWEEN SS.effective_start_date and SS.effective_end_date
216: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
217: BETWEEN PE.effective_start_date and PE.effective_end_date
218: AND AI.locked_action_id = fai.context1

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

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

Line 226: pay_magtape_generic.get_parameter_value('TRANSFER_STATE_CODE')

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

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

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

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

226: pay_magtape_generic.get_parameter_value('TRANSFER_STATE_CODE')
227: AND value <> '0'
228: AND ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') = 'NULL'
229: OR
230: ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') <> 'NULL'
231: AND EXISTS
232: ( SELECT '1'
233: from PAY_US_CITY_SCHOOL_DSTS puctif
234: WHERE

Line 235: puctif.state_code = pay_magtape_generic.get_parameter_value('TRANSFER_STATE_CODE')

231: AND EXISTS
232: ( SELECT '1'
233: from PAY_US_CITY_SCHOOL_DSTS puctif
234: WHERE
235: puctif.state_code = pay_magtape_generic.get_parameter_value('TRANSFER_STATE_CODE')
236: and puctif.state_code ||'-'||
237: puctif.county_code || '-'|| puctif.city_code = pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE')
238: and pay_magtape_generic.get_parameter_value('TRANSFER_STATE_CODE') || '-'|| puctif.school_dst_code = ltrim(rtrim(faic.context))
239: )

Line 237: puctif.county_code || '-'|| puctif.city_code = pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE')

233: from PAY_US_CITY_SCHOOL_DSTS puctif
234: WHERE
235: puctif.state_code = pay_magtape_generic.get_parameter_value('TRANSFER_STATE_CODE')
236: and puctif.state_code ||'-'||
237: puctif.county_code || '-'|| puctif.city_code = pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE')
238: and pay_magtape_generic.get_parameter_value('TRANSFER_STATE_CODE') || '-'|| puctif.school_dst_code = ltrim(rtrim(faic.context))
239: )
240: )
241: )

Line 238: and pay_magtape_generic.get_parameter_value('TRANSFER_STATE_CODE') || '-'|| puctif.school_dst_code = ltrim(rtrim(faic.context))

234: WHERE
235: puctif.state_code = pay_magtape_generic.get_parameter_value('TRANSFER_STATE_CODE')
236: and puctif.state_code ||'-'||
237: puctif.county_code || '-'|| puctif.city_code = pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE')
238: and pay_magtape_generic.get_parameter_value('TRANSFER_STATE_CODE') || '-'|| puctif.school_dst_code = ltrim(rtrim(faic.context))
239: )
240: )
241: )
242: ;

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

247: 'TRANSFER_ACT_ID=P', AA.assignment_action_id,
248: 'YE_ASSIGNMENT_ACTION_ID=P', AA1.assignment_action_id, -- YREND assignment action
249: 'YE_TAX_UNIT_ID=P', AA1.TAX_UNIT_ID,
250: 'EE_ASSIGNMENT_ID=P', AA.assignment_id,
251: 'EE_DATE_EARNED=P', pay_magtape_generic.date_earned(PA.effective_date,
252: AA.assignment_id),
253: 'EE_LOCALITY_JD_CODE=P', substr(ltrim(rtrim(faic.context)),1,2)||'-000-'||substr(ltrim(rtrim(faic.context)),8,4)
254: FROM ff_archive_items FAI,
255: ff_contexts FC, -- JD

Line 264: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

260: pay_action_interlocks AI,
261: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions
262: pay_assignment_actions AA,
263: pay_payroll_actions PA
264: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
265: ('TRANSFER_PAYROLL_ACTION_ID')
266: AND AA.payroll_action_id = PA.payroll_action_id
267: AND AI.locking_action_id = AA.assignment_action_id
268: AND SS.assignment_id = AA.assignment_id

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

266: AND AA.payroll_action_id = PA.payroll_action_id
267: AND AI.locking_action_id = AA.assignment_action_id
268: AND SS.assignment_id = AA.assignment_id
269: AND PE.person_id = SS.person_id
270: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
271: BETWEEN SS.effective_start_date and SS.effective_end_date
272: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
273: BETWEEN PE.effective_start_date and PE.effective_end_date
274: AND AI.locked_action_id = fai.context1

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

268: AND SS.assignment_id = AA.assignment_id
269: AND PE.person_id = SS.person_id
270: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
271: BETWEEN SS.effective_start_date and SS.effective_end_date
272: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
273: BETWEEN PE.effective_start_date and PE.effective_end_date
274: AND AI.locked_action_id = fai.context1
275: AND AI.locked_action_id = AA1.assignment_action_id
276: AND fdi.user_name = 'A_CITY_WITHHELD_PER_JD_GRE_YTD'

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

278: AND faic.archive_item_id = fai.archive_item_id
279: AND fc.context_name = 'JURISDICTION_CODE'
280: AND faic.context_id = fc.context_id
281: AND substr(rtrim(ltrim(faic.context)),1,2) =
282: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),1,2)
283: AND value <> '0'
284: AND ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') IS NULL
285: OR ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') IS NOT NULL
286: AND EXISTS

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

280: AND faic.context_id = fc.context_id
281: AND substr(rtrim(ltrim(faic.context)),1,2) =
282: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),1,2)
283: AND value <> '0'
284: AND ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') IS NULL
285: OR ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') IS NOT NULL
286: AND EXISTS
287: ( SELECT '1'
288: FROM pay_us_city_tax_info_f puctif

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

281: AND substr(rtrim(ltrim(faic.context)),1,2) =
282: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),1,2)
283: AND value <> '0'
284: AND ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') IS NULL
285: OR ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') IS NOT NULL
286: AND EXISTS
287: ( SELECT '1'
288: FROM pay_us_city_tax_info_f puctif
289: WHERE substr(rtrim(ltrim(faic.context)),1,2)||'-000-'||substr(rtrim(ltrim(faic.context)),8,4) =

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

290: substr(puctif.jurisdiction_code,1,2)||'-000-'||substr(puctif.jurisdiction_code,8,4)
291: AND puctif.effective_start_date < PA.effective_date
292: AND puctif.effective_end_date >= PA.effective_date
293: AND substr(puctif.jurisdiction_code,1,2)||'-000-'||substr(puctif.jurisdiction_code,8,4) =
294: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),1,2) ||'-000-'||
295: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),8,11)
296: )
297: )
298: );

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

291: AND puctif.effective_start_date < PA.effective_date
292: AND puctif.effective_end_date >= PA.effective_date
293: AND substr(puctif.jurisdiction_code,1,2)||'-000-'||substr(puctif.jurisdiction_code,8,4) =
294: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),1,2) ||'-000-'||
295: substr(pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE'),8,11)
296: )
297: )
298: );
299: */

Line 303: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

299: */
300:
301: CURSOR local_w2_xml_curr_act_id IS
302: SELECT 'TRANSFER_ACT_ID=P',
303: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
304: FROM DUAL;
305:
306: CURSOR GET_XML_VER IS
307: SELECT 'ROOT_XML_TAG=P',

Line 310: pay_magtape_generic.get_parameter_value(

306: CURSOR GET_XML_VER IS
307: SELECT 'ROOT_XML_TAG=P',
308: '',
309: 'PAYROLL_ACTION_ID=P',
310: pay_magtape_generic.get_parameter_value(
311: 'TRANSFER_PAYROLL_ACTION_ID')
312: FROM dual;
313:
314: FUNCTION bal_db_item

Line 359: pay_magtape_generic.get_parameter_value( 'TRANSFER_ACT_ID' )

355: p_chunk IN NUMBER );
356:
357: CURSOR LOCAL_CURR_ACT_ID IS
358: SELECT 'TRANSFER_ACT_ID=P',
359: pay_magtape_generic.get_parameter_value( 'TRANSFER_ACT_ID' )
360: FROM DUAL;
361:
362: CURSOR LOCAL_MAG_ASG_ACT IS
363: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id

Line 365: WHERE payroll_action_id = pay_magtape_generic.get_parameter_value(

361:
362: CURSOR LOCAL_MAG_ASG_ACT IS
363: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
364: FROM pay_assignment_actions paa
365: WHERE payroll_action_id = pay_magtape_generic.get_parameter_value(
366: 'TRANSFER_PAYROLL_ACTION_ID');
367: --
368: -- Follwing Procedures are used for constructing XML for Submitter or RA Record
369: --