DBA Data[Home] [Help]

APPS.PAY_IE_CESS_REPORT dependencies on HR_ORGANIZATION_INFORMATION

Line 451: ,hr_organization_information org_info

447: org_info1.org_information3 email /* knadhan */
448:
449:
450: FROM hr_all_organization_units org_all
451: ,hr_organization_information org_info
452: ,hr_locations_all hrl
453: ,hr_organization_information org_info1
454:
455: WHERE org_info.organization_id = org_all.organization_id

Line 453: ,hr_organization_information org_info1

449:
450: FROM hr_all_organization_units org_all
451: ,hr_organization_information org_info
452: ,hr_locations_all hrl
453: ,hr_organization_information org_info1
454:
455: WHERE org_info.organization_id = org_all.organization_id
456: AND org_info.org_information_context = 'IE_EMPLOYER_INFO' --for migration changes 4369280
457: AND org_all.location_id = hrl.location_id (+)