DBA Data[Home] [Help]

APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on HR_OPERATING_UNITS

Line 862: FROM hr_operating_units

858: -- Operating Unit
859: ------------------------------------------------------------
860: CURSOR op_unit_csr IS
861: SELECT name
862: FROM hr_operating_units
863: WHERE organization_id = nvl(to_number(substrb(userenv('CLIENT_INFO'), 1, 10)), -99);
864:
865: CURSOR xsi_cnt_succ_csr(p_req_id NUMBER, p_sts VARCHAR2) IS
866: SELECT COUNT(*)

Line 879: l_op_unit_name hr_operating_units.name%TYPE;

875: AND request_id = p_req_id;
876:
877: l_succ_cnt NUMBER;
878: l_err_cnt NUMBER;
879: l_op_unit_name hr_operating_units.name%TYPE;
880: lx_msg_data VARCHAR2(450);
881: l_msg_index_out NUMBER := 0;
882:
883: -- ------------------------------------------------

Line 3488: FROM hr_operating_units

3484: -- Operating Unit
3485: ------------------------------------------------------------
3486: CURSOR op_unit_csr IS
3487: SELECT NAME
3488: FROM hr_operating_units
3489: WHERE ORGANIZATION_ID=MO_GLOBAL.GET_CURRENT_ORG_ID; -- MOAC fix - Bug#5378114 --varangan- 29-9-06
3490:
3491:
3492: l_succ_cnt NUMBER;

Line 3493: l_op_unit_name hr_operating_units.name%TYPE;

3489: WHERE ORGANIZATION_ID=MO_GLOBAL.GET_CURRENT_ORG_ID; -- MOAC fix - Bug#5378114 --varangan- 29-9-06
3490:
3491:
3492: l_succ_cnt NUMBER;
3493: l_op_unit_name hr_operating_units.name%TYPE;
3494: lx_msg_data VARCHAR2(450);
3495: l_msg_index_out NUMBER :=0;
3496: submitted_sts okl_trx_ar_invoices_v.trx_status_code%TYPE;
3497: l_end_of_records VARCHAR2(1);