DBA Data[Home] [Help]

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 4151: FROM hr_operating_units

4147: -- Operating Unit
4148: ------------------------------------------------------------
4149: CURSOR op_unit_csr IS
4150: SELECT NAME
4151: FROM hr_operating_units
4152: WHERE ORGANIZATION_ID=MO_GLOBAL.GET_CURRENT_ORG_ID;--MOAC- Concurrent request
4153:
4154:
4155: l_succ_cnt NUMBER;

Line 4157: l_op_unit_name hr_operating_units.name%TYPE;

4153:
4154:
4155: l_succ_cnt NUMBER;
4156: l_err_cnt NUMBER;
4157: l_op_unit_name hr_operating_units.name%TYPE;
4158: lx_msg_data VARCHAR2(450);
4159: l_msg_index_out NUMBER :=0;
4160: processed_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;
4161: error_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;