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 137: pay_assignment_actions paa,

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

Line 157: from pay_assignment_actions paa,

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

Line 179: pay_assignment_actions paa

175: from pay_external_accounts pea,
176: pay_personal_payment_methods ppm,
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

Line 215: pay_assignment_actions paa,

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

Line 246: from pay_assignment_actions paa,

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

Line 292: pay_assignment_actions paa2,

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

Line 295: pay_assignment_actions paa

291: pay_payroll_actions ppa,
292: pay_assignment_actions paa2,
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 =

Line 329: pay_assignment_actions opaa

325: from pay_external_accounts opea,
326: pay_personal_payment_methods oppm,
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

Line 373: pay_assignment_actions paa

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

Line 421: pay_assignment_actions paa,

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

Line 448: pay_assignment_actions paa,

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

Line 469: FROM pay_assignment_actions paa,

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

Line 491: from pay_assignment_actions paa,

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

Line 525: pay_assignment_actions paa

521: from fnd_sessions fnd,
522: PAY_ORG_PAYMENT_METHODS org,
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

Line 552: pay_assignment_actions paa

548: from fnd_sessions fnd,
549: pay_org_payment_methods org,
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

Line 584: from pay_assignment_actions paa,

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

Line 632: pay_assignment_actions paa2,

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

Line 635: pay_assignment_actions paa

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

Line 675: pay_assignment_actions opaa

671: pay_external_accounts opea,
672: pay_personal_payment_methods oppm,
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

Line 719: pay_assignment_actions paa

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