DBA Data[Home] [Help]

APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on OKL_STRM_ELEMENTS

Line 1464: update okl_strm_elements

1460: END IF;
1461: ELSIF (l_disb_rec.payout_basis IN ('DUE_DATE')) THEN
1462: --update stream element with status of passthru transaction creation
1463: IF NVL(l_return_status, 'E') = OKL_API.G_RET_STS_SUCCESS THEN
1464: update okl_strm_elements
1465: set date_disbursed = trunc(sysdate)
1466: ,object_version_number = object_version_number + 1
1467: ,last_updated_by = FND_GLOBAL.USER_ID
1468: ,last_update_date = sysdate

Line 2089: FROM okl_strm_elements ste,

2085: null payout_basis_formula,
2086: khr.contract_number,
2087: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
2088: khl.legal_entity_id
2089: FROM okl_strm_elements ste,
2090: okl_streams stm,
2091: okl_strm_type_v sty,
2092: okc_k_headers_b khr,
2093: okl_k_headers khl,

Line 2162: FROM okl_strm_elements ste,

2158: null payout_basis_formula,
2159: khr.contract_number,
2160: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
2161: khl.legal_entity_id
2162: FROM okl_strm_elements ste,
2163: okl_streams stm,
2164: okl_strm_type_v sty,
2165: okc_k_headers_b khr,
2166: okl_k_headers khl,