455: ,pta.assignment_id
456: from pay_stat_trans_audit pta
457: ,per_assignments_f paf
458: ,pay_payrolls_f prl
459: ,fnd_user usr
460: where prl.payroll_id = paf.payroll_id
461: and usr.user_name = prl.prl_information1
462: and prl.prl_information_category = 'US'
463: and paf.assignment_id = 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
483: and paf.assignment_id = pta.assignment_id