210: and hroinf.org_information2 = 'Y'
211: and EXISTS
212: ( select 1
213: from per_assignments_f perasg,
214: pay_assignment_actions pyaact
215: where pyaact.payroll_action_id = p_payroll_action_id
216: and pyaact.tax_unit_id = hrorgu.organization_id
217: and perasg.assignment_id = pyaact.assignment_id
218: and g_effective_date between perasg.effective_start_date
233: ppp.value,
234: ppp.personal_payment_method_id,
235: ppp.pre_payment_id,
236: ppp.rowid
237: from pay_assignment_actions paa,
238: pay_pre_payments ppp
239: where ppp.org_payment_method_id+0 = p_org_payment_method_id -- suppressing index for performance improvement Bug 3587226
240: and ppp.PRE_PAYMENT_ID = paa.PRE_PAYMENT_ID
241: and paa.PAYROLL_ACTION_ID = p_payroll_action_id
269: ppp.value,
270: ppp.personal_payment_method_id,
271: ppp.pre_payment_id,
272: ppp.rowid
273: from pay_assignment_actions paa,
274: pay_pre_payments ppp
275: where ppp.org_payment_method_id = p_org_payment_method_id
276: and ppp.PRE_PAYMENT_ID = paa.PRE_PAYMENT_ID
277: and paa.PAYROLL_ACTION_ID = p_payroll_action_id