APPS.PJM_SEIBAN_PUB dependencies on HR_ORGANIZATION_INFORMATION

Line 46: select organization_id from HR_ORGANIZATION_INFORMATION

42: AND nvl( end_date_active , sysdate + 1)
43: AND nvl( enabled_flag , 'N' ) = 'Y';
44:
45: CURSOR v4 IS
46: select organization_id from HR_ORGANIZATION_INFORMATION
47: where ORG_INFORMATION_CONTEXT||'' = 'CLASS'
48: AND ORG_INFORMATION1 = 'OPERATING_UNIT'
49: AND ORG_INFORMATION2 = 'Y'
50: AND organization_id = P_operating_unit;