APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKC_K_HEADERS_V

Line 540: FROM OKL_K_HEADERS okhr ,okc_k_headers_v khr

536: o_end_date OUT NOCOPY DATE,
537: o_term_duration OUT NOCOPY NUMBER) IS
538: CURSOR contract_dates IS
539: SELECT khr.start_date,khr.end_date,okhr.term_duration
540: FROM OKL_K_HEADERS okhr ,okc_k_headers_v khr
541: WHERE okhr.id = khr.id
542: AND khr.id = p_contract_id;
543: BEGIN
544: OPEN contract_dates;

Line 571: FROM okc_k_headers_v okhdr,

567: AND org1.id = orv1.rgp_id
568: AND orv1.rule_information_category = 'LASLL'
569: AND exists
570: ( SELECT 'x'
571: FROM okc_k_headers_v okhdr,
572: okc_rule_groups_b org,
573: okc_rules_v orv,
574: OKL_STRMTYP_SOURCE_V stm
575: WHERE okhdr.id = org1.dnz_chr_id

Line 1484: HZ_PARTIES P,OKC_K_HEADERS_V CHR,OKC_STATUSES_V STAT

1480: -- get org_id for contract
1481: CURSOR get_contract_no (p_cust_acct_id IN VARCHAR2) IS
1482: SELECT COUNT(*)
1483: FROM HZ_CUST_ACCOUNTS CA,
1484: HZ_PARTIES P,OKC_K_HEADERS_V CHR,OKC_STATUSES_V STAT
1485: WHERE CHR.scs_code = 'LEASE' AND
1486: CHR.authoring_org_id = mo_global.get_current_org_id() AND
1487: ca.cust_account_id =chr.cust_acct_id AND
1488: ca.party_id = p.party_id AND

Line 1938: okc_k_headers_v khr

1934: IS
1935: SELECT okhr.term_duration-DECODE(sign(sysdate-khr.start_date),-1,0,DECODE(sign(sysdate-khr.end_date),1,okhr.term_duration,TRUNC(MONTHS_BETWEEN(sysdate,khr.start_date))))
1936: payment_remaining
1937: FROM okl_k_headers okhr ,
1938: okc_k_headers_v khr
1939: WHERE okhr.id = khr.id
1940: AND khr.id = p_contract_id;
1941:
1942: l_terms_remaining NUMBER;