DBA Data[Home] [Help]

APPS.PAY_PGR_BUS dependencies on HR_ORGANIZATION_INFORMATION

Line 576: FROM hr_organization_information hoi

572: --
573:
574: CURSOR csr_bg_curr_cd(l_bg_id number) IS
575: SELECT org_information10
576: FROM hr_organization_information hoi
577: WHERE hoi.organization_id = l_bg_id
578: AND hoi.org_information_context = 'Business Group Information'
579: AND hoi.org_information2 IS NOT NULL
580: AND EXISTS

Line 583: hr_organization_information org_info

579: AND hoi.org_information2 IS NOT NULL
580: AND EXISTS
581: ( SELECT NULL
582: FROM hr_org_info_types_by_class oitbc,
583: hr_organization_information org_info
584: WHERE org_info.organization_id = hoi.organization_id
585: AND org_info.org_information_context = 'CLASS'
586: AND org_info.org_information2 = 'Y'
587: AND oitbc.org_classification = org_info.org_information1