APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on DUAL

Line 1895: SELECT SYSDATE INTO l_sys_date FROM DUAL;

1891: END IF;
1892:
1893: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1894:
1895: SELECT SYSDATE INTO l_sys_date FROM DUAL;
1896:
1897: OPEN k_header_csr;
1898: FETCH k_header_csr INTO k_header_rec;
1899: CLOSE k_header_csr;

Line 3364: SELECT SYSDATE INTO l_trn_date FROM DUAL;

3360: END IF;
3361:
3362: x_return_status := OKL_API.g_ret_sts_success;
3363:
3364: SELECT SYSDATE INTO l_trn_date FROM DUAL;
3365:
3366: -- if quote_id exists then
3367: IF p_qte_id IS NOT NULL
3368: AND p_qte_id <> OKL_API.G_MISS_NUM THEN

Line 4157: FROM dual;

4153: l_tapv_rec.PROGRAM_APPLICATION_ID,
4154: l_tapv_rec.PROGRAM_ID,
4155: l_tapv_rec.PROGRAM_UPDATE_DATE,
4156: l_tapv_rec.ORG_ID
4157: FROM dual;
4158:
4159:
4160: ----------------------------------------------------
4161: -- Populate internal AP invoice Lines Record

Line 4673: l_tapv_rec.ORG_ID FROM dual;

4669: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4670: l_tapv_rec.PROGRAM_APPLICATION_ID,
4671: l_tapv_rec.PROGRAM_ID,
4672: l_tapv_rec.PROGRAM_UPDATE_DATE,
4673: l_tapv_rec.ORG_ID FROM dual;
4674:
4675: --**SMODUGA Added for invoice lines ** --
4676: ----------------------------------------------------
4677: -- Populate internal AP invoice Lines Record