APPS.AHL_AVF_OPER_VSTS_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 1689: FROM org_organization_definitions hou

1685:
1686: Cursor is_org_in_current_OU (c_org_id IN NUMBER)
1687: IS
1688: SELECT 'X'
1689: FROM org_organization_definitions hou
1690: WHERE hou.organization_id = c_org_id
1691: AND NVL(hou.operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id();
1692: l_is_org_in_curr_OU VARCHAR2(1);
1693:

Line 4144: FROM org_organization_definitions hou

4140:
4141: Cursor is_org_in_current_OU (c_org_id IN NUMBER)
4142: IS
4143: SELECT 'X'
4144: FROM org_organization_definitions hou
4145: WHERE hou.organization_id = c_org_id
4146: AND NVL(hou.operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id();
4147:
4148: -- Cursor to get the visit Number from visit_id

Line 4404: FROM org_organization_definitions hou

4400:
4401: Cursor is_org_in_current_OU (c_org_id IN NUMBER)
4402: IS
4403: SELECT 'X'
4404: FROM org_organization_definitions hou
4405: WHERE hou.organization_id = c_org_id
4406: AND NVL(hou.operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id();
4407:
4408: -- Cursor to get the visit Number from visit_id

Line 4660: FROM org_organization_definitions hou

4656:
4657: Cursor is_org_in_current_OU (c_org_id IN NUMBER)
4658: IS
4659: SELECT 'X'
4660: FROM org_organization_definitions hou
4661: WHERE hou.organization_id = c_org_id
4662: AND NVL(hou.operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id();
4663:
4664: -- Cursor to get the visit Number from visit_id