APPS.OKL_TCN_PVT dependencies on DUAL

Line 10: SELECT OKL_TRX_CONTRACTS_ALL_S.NEXTVAL INTO l_seq FROM DUAL;

6: FUNCTION get_seq_id RETURN NUMBER IS
7: l_seq NUMBER;
8: BEGIN
9: -- Changed by nikshah for SLA project (Bug 5707866) 16-Apr-2007
10: SELECT OKL_TRX_CONTRACTS_ALL_S.NEXTVAL INTO l_seq FROM DUAL;
11: RETURN l_seq;
12: END get_seq_id;
13:
14: ---------------------------------------------------------------------------

Line 4952: FROM DUAL;

4948: INTO x_tcnv_rec.REQUEST_ID
4949: ,x_tcnv_rec.PROGRAM_APPLICATION_ID
4950: ,x_tcnv_rec.PROGRAM_ID
4951: ,x_tcnv_rec.PROGRAM_UPDATE_DATE
4952: FROM DUAL;
4953: -- Commented by zrehman for SLA project (Bug 5707866) 21-Feb-2007
4954: -- The derivation for the column is moved to OKL_TRX_CONTRACTS_PVT which in turn is
4955: -- used to derive representation_name and representation_code
4956: -- start

Line 4967: SELECT OKL_TCN_SEQ.NEXTVAL INTO x_tcnv_rec.trx_number FROM DUAL;

4963: BEGIN
4964:
4965: IF (x_tcnv_rec.trx_number IS NULL) OR
4966: (x_tcnv_rec.trx_number = OKL_API.G_MISS_CHAR) THEN
4967: SELECT OKL_TCN_SEQ.NEXTVAL INTO x_tcnv_rec.trx_number FROM DUAL;
4968: END IF;
4969:
4970: IF (x_tcnv_rec.currency_code IS NULL) OR
4971: (x_tcnv_rec.currency_code = OKL_API.G_MISS_CHAR) THEN

Line 6529: FROM DUAL;

6525: INTO x_tcnv_rec.REQUEST_ID
6526: ,x_tcnv_rec.PROGRAM_APPLICATION_ID
6527: ,x_tcnv_rec.PROGRAM_ID
6528: ,x_tcnv_rec.PROGRAM_UPDATE_DATE
6529: FROM DUAL;
6530:
6531: RETURN(l_return_status);
6532: END Set_Attributes;
6533: BEGIN