APPS.PAY_GB_BACS_TAPE dependencies on PAY_MAGTAPE_GENERIC

Line 140: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

136: pay_pre_payments ppp,
137: pay_assignment_actions paa,
138: pay_payroll_actions ppa
139: where paa.payroll_action_id =
140: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
141: and ppa.payroll_action_id = paa.payroll_action_id
142: and ppp.pre_payment_id = paa.pre_payment_id
143: and fnd.session_id = userenv('sessionid')
144: group by fnd.effective_date, sysdate, ppa.overriding_dd_date,ppa.legislative_parameters;

Line 161: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

157: from pay_assignment_actions paa,
158: pay_pre_payments ppp,
159: pay_org_payment_methods popm
160: WHERE paa.payroll_action_id =
161: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
162: AND ppp.pre_payment_id = paa.pre_payment_id
163: AND ppp.org_payment_method_id = popm.org_payment_method_id
164: ORDER by ppp.org_payment_method_id;
165: --

Line 181: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

177: per_assignments pa,
178: pay_pre_payments ppp,
179: pay_assignment_actions paa
180: where paa.payroll_action_id =
181: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
182: and paa.pre_payment_id = ppp.pre_payment_id
183: and paa.assignment_id = pa.assignment_id
184: and ppp.org_payment_method_id +0 =
185: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')

Line 185: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')

181: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
182: and paa.pre_payment_id = ppp.pre_payment_id
183: and paa.assignment_id = pa.assignment_id
184: and ppp.org_payment_method_id +0 =
185: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')
186: and ppp.personal_payment_method_id = ppm.personal_payment_method_id
187: and ppm.external_account_id = pea.external_account_id
188: order by decode(pay_magtape_generic.get_parameter_value('SET_ORDER_BY'),
189: 'A', pa.assignment_number,

Line 188: order by decode(pay_magtape_generic.get_parameter_value('SET_ORDER_BY'),

184: and ppp.org_payment_method_id +0 =
185: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')
186: and ppp.personal_payment_method_id = ppm.personal_payment_method_id
187: and ppm.external_account_id = pea.external_account_id
188: order by decode(pay_magtape_generic.get_parameter_value('SET_ORDER_BY'),
189: 'A', pa.assignment_number,
190: 'S', pea.segment3||pea.segment5,
191: 'E', pea.segment5, null);
192: --

Line 218: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

214: pay_pre_payments ppp,
215: pay_assignment_actions paa,
216: pay_payroll_actions ppa
217: where paa.payroll_action_id =
218: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
219: and ppa.payroll_action_id = paa.payroll_action_id
220: and ppp.pre_payment_id = paa.pre_payment_id
221: and fnd.session_id = userenv('sessionid')
222: group by fnd.effective_date, sysdate, ppa.overriding_dd_date,ppa.legislative_parameters;

Line 231: to_date(pay_magtape_generic.get_parameter_value(

227: 'ORG_PAY_METHOD_ID=C',
228: ppp.org_payment_method_id,
229: 'TRANSFER_PER_PROCESS_DATE=P',
230: to_char(greatest(to_date(prrv.result_value, 'YYYY/MM/DD HH24:MI:SS'),
231: to_date(pay_magtape_generic.get_parameter_value(
232: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYYY/MM/DD HH24:MI:SS'),
233: to_char(greatest(to_date(prrv.result_value, 'YYYY/MM/DD HH24:MI:SS'),
234: to_date(pay_magtape_generic.get_parameter_value(
235: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYYY/MM/DD HH24:MI:SS'),

Line 234: to_date(pay_magtape_generic.get_parameter_value(

230: to_char(greatest(to_date(prrv.result_value, 'YYYY/MM/DD HH24:MI:SS'),
231: to_date(pay_magtape_generic.get_parameter_value(
232: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYYY/MM/DD HH24:MI:SS'),
233: to_char(greatest(to_date(prrv.result_value, 'YYYY/MM/DD HH24:MI:SS'),
234: to_date(pay_magtape_generic.get_parameter_value(
235: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYYY/MM/DD HH24:MI:SS'),
236: 'TRANSFER_PER_PROCESS_DATE2=P',
237: to_char(greatest(to_date(prrv.result_value, 'YYYY/MM/DD HH24:MI:SS'),
238: to_date(pay_magtape_generic.get_parameter_value(

Line 238: to_date(pay_magtape_generic.get_parameter_value(

234: to_date(pay_magtape_generic.get_parameter_value(
235: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYYY/MM/DD HH24:MI:SS'),
236: 'TRANSFER_PER_PROCESS_DATE2=P',
237: to_char(greatest(to_date(prrv.result_value, 'YYYY/MM/DD HH24:MI:SS'),
238: to_date(pay_magtape_generic.get_parameter_value(
239: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYDDD'),
240: 'TRANSFER_USER_NUMBER=P',
241: popm.pmeth_information1,
242: 'TRANSFER_CURRENCY_CODE=P',

Line 254: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

250: pay_element_types pet,
251: pay_run_result_values prrv,
252: pay_input_values piv
253: where paa.payroll_action_id =
254: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
255: and prr.assignment_action_id =
256: (select max(locked_action_id)
257: from pay_action_interlocks pai
258: where ppp.assignment_action_id=pai.locking_action_id

Line 275: to_date(pay_magtape_generic.get_parameter_value(

271: 'ORG_PAY_METHOD_ID=C',
272: ppp.org_payment_method_id,
273: 'TRANSFER_PER_PROCESS_DATE=P',
274: to_char(greatest(ptp.default_dd_date,
275: to_date(pay_magtape_generic.get_parameter_value(
276: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYYY/MM/DD HH24:MI:SS'),
277: to_char(greatest(ptp.default_dd_date,
278: to_date(pay_magtape_generic.get_parameter_value(
279: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYYY/MM/DD HH24:MI:SS'),

Line 278: to_date(pay_magtape_generic.get_parameter_value(

274: to_char(greatest(ptp.default_dd_date,
275: to_date(pay_magtape_generic.get_parameter_value(
276: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYYY/MM/DD HH24:MI:SS'),
277: to_char(greatest(ptp.default_dd_date,
278: to_date(pay_magtape_generic.get_parameter_value(
279: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYYY/MM/DD HH24:MI:SS'),
280: 'TRANSFER_PER_PROCESS_DATE2=P',
281: to_char(greatest(ptp.default_dd_date,
282: to_date(pay_magtape_generic.get_parameter_value(

Line 282: to_date(pay_magtape_generic.get_parameter_value(

278: to_date(pay_magtape_generic.get_parameter_value(
279: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYYY/MM/DD HH24:MI:SS'),
280: 'TRANSFER_PER_PROCESS_DATE2=P',
281: to_char(greatest(ptp.default_dd_date,
282: to_date(pay_magtape_generic.get_parameter_value(
283: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYDDD'),
284: 'TRANSFER_USER_NUMBER=P',
285: popm.pmeth_information1,
286: 'TRANSFER_CURRENCY_CODE=P',

Line 297: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

293: pay_org_payment_methods popm,
294: pay_pre_payments ppp,
295: pay_assignment_actions paa
296: where paa.payroll_action_id =
297: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
298: and ppp.pre_payment_id = paa.pre_payment_id
299: and paa2.assignment_action_id =
300: (select max(locked_action_id)
301: from pay_action_interlocks pai

Line 331: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

327: per_assignments opa,
328: pay_pre_payments oppp,
329: pay_assignment_actions opaa
330: where opaa.payroll_action_id =
331: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
332: and opa.assignment_id = opaa.assignment_id
333: and opaa.pre_payment_id = oppp.pre_payment_id
334: and oppp.org_payment_method_id +0 =
335: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')

Line 335: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')

331: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
332: and opa.assignment_id = opaa.assignment_id
333: and opaa.pre_payment_id = oppp.pre_payment_id
334: and oppp.org_payment_method_id +0 =
335: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')
336: and oppm.personal_payment_method_id = oppp.personal_payment_method_id
337: and opea.external_account_id = oppm.external_account_id
338: and exists (
339: select 1

Line 355: and (to_date(pay_magtape_generic.get_parameter_value(

351: and pet.element_type_id = prr.element_type_id
352: and pet.element_name = 'BACS Process Date'
353: and piv.input_value_id = prrv.input_value_id
354: and piv.name = 'Process Date'
355: and (to_date(pay_magtape_generic.get_parameter_value(
356: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
357: = to_date(prrv.result_value,'YYYY/MM/DD HH24:MI:SS')
358: OR (
359: to_date(prrv.result_value,'YYYY/MM/DD HH24:MI:SS') <

Line 360: to_date(pay_magtape_generic.get_parameter_value(

356: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
357: = to_date(prrv.result_value,'YYYY/MM/DD HH24:MI:SS')
358: OR (
359: to_date(prrv.result_value,'YYYY/MM/DD HH24:MI:SS') <
360: to_date(pay_magtape_generic.get_parameter_value(
361: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
362: AND to_date(pay_magtape_generic.get_parameter_value(
363: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS') =
364: to_date(pay_magtape_generic.get_parameter_value(

Line 362: AND to_date(pay_magtape_generic.get_parameter_value(

358: OR (
359: to_date(prrv.result_value,'YYYY/MM/DD HH24:MI:SS') <
360: to_date(pay_magtape_generic.get_parameter_value(
361: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
362: AND to_date(pay_magtape_generic.get_parameter_value(
363: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS') =
364: to_date(pay_magtape_generic.get_parameter_value(
365: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
366: )

Line 364: to_date(pay_magtape_generic.get_parameter_value(

360: to_date(pay_magtape_generic.get_parameter_value(
361: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
362: AND to_date(pay_magtape_generic.get_parameter_value(
363: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS') =
364: to_date(pay_magtape_generic.get_parameter_value(
365: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
366: )
367: )
368: union

Line 383: to_date(pay_magtape_generic.get_parameter_value(

379: and paa.payroll_action_id = ppa.payroll_action_id
380: and ppa.payroll_id = ptp.payroll_id
381: and ppa.time_period_id = ptp.time_period_id
382: and (ptp.default_dd_date =
383: to_date(pay_magtape_generic.get_parameter_value(
384: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
385: or (pay_magtape_generic.get_parameter_value(
386: 'TRANSFER_PER_PROCESS_DATE') =
387: pay_magtape_generic.get_parameter_value(

Line 385: or (pay_magtape_generic.get_parameter_value(

381: and ppa.time_period_id = ptp.time_period_id
382: and (ptp.default_dd_date =
383: to_date(pay_magtape_generic.get_parameter_value(
384: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
385: or (pay_magtape_generic.get_parameter_value(
386: 'TRANSFER_PER_PROCESS_DATE') =
387: pay_magtape_generic.get_parameter_value(
388: 'TRANSFER_BACS_PROCESS_DATE')
389: and to_date(pay_magtape_generic.get_parameter_value(

Line 387: pay_magtape_generic.get_parameter_value(

383: to_date(pay_magtape_generic.get_parameter_value(
384: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
385: or (pay_magtape_generic.get_parameter_value(
386: 'TRANSFER_PER_PROCESS_DATE') =
387: pay_magtape_generic.get_parameter_value(
388: 'TRANSFER_BACS_PROCESS_DATE')
389: and to_date(pay_magtape_generic.get_parameter_value(
390: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
391: > ptp.default_dd_date))

Line 389: and to_date(pay_magtape_generic.get_parameter_value(

385: or (pay_magtape_generic.get_parameter_value(
386: 'TRANSFER_PER_PROCESS_DATE') =
387: pay_magtape_generic.get_parameter_value(
388: 'TRANSFER_BACS_PROCESS_DATE')
389: and to_date(pay_magtape_generic.get_parameter_value(
390: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
391: > ptp.default_dd_date))
392: and not exists (select 1
393: from pay_element_types pet,

Line 399: order by decode(pay_magtape_generic.get_parameter_value('SET_ORDER_BY'),

395: where prr.assignment_action_id = paa.assignment_action_id
396: and pet.element_type_id = prr.element_type_id
397: and pet.element_name = 'BACS Process Date')
398: )
399: order by decode(pay_magtape_generic.get_parameter_value('SET_ORDER_BY'),
400: 'A', opa.assignment_number,
401: 'S', opea.segment3||opea.segment5,
402: 'E', opea.segment5, null);
403: --

Line 424: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

420: pay_pre_payments ppp,
421: pay_assignment_actions paa,
422: pay_payroll_actions ppa
423: where paa.payroll_action_id =
424: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
425: and ppa.payroll_action_id = paa.payroll_action_id
426: and ppp.pre_payment_id = paa.pre_payment_id
427: and ppp.org_payment_method_id = org.org_payment_method_id
428: and fnd.session_id = userenv('sessionid');

Line 451: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

447: pay_pre_payments ppp,
448: pay_assignment_actions paa,
449: pay_payroll_actions ppa
450: where paa.payroll_action_id =
451: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
452: and ppa.payroll_action_id = paa.payroll_action_id
453: and ppp.pre_payment_id = paa.pre_payment_id
454: and org.org_payment_method_id = ppp.org_payment_method_id
455: and fnd.session_id = userenv('sessionid')

Line 473: pay_magtape_generic.get_parameter_value('TRANSFER_CURRENCY_CODE')

469: FROM pay_assignment_actions paa,
470: pay_pre_payments ppp,
471: pay_org_payment_methods org
472: WHERE org.currency_code =
473: pay_magtape_generic.get_parameter_value('TRANSFER_CURRENCY_CODE')
474: and paa.payroll_action_id =
475: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
476: AND ppp.pre_payment_id = paa.pre_payment_id
477: and ppp.org_payment_method_id = org.org_payment_method_id

Line 475: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

471: pay_org_payment_methods org
472: WHERE org.currency_code =
473: pay_magtape_generic.get_parameter_value('TRANSFER_CURRENCY_CODE')
474: and paa.payroll_action_id =
475: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
476: AND ppp.pre_payment_id = paa.pre_payment_id
477: and ppp.org_payment_method_id = org.org_payment_method_id
478: and org.pmeth_information1 =
479: pay_magtape_generic.get_parameter_value('BACS_TAPE_BACS_USER_NUMBER')

Line 479: pay_magtape_generic.get_parameter_value('BACS_TAPE_BACS_USER_NUMBER')

475: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
476: AND ppp.pre_payment_id = paa.pre_payment_id
477: and ppp.org_payment_method_id = org.org_payment_method_id
478: and org.pmeth_information1 =
479: pay_magtape_generic.get_parameter_value('BACS_TAPE_BACS_USER_NUMBER')
480: ORDER by ppp.org_payment_method_id;
481: --
482: CURSOR ms_bacs_payment IS
483: select 'TRANSFER_VALUE=P',

Line 497: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

493: per_assignments pa,
494: pay_personal_payment_methods ppm,
495: pay_external_accounts pea
496: where paa.payroll_action_id =
497: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
498: and paa.pre_payment_id = ppp.pre_payment_id
499: and paa.assignment_id = pa.assignment_id
500: and ppp.org_payment_method_id +0 =
501: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')

Line 501: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')

497: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
498: and paa.pre_payment_id = ppp.pre_payment_id
499: and paa.assignment_id = pa.assignment_id
500: and ppp.org_payment_method_id +0 =
501: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')
502: and ppp.personal_payment_method_id = ppm.personal_payment_method_id
503: and ppm.external_account_id = pea.external_account_id
504: order by decode(pay_magtape_generic.get_parameter_value('SET_ORDER_BY'),
505: 'A', pa.assignment_number, 'S', pea.segment3||pea.segment5, 'E', pea.segment5, null);

Line 504: order by decode(pay_magtape_generic.get_parameter_value('SET_ORDER_BY'),

500: and ppp.org_payment_method_id +0 =
501: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')
502: and ppp.personal_payment_method_id = ppm.personal_payment_method_id
503: and ppm.external_account_id = pea.external_account_id
504: order by decode(pay_magtape_generic.get_parameter_value('SET_ORDER_BY'),
505: 'A', pa.assignment_number, 'S', pea.segment3||pea.segment5, 'E', pea.segment5, null);
506: --
507: --
508: -- Multi file multi day

Line 527: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

523: pay_pre_payments ppp,
524: pay_payroll_actions ppa,
525: pay_assignment_actions paa
526: where paa.payroll_action_id =
527: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
528: and ppa.payroll_action_id = paa.payroll_action_id
529: and ppp.pre_payment_id = paa.pre_payment_id
530: and ppp.org_payment_method_id = org.org_payment_method_id
531: and fnd.session_id = userenv('sessionid');

Line 554: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

550: pay_pre_payments ppp,
551: pay_payroll_actions ppa,
552: pay_assignment_actions paa
553: where paa.payroll_action_id =
554: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
555: and ppa.payroll_action_id = paa.payroll_action_id
556: and ppp.pre_payment_id = paa.pre_payment_id
557: and org.org_payment_method_id = ppp.org_payment_method_id
558: and fnd.session_id = userenv('sessionid')

Line 571: to_date(pay_magtape_generic.get_parameter_value(

567: 'ORG_PAY_METHOD_ID=C',
568: ppp.org_payment_method_id,
569: 'TRANSFER_PER_PROCESS_DATE=P',
570: to_char(greatest(to_date(prrv.result_value, 'YYYY/MM/DD HH24:MI:SS'),
571: to_date(pay_magtape_generic.get_parameter_value(
572: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYYY/MM/DD HH24:MI:SS'),
573: to_char(greatest(to_date(prrv.result_value, 'YYYY/MM/DD HH24:MI:SS'),
574: to_date(pay_magtape_generic.get_parameter_value(
575: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYYY/MM/DD HH24:MI:SS'),

Line 574: to_date(pay_magtape_generic.get_parameter_value(

570: to_char(greatest(to_date(prrv.result_value, 'YYYY/MM/DD HH24:MI:SS'),
571: to_date(pay_magtape_generic.get_parameter_value(
572: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYYY/MM/DD HH24:MI:SS'),
573: to_char(greatest(to_date(prrv.result_value, 'YYYY/MM/DD HH24:MI:SS'),
574: to_date(pay_magtape_generic.get_parameter_value(
575: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYYY/MM/DD HH24:MI:SS'),
576: 'TRANSFER_PER_PROCESS_DATE2=P',
577: to_char(greatest(to_date(prrv.result_value, 'YYYY/MM/DD HH24:MI:SS'),
578: to_date(pay_magtape_generic.get_parameter_value(

Line 578: to_date(pay_magtape_generic.get_parameter_value(

574: to_date(pay_magtape_generic.get_parameter_value(
575: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYYY/MM/DD HH24:MI:SS'),
576: 'TRANSFER_PER_PROCESS_DATE2=P',
577: to_char(greatest(to_date(prrv.result_value, 'YYYY/MM/DD HH24:MI:SS'),
578: to_date(pay_magtape_generic.get_parameter_value(
579: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYDDD'),
580: 'TRANSFER_BUREAU_NO=P',
581: org.pmeth_information3,
582: 'ORG_PAY_METHOD_NAME=P',

Line 592: pay_magtape_generic.get_parameter_value('TRANSFER_CURRENCY_CODE')

588: pay_element_types pet,
589: pay_run_result_values prrv,
590: pay_input_values piv
591: where org.currency_code =
592: pay_magtape_generic.get_parameter_value('TRANSFER_CURRENCY_CODE')
593: and paa.payroll_action_id =
594: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
595: and ppp.pre_payment_id = paa.pre_payment_id
596: and ppp.org_payment_method_id = org.org_payment_method_id

Line 594: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

590: pay_input_values piv
591: where org.currency_code =
592: pay_magtape_generic.get_parameter_value('TRANSFER_CURRENCY_CODE')
593: and paa.payroll_action_id =
594: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
595: and ppp.pre_payment_id = paa.pre_payment_id
596: and ppp.org_payment_method_id = org.org_payment_method_id
597: and org.pmeth_information1 =
598: pay_magtape_generic.get_parameter_value('BACS_TAPE_BACS_USER_NUMBER')

Line 598: pay_magtape_generic.get_parameter_value('BACS_TAPE_BACS_USER_NUMBER')

594: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
595: and ppp.pre_payment_id = paa.pre_payment_id
596: and ppp.org_payment_method_id = org.org_payment_method_id
597: and org.pmeth_information1 =
598: pay_magtape_generic.get_parameter_value('BACS_TAPE_BACS_USER_NUMBER')
599: and prr.assignment_action_id =
600: (select max(locked_action_id)
601: + decode(org.org_payment_method_id,0,0,0)
602: from pay_action_interlocks pai

Line 619: to_date(pay_magtape_generic.get_parameter_value(

615: 'ORG_PAY_METHOD_ID=C',
616: ppp.org_payment_method_id,
617: 'TRANSFER_PER_PROCESS_DATE=P',
618: to_char(greatest(ptp.default_dd_date,
619: to_date(pay_magtape_generic.get_parameter_value(
620: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYYY/MM/DD HH24:MI:SS'),
621: to_char(greatest(ptp.default_dd_date,
622: to_date(pay_magtape_generic.get_parameter_value(
623: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYYY/MM/DD HH24:MI:SS'),

Line 622: to_date(pay_magtape_generic.get_parameter_value(

618: to_char(greatest(ptp.default_dd_date,
619: to_date(pay_magtape_generic.get_parameter_value(
620: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYYY/MM/DD HH24:MI:SS'),
621: to_char(greatest(ptp.default_dd_date,
622: to_date(pay_magtape_generic.get_parameter_value(
623: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYYY/MM/DD HH24:MI:SS'),
624: 'TRANSFER_PER_PROCESS_DATE2=P',
625: to_char(greatest(ptp.default_dd_date,
626: to_date(pay_magtape_generic.get_parameter_value(

Line 626: to_date(pay_magtape_generic.get_parameter_value(

622: to_date(pay_magtape_generic.get_parameter_value(
623: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYYY/MM/DD HH24:MI:SS'),
624: 'TRANSFER_PER_PROCESS_DATE2=P',
625: to_char(greatest(ptp.default_dd_date,
626: to_date(pay_magtape_generic.get_parameter_value(
627: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYDDD'),
628: 'TRANSFER_BUREAU_NO=P', org.pmeth_information3,
629: 'ORG_PAY_METHOD_NAME=P', org.org_payment_method_name
630: from per_time_periods ptp,

Line 637: pay_magtape_generic.get_parameter_value('TRANSFER_CURRENCY_CODE')

633: pay_org_payment_methods org,
634: pay_pre_payments ppp,
635: pay_assignment_actions paa
636: where org.currency_code =
637: pay_magtape_generic.get_parameter_value('TRANSFER_CURRENCY_CODE')
638: and paa.payroll_action_id =
639: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
640: and ppp.pre_payment_id = paa.pre_payment_id
641: and ppp.org_payment_method_id = org.org_payment_method_id

Line 639: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

635: pay_assignment_actions paa
636: where org.currency_code =
637: pay_magtape_generic.get_parameter_value('TRANSFER_CURRENCY_CODE')
638: and paa.payroll_action_id =
639: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
640: and ppp.pre_payment_id = paa.pre_payment_id
641: and ppp.org_payment_method_id = org.org_payment_method_id
642: and org.pmeth_information1 =
643: pay_magtape_generic.get_parameter_value('BACS_TAPE_BACS_USER_NUMBER')

Line 643: pay_magtape_generic.get_parameter_value('BACS_TAPE_BACS_USER_NUMBER')

639: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
640: and ppp.pre_payment_id = paa.pre_payment_id
641: and ppp.org_payment_method_id = org.org_payment_method_id
642: and org.pmeth_information1 =
643: pay_magtape_generic.get_parameter_value('BACS_TAPE_BACS_USER_NUMBER')
644: and paa2.assignment_action_id =
645: (select max(locked_action_id)
646: + decode(org.org_payment_method_id,0,0,0)
647: from pay_action_interlocks pai

Line 677: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

673: per_assignments opa,
674: pay_pre_payments oppp,
675: pay_assignment_actions opaa
676: where opaa.payroll_action_id =
677: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
678: and opa.assignment_id = opaa.assignment_id
679: and opaa.pre_payment_id = oppp.pre_payment_id
680: and oppp.org_payment_method_id =
681: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')

Line 681: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')

677: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
678: and opa.assignment_id = opaa.assignment_id
679: and opaa.pre_payment_id = oppp.pre_payment_id
680: and oppp.org_payment_method_id =
681: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')
682: and oppm.personal_payment_method_id = oppp.personal_payment_method_id
683: and opea.external_account_id = oppm.external_account_id
684: and exists (
685: select 1

Line 701: and (to_date(pay_magtape_generic.get_parameter_value(

697: and pet.element_type_id = prr.element_type_id
698: and pet.element_name = 'BACS Process Date'
699: and piv.input_value_id = prrv.input_value_id
700: and piv.name = 'Process Date'
701: and (to_date(pay_magtape_generic.get_parameter_value(
702: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
703: = to_date(prrv.result_value,'YYYY/MM/DD HH24:MI:SS')
704: OR (
705: to_date(prrv.result_value,'YYYY/MM/DD HH24:MI:SS') <

Line 706: to_date(pay_magtape_generic.get_parameter_value(

702: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
703: = to_date(prrv.result_value,'YYYY/MM/DD HH24:MI:SS')
704: OR (
705: to_date(prrv.result_value,'YYYY/MM/DD HH24:MI:SS') <
706: to_date(pay_magtape_generic.get_parameter_value(
707: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
708: AND to_date(pay_magtape_generic.get_parameter_value(
709: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS') =
710: to_date(pay_magtape_generic.get_parameter_value(

Line 708: AND to_date(pay_magtape_generic.get_parameter_value(

704: OR (
705: to_date(prrv.result_value,'YYYY/MM/DD HH24:MI:SS') <
706: to_date(pay_magtape_generic.get_parameter_value(
707: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
708: AND to_date(pay_magtape_generic.get_parameter_value(
709: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS') =
710: to_date(pay_magtape_generic.get_parameter_value(
711: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
712: )

Line 710: to_date(pay_magtape_generic.get_parameter_value(

706: to_date(pay_magtape_generic.get_parameter_value(
707: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
708: AND to_date(pay_magtape_generic.get_parameter_value(
709: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS') =
710: to_date(pay_magtape_generic.get_parameter_value(
711: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
712: )
713: )
714: union

Line 729: to_date(pay_magtape_generic.get_parameter_value(

725: and paa.payroll_action_id = ppa.payroll_action_id
726: and ppa.payroll_id = ptp.payroll_id
727: and ppa.time_period_id = ptp.time_period_id
728: and (ptp.default_dd_date =
729: to_date(pay_magtape_generic.get_parameter_value(
730: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
731: or (pay_magtape_generic.get_parameter_value(
732: 'TRANSFER_PER_PROCESS_DATE') =
733: pay_magtape_generic.get_parameter_value(

Line 731: or (pay_magtape_generic.get_parameter_value(

727: and ppa.time_period_id = ptp.time_period_id
728: and (ptp.default_dd_date =
729: to_date(pay_magtape_generic.get_parameter_value(
730: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
731: or (pay_magtape_generic.get_parameter_value(
732: 'TRANSFER_PER_PROCESS_DATE') =
733: pay_magtape_generic.get_parameter_value(
734: 'TRANSFER_BACS_PROCESS_DATE')
735: and to_date(pay_magtape_generic.get_parameter_value(

Line 733: pay_magtape_generic.get_parameter_value(

729: to_date(pay_magtape_generic.get_parameter_value(
730: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
731: or (pay_magtape_generic.get_parameter_value(
732: 'TRANSFER_PER_PROCESS_DATE') =
733: pay_magtape_generic.get_parameter_value(
734: 'TRANSFER_BACS_PROCESS_DATE')
735: and to_date(pay_magtape_generic.get_parameter_value(
736: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
737: > ptp.default_dd_date))

Line 735: and to_date(pay_magtape_generic.get_parameter_value(

731: or (pay_magtape_generic.get_parameter_value(
732: 'TRANSFER_PER_PROCESS_DATE') =
733: pay_magtape_generic.get_parameter_value(
734: 'TRANSFER_BACS_PROCESS_DATE')
735: and to_date(pay_magtape_generic.get_parameter_value(
736: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
737: > ptp.default_dd_date))
738: and not exists (select 1
739: from pay_element_types pet,

Line 745: order by decode(pay_magtape_generic.get_parameter_value('SET_ORDER_BY'),

741: where prr.assignment_action_id = paa.assignment_action_id
742: and pet.element_type_id = prr.element_type_id
743: and pet.element_name = 'BACS Process Date')
744: )
745: order by decode(pay_magtape_generic.get_parameter_value('SET_ORDER_BY'),
746: 'A', opa.assignment_number,
747: 'S', opea.segment3||opea.segment5,
748: 'E', opea.segment5, null);
749: --