APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on DUAL

Line 1873: SELECT SYSDATE INTO l_sys_date FROM DUAL;

1869: END IF;
1870:
1871: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1872:
1873: SELECT SYSDATE INTO l_sys_date FROM DUAL;
1874:
1875: OPEN k_header_csr;
1876: FETCH k_header_csr INTO k_header_rec;
1877: CLOSE k_header_csr;

Line 3342: SELECT SYSDATE INTO l_trn_date FROM DUAL;

3338: END IF;
3339:
3340: x_return_status := OKL_API.g_ret_sts_success;
3341:
3342: SELECT SYSDATE INTO l_trn_date FROM DUAL;
3343:
3344: -- if quote_id exists then
3345: IF p_qte_id IS NOT NULL
3346: AND p_qte_id <> OKL_API.G_MISS_NUM THEN

Line 4135: FROM dual;

4131: l_tapv_rec.PROGRAM_APPLICATION_ID,
4132: l_tapv_rec.PROGRAM_ID,
4133: l_tapv_rec.PROGRAM_UPDATE_DATE,
4134: l_tapv_rec.ORG_ID
4135: FROM dual;
4136:
4137:
4138: ----------------------------------------------------
4139: -- Populate internal AP invoice Lines Record

Line 4651: l_tapv_rec.ORG_ID FROM dual;

4647: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4648: l_tapv_rec.PROGRAM_APPLICATION_ID,
4649: l_tapv_rec.PROGRAM_ID,
4650: l_tapv_rec.PROGRAM_UPDATE_DATE,
4651: l_tapv_rec.ORG_ID FROM dual;
4652:
4653: --**SMODUGA Added for invoice lines ** --
4654: ----------------------------------------------------
4655: -- Populate internal AP invoice Lines Record