DBA Data[Home] [Help]

APPS.PAY_US_TAX_WF dependencies on HR_ORGANIZATION_INFORMATION

Line 329: ,hr_organization_information org

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

Line 478: ,hr_organization_information org

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