APPS.PAY_GB_BACS_TAPE dependencies on PAY_PAYROLL_ACTIONS

Line 140: pay_payroll_actions ppa

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
144: and ppp.pre_payment_id = paa.pre_payment_id

Line 218: pay_payroll_actions ppa

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
222: and ppp.pre_payment_id = paa.pre_payment_id

Line 293: pay_payroll_actions ppa,

289: popm.currency_code,
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

Line 374: pay_payroll_actions ppa,

370: union
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

Line 424: pay_payroll_actions ppa

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
428: and ppp.pre_payment_id = paa.pre_payment_id

Line 451: pay_payroll_actions ppa

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
455: and ppp.pre_payment_id = paa.pre_payment_id

Line 526: pay_payroll_actions ppa,

522: substr(ppa.LEGISLATIVE_PARAMETERS,instr(LEGISLATIVE_PARAMETERS,'FORMAT_TYPE=')+12,1)
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

Line 553: pay_payroll_actions ppa,

549: min(org.org_payment_method_name)
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

Line 633: pay_payroll_actions ppa,

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,
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

Line 720: pay_payroll_actions ppa,

716: union
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