DBA Data[Home] [Help]

APPS.OKL_OVD_PVT dependencies on OKX_ORGANIZATION_DEFS_V

Line 654: FROM okx_organization_defs_v ood

650: ,x_return_status OUT NOCOPY VARCHAR2)
651: IS
652: CURSOR okl_okx_orgv_csr (p_id IN NUMBER) IS
653: SELECT '1'
654: FROM okx_organization_defs_v ood
655: WHERE ood.organization_id = p_id
656: AND ood.organization_type = 'OPERATING_UNIT'
657: AND ood.information_type = 'Operating Unit Information'
658: AND ood.b_status = 'Y';

Line 721: FROM okx_organization_defs_v ood

717: ,x_return_status OUT NOCOPY VARCHAR2)
718: IS
719: CURSOR okl_okx_iorgv_csr (p_id IN NUMBER) IS
720: SELECT '1'
721: FROM okx_organization_defs_v ood
722: WHERE ood.organization_id = p_id
723: AND ood.organization_type = 'INV'
724: AND ood.information_type = 'Accounting Information'
725: AND ood.b_status = 'Y'