DBA Data[Home] [Help]

APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on OKL_STRM_ELEMENTS

Line 1514: update okl_strm_elements

1510: END IF;
1511: ELSIF (l_disb_rec.payout_basis IN ('DUE_DATE')) THEN
1512: --update stream element with status of passthru transaction creation
1513: IF NVL(l_return_status, 'E') = OKL_API.G_RET_STS_SUCCESS THEN
1514: update okl_strm_elements
1515: set date_disbursed = trunc(sysdate)
1516: ,object_version_number = object_version_number + 1
1517: ,last_updated_by = FND_GLOBAL.USER_ID
1518: ,last_update_date = sysdate

Line 2142: FROM okl_strm_elements ste,

2138: null payout_basis_formula,
2139: khr.contract_number,
2140: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
2141: khl.legal_entity_id
2142: FROM okl_strm_elements ste,
2143: okl_streams stm,
2144: okl_strm_type_v sty,
2145: okc_k_headers_b khr,
2146: okl_k_headers khl,

Line 2215: FROM okl_strm_elements ste,

2211: null payout_basis_formula,
2212: khr.contract_number,
2213: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
2214: khl.legal_entity_id
2215: FROM okl_strm_elements ste,
2216: okl_streams stm,
2217: okl_strm_type_v sty,
2218: okc_k_headers_b khr,
2219: okl_k_headers khl,