APPS.OKL_BILLING_CONTROLLER_PVT dependencies on HR_OPERATING_UNITS

Line 191: FROM hr_operating_units

187: -- Operating Unit
188: -- ----------------------------------------------------------
189: CURSOR op_unit_csr IS
190: SELECT Name org_name, organization_id org_id
191: FROM hr_operating_units
192: WHERE mo_global.check_access(organization_id) = 'Y'; --MOAC
193:
194:
195:

Line 196: l_op_unit_name hr_operating_units.name%TYPE;

192: WHERE mo_global.check_access(organization_id) = 'Y'; --MOAC
193:
194:
195:
196: l_op_unit_name hr_operating_units.name%TYPE;
197: l_op_unit_id hr_operating_units.organization_id%TYPE;--MOAC
198:
199: BEGIN
200:

Line 197: l_op_unit_id hr_operating_units.organization_id%TYPE;--MOAC

193:
194:
195:
196: l_op_unit_name hr_operating_units.name%TYPE;
197: l_op_unit_id hr_operating_units.organization_id%TYPE;--MOAC
198:
199: BEGIN
200:
201:

Line 4087: FROM hr_operating_units

4083: -- Operating Unit
4084: ------------------------------------------------------------
4085: CURSOR op_unit_csr IS
4086: SELECT NAME
4087: FROM hr_operating_units
4088: WHERE ORGANIZATION_ID=MO_GLOBAL.GET_CURRENT_ORG_ID;--MOAC- Concurrent request
4089:
4090:
4091: l_succ_cnt NUMBER;

Line 4093: l_op_unit_name hr_operating_units.name%TYPE;

4089:
4090:
4091: l_succ_cnt NUMBER;
4092: l_err_cnt NUMBER;
4093: l_op_unit_name hr_operating_units.name%TYPE;
4094: lx_msg_data VARCHAR2(450);
4095: l_msg_index_out NUMBER :=0;
4096: processed_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;
4097: error_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;