APPS.PAY_GB_BACS_TAPE dependencies on PAY_MAGTAPE_GENERIC

Line 142: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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

Line 163: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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

Line 183: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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

Line 187: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')

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

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

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

Line 220: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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

Line 233: to_date(pay_magtape_generic.get_parameter_value(

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

Line 236: to_date(pay_magtape_generic.get_parameter_value(

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

Line 240: to_date(pay_magtape_generic.get_parameter_value(

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

Line 256: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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

Line 277: to_date(pay_magtape_generic.get_parameter_value(

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

Line 280: to_date(pay_magtape_generic.get_parameter_value(

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

Line 284: to_date(pay_magtape_generic.get_parameter_value(

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

Line 299: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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

Line 333: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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

Line 337: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')

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

Line 357: and (to_date(pay_magtape_generic.get_parameter_value(

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

Line 362: to_date(pay_magtape_generic.get_parameter_value(

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

Line 364: AND to_date(pay_magtape_generic.get_parameter_value(

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

Line 366: to_date(pay_magtape_generic.get_parameter_value(

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

Line 385: to_date(pay_magtape_generic.get_parameter_value(

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

Line 387: or (pay_magtape_generic.get_parameter_value(

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

Line 389: pay_magtape_generic.get_parameter_value(

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

Line 391: and to_date(pay_magtape_generic.get_parameter_value(

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

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

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

Line 426: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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

Line 453: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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

Line 475: pay_magtape_generic.get_parameter_value('TRANSFER_CURRENCY_CODE')

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

Line 477: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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

Line 481: pay_magtape_generic.get_parameter_value('BACS_TAPE_BACS_USER_NUMBER')

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

Line 499: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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

Line 503: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')

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

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

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

Line 529: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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

Line 556: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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

Line 573: to_date(pay_magtape_generic.get_parameter_value(

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

Line 576: to_date(pay_magtape_generic.get_parameter_value(

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

Line 580: to_date(pay_magtape_generic.get_parameter_value(

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

Line 594: pay_magtape_generic.get_parameter_value('TRANSFER_CURRENCY_CODE')

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

Line 596: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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

Line 600: pay_magtape_generic.get_parameter_value('BACS_TAPE_BACS_USER_NUMBER')

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

Line 621: to_date(pay_magtape_generic.get_parameter_value(

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

Line 624: to_date(pay_magtape_generic.get_parameter_value(

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

Line 628: to_date(pay_magtape_generic.get_parameter_value(

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

Line 639: pay_magtape_generic.get_parameter_value('TRANSFER_CURRENCY_CODE')

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

Line 641: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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

Line 645: pay_magtape_generic.get_parameter_value('BACS_TAPE_BACS_USER_NUMBER')

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

Line 679: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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

Line 683: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')

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

Line 703: and (to_date(pay_magtape_generic.get_parameter_value(

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

Line 708: to_date(pay_magtape_generic.get_parameter_value(

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

Line 710: AND to_date(pay_magtape_generic.get_parameter_value(

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

Line 712: to_date(pay_magtape_generic.get_parameter_value(

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

Line 731: to_date(pay_magtape_generic.get_parameter_value(

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

Line 733: or (pay_magtape_generic.get_parameter_value(

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

Line 735: pay_magtape_generic.get_parameter_value(

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

Line 737: and to_date(pay_magtape_generic.get_parameter_value(

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

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

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