APPS.OKL_TAS_PVT dependencies on DUAL

Line 33: FROM DUAL

29: ln_dummy NUMBER := 0;
30: CURSOR c_ica_validate(p_id number)
31: IS
32: SELECT 1
33: FROM DUAL
34: WHERE EXISTS (SELECT ID1
35: FROM OKX_CUSTOMER_ACCOUNTS_V
36: WHERE id1 = p_id
37: AND id2 = G_ID2);

Line 230: FROM DUAl

226:
227: CURSOR c_try_id_validate(p_id number)
228: is
229: SELECT 1
230: FROM DUAl
231: WHERE EXISTS (SELECT id
232: FROM OKL_TRX_TYPES_B
233: WHERE id = p_id);
234:

Line 311: FROM DUAL

307: ln_dummy NUMBER := 0;
308: CURSOR c_org_validate(p_id number)
309: IS
310: SELECT 1
311: FROM DUAL
312: WHERE EXISTS (SELECT Organization_id
313: FROM HR_OPERATING_UNITS
314: WHERE Organization_id = p_id);
315: BEGIN

Line 816: -- Calling the Validate Procedure to validate Individual Attributes

812: -- notify caller of an error
813: x_return_status := OKC_API.G_RET_STS_ERROR;
814: END IF;
815: /************************ HAND-CODED *********************************/
816: -- Calling the Validate Procedure to validate Individual Attributes
817: validate_ica_id(x_return_status => l_return_status,
818: p_tasv_rec => p_tasv_rec);
819: -- Store the Highest Degree of Error
820: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 1335: FROM dual;

1331: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1332: CURSOR c_get_trans_number
1333: IS
1334: SELECT OKL_TRN_SEQ.NEXTVAL
1335: FROM dual;
1336: BEGIN
1337: x_tasv_rec := p_tasv_rec;
1338: x_tasv_rec.OBJECT_VERSION_NUMBER := 1;
1339: -- Bug no 2627151 change start