APPS.PAY_GB_BACS_TAPE dependencies on PAY_PAYROLL_ACTIONS

Line 138: pay_payroll_actions ppa

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

Line 216: pay_payroll_actions ppa

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

Line 291: pay_payroll_actions ppa,

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

Line 372: pay_payroll_actions ppa,

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

Line 422: pay_payroll_actions ppa

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

Line 449: pay_payroll_actions ppa

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

Line 524: pay_payroll_actions ppa,

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

Line 551: pay_payroll_actions ppa,

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

Line 631: pay_payroll_actions ppa,

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

Line 718: pay_payroll_actions ppa,

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