325: select /*+ ordered */ org.org_information1 --Bug 3361934
326: from pay_stat_trans_audit pta
327: ,per_assignments_f paf
328: ,hr_soft_coding_keyflex hsc
329: ,hr_organization_information org
330: where org.organization_id = hsc.segment1
331: and hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
332: and paf.assignment_id = pta.assignment_id
333: and pta.transaction_parent_id = ln_transaction_id
474: ,pta.assignment_id
475: from pay_stat_trans_audit pta
476: ,per_assignments_f paf
477: ,hr_soft_coding_keyflex hsc
478: ,hr_organization_information org
479: ,fnd_user usr
480: where org.organization_id = hsc.segment1
481: and usr.user_name = org.org_information1
482: and hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id