DBA Data[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on OKL_PARTY_PAYMENT_DTLS

Line 3226: okl_party_payment_dtls vDtls,

3222: vDtls.PAYMENT_START_DATE,
3223: vDtls.PAYMENT_FREQUENCY,
3224: chr.END_DATE CONTRACT_END_DATE
3225: FROM okl_party_payment_hdr vHdr,
3226: okl_party_payment_dtls vDtls,
3227: okc_k_headers_b chr
3228: WHERE vDtls.payment_hdr_id = vHdr.id
3229: AND vHdr.CLE_ID = cleId
3230: AND vHdr.DNZ_CHR_ID = khrId

Line 3831: okl_party_payment_dtls vDtls,

3827: vDtls.PAYMENT_START_DATE,
3828: vDtls.PAYMENT_FREQUENCY,
3829: chr.END_DATE CONTRACT_END_DATE
3830: FROM okl_party_payment_hdr vHdr,
3831: okl_party_payment_dtls vDtls,
3832: okc_k_headers_b chr
3833: WHERE vDtls.payment_hdr_id = vHdr.id
3834: AND vHdr.CLE_ID = cleId
3835: AND vHdr.DNZ_CHR_ID = khrId

Line 4159: okl_party_payment_dtls vDtls,

4155: vDtls.PAYMENT_START_DATE,
4156: vDtls.PAYMENT_FREQUENCY,
4157: chr.END_DATE CONTRACT_END_DATE
4158: FROM okl_party_payment_hdr vHdr,
4159: okl_party_payment_dtls vDtls,
4160: okc_k_headers_b chr
4161: WHERE vDtls.payment_hdr_id = vHdr.id
4162: AND vHdr.CLE_ID = cleId
4163: AND vHdr.DNZ_CHR_ID = khrId

Line 11209: okl_party_payment_dtls vDtls,

11205: vDtls.PAYMENT_FREQUENCY,
11206: chr.END_DATE CONTRACT_END_DATE,
11207: vDtls.ORIG_CONTRACT_LINE_ID --sechawla 21-Jul-09 8677460 : PRB ESG Enhancements
11208: from okl_party_payment_hdr vHdr,
11209: okl_party_payment_dtls vDtls,
11210: okc_k_headers_b chr
11211: where vDtls.payment_hdr_id = vHdr.id
11212: and vHdr.CLE_ID = cleId
11213: and vHdr.DNZ_CHR_ID = khrId