DBA Data[Home] [Help]

APPS.PAY_US_W4_WF dependencies on HR_ORGANIZATION_INFORMATION

Line 411: from hr_organization_information org

407: -- get the GRE contact
408:
409: CURSOR c_gre_contact IS
410: select org.org_information1
411: from hr_organization_information org
412: where org.org_information_context || '' = 'Contact Information'
413: and org.organization_id =
414: (select /*+ ordered */ hsc.segment1 --Bug 3362223
415: from pay_stat_trans_audit pta

Line 428: from hr_organization_information org

424: and pta.transaction_effective_date between paf.effective_start_date
425: and paf.effective_end_date);
426: /*
427: select org.org_information1
428: from hr_organization_information org
429: ,per_assignments_f paf
430: ,pay_stat_trans_audit pta
431: ,hr_soft_coding_keyflex hsc
432: where org.organization_id = hsc.segment1

Line 589: from hr_organization_information org

585:
586: CURSOR c_gre_contact IS
587: select usr.employee_id
588: ,pta.assignment_id
589: from hr_organization_information org
590: ,pay_stat_trans_audit pta
591: ,fnd_user usr
592: where usr.user_name = org.org_information1
593: and pta.assignment_id = ln_current_assignment_id