DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 219: From hr_organization_information

215: Cursor c_contract_rep (p_org_id NUMBER) IS
216: Select ORG_INFORMATION1 Contract_Rep,
217: ORG_INFORMATION2 Sales_Rep,
218: ORG_INFORMATION3 CustCare_Rep
219: From hr_organization_information
220: where org_information_context = 'DEFAULT_NOTIFICATION_USER'
221: And organization_id = p_org_id;
222:
223: Cursor c_contract_header(p_id number) IS