DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 209: From hr_organization_information

205: Cursor c_contract_rep (p_org_id NUMBER) IS
206: Select ORG_INFORMATION1 Contract_Rep,
207: ORG_INFORMATION2 Sales_Rep,
208: ORG_INFORMATION3 CustCare_Rep
209: From hr_organization_information
210: where org_information_context = 'DEFAULT_NOTIFICATION_USER'
211: And organization_id = p_org_id;
212:
213: Cursor c_contract_header(p_id number) IS