DBA Data[Home] [Help]

APPS.OKL_PROPERTY_TAX_STATEMENT_PVT dependencies on HR_OPERATING_UNITS

Line 255: FROM hr_operating_units

251: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED');
252:
253: CURSOR get_operating_unit_csr IS
254: SELECT name
255: FROM hr_operating_units
256: WHERE organization_id = mo_global.get_current_org_id() ;
257: --local variables
258: l_op_unit HR_OPERATING_UNITS.name%type;
259: l_curr_code VARCHAR2(30) DEFAULT NULL;

Line 258: l_op_unit HR_OPERATING_UNITS.name%type;

254: SELECT name
255: FROM hr_operating_units
256: WHERE organization_id = mo_global.get_current_org_id() ;
257: --local variables
258: l_op_unit HR_OPERATING_UNITS.name%type;
259: l_curr_code VARCHAR2(30) DEFAULT NULL;
260: l_request_id NUMBER DEFAULT 0;
261: l_cont_id OKC_K_HEADERS_B.id%TYPE DEFAULT NULL;
262: l_asset_id OKX_ASSET_LINES_V.id1%TYPE DEFAULT NULL;