DBA Data[Home] [Help]

APPS.OKL_SYP_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 1034: FROM ORG_ORGANIZATION_DEFINITIONS

1030: p_remk_organization_id IN NUMBER) IS
1031:
1032: CURSOR l_orgdefs_csr(cp_org_id IN NUMBER) IS
1033: SELECT 'x'
1034: FROM ORG_ORGANIZATION_DEFINITIONS
1035: WHERE ORGANIZATION_ID = cp_org_id
1036: AND SYSDATE <= NVL( DISABLE_DATE, SYSDATE );
1037:
1038: l_dummy VARCHAR2(1);

Line 2270: FROM ORG_ORGANIZATION_DEFINITIONS

2266:
2267: -- get org name
2268: CURSOR l_orgdefs_csr(cp_org_id IN NUMBER) IS
2269: SELECT organization_name
2270: FROM ORG_ORGANIZATION_DEFINITIONS
2271: WHERE organization_id = cp_org_id;
2272:
2273:
2274: BEGIN