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_GB_BACS_TAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 139: pay_assignment_actions paa,

135: 'TRANSFER_FORMAT_TYPE=P',
136: substr(ppa.LEGISLATIVE_PARAMETERS,instr(LEGISLATIVE_PARAMETERS,'FORMAT_TYPE=')+12,1)
137: from fnd_sessions fnd,
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

Line 159: from pay_assignment_actions paa,

155: 'TRANSFER_CURRENCY_CODE=P',
156: popm.currency_code,
157: 'ORG_PAY_METHOD_NAME=P',
158: popm.ORG_PAYMENT_METHOD_NAME
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')

Line 181: pay_assignment_actions paa

177: from pay_external_accounts pea,
178: pay_personal_payment_methods ppm,
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

Line 217: pay_assignment_actions paa,

213: 'TRANSFER_FORMAT_TYPE=P',
214: substr(ppa.LEGISLATIVE_PARAMETERS,instr(LEGISLATIVE_PARAMETERS,'FORMAT_TYPE=')+12,1)
215: from fnd_sessions fnd,
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

Line 248: from pay_assignment_actions paa,

244: 'TRANSFER_CURRENCY_CODE=P',
245: popm.currency_code,
246: 'ORG_PAY_METHOD_NAME=P',
247: popm.ORG_PAYMENT_METHOD_NAME
248: from pay_assignment_actions paa,
249: pay_pre_payments ppp,
250: pay_org_payment_methods popm,
251: pay_run_results prr,
252: pay_element_types pet,

Line 294: pay_assignment_actions paa2,

290: 'ORG_PAY_METHOD_NAME=P',
291: popm.ORG_PAYMENT_METHOD_NAME
292: from per_time_periods ptp,
293: pay_payroll_actions ppa,
294: pay_assignment_actions paa2,
295: pay_org_payment_methods popm,
296: pay_pre_payments ppp,
297: pay_assignment_actions paa
298: where paa.payroll_action_id =

Line 297: pay_assignment_actions paa

293: pay_payroll_actions ppa,
294: pay_assignment_actions paa2,
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 =

Line 331: pay_assignment_actions opaa

327: from pay_external_accounts opea,
328: pay_personal_payment_methods oppm,
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

Line 375: pay_assignment_actions paa

371: select 1
372: from
373: per_time_periods ptp,
374: pay_payroll_actions ppa,
375: pay_assignment_actions paa
376: where paa.assignment_action_id =
377: (select max(pai.locked_action_id)
378: from pay_action_interlocks pai
379: where oppp.assignment_action_id=pai.locking_action_id

Line 423: pay_assignment_actions paa,

419: substr(ppa.LEGISLATIVE_PARAMETERS,instr(LEGISLATIVE_PARAMETERS,'FORMAT_TYPE=')+12,1)
420: from fnd_sessions fnd,
421: PAY_ORG_PAYMENT_METHODS org,
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

Line 450: pay_assignment_actions paa,

446: min(org.org_payment_method_name)
447: from fnd_sessions fnd,
448: pay_org_payment_methods org,
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

Line 471: FROM pay_assignment_actions paa,

467: 'TRANSFER_BUREAU_NO=P',
468: org.pmeth_information3,
469: 'ORG_PAY_METHOD_NAME=P',
470: org.org_payment_method_name
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')

Line 493: from pay_assignment_actions paa,

489: 'PER_PAY_METHOD_ID=C',
490: ppp.personal_payment_method_id,
491: 'TRANSFER_ASG_ACTION_ID=P',
492: paa.assignment_action_id
493: from pay_assignment_actions paa,
494: pay_pre_payments ppp,
495: per_assignments pa,
496: pay_personal_payment_methods ppm,
497: pay_external_accounts pea

Line 527: pay_assignment_actions paa

523: from fnd_sessions fnd,
524: PAY_ORG_PAYMENT_METHODS org,
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

Line 554: pay_assignment_actions paa

550: from fnd_sessions fnd,
551: pay_org_payment_methods org,
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

Line 586: from pay_assignment_actions paa,

582: 'TRANSFER_BUREAU_NO=P',
583: org.pmeth_information3,
584: 'ORG_PAY_METHOD_NAME=P',
585: org.org_payment_method_name
586: from pay_assignment_actions paa,
587: pay_pre_payments ppp,
588: pay_org_payment_methods org,
589: pay_run_results prr,
590: pay_element_types pet,

Line 634: pay_assignment_actions paa2,

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,
633: pay_payroll_actions ppa,
634: pay_assignment_actions paa2,
635: pay_org_payment_methods org,
636: pay_pre_payments ppp,
637: pay_assignment_actions paa
638: where org.currency_code =

Line 637: pay_assignment_actions paa

633: pay_payroll_actions ppa,
634: pay_assignment_actions paa2,
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')

Line 677: pay_assignment_actions opaa

673: pay_external_accounts opea,
674: pay_personal_payment_methods oppm,
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

Line 721: pay_assignment_actions paa

717: select 1
718: from
719: per_time_periods ptp,
720: pay_payroll_actions ppa,
721: pay_assignment_actions paa
722: where paa.assignment_action_id =
723: (select max(pai.locked_action_id)
724: from pay_action_interlocks pai
725: where oppp.assignment_action_id=pai.locking_action_id