APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKC_K_HEADERS_V

Line 502: FROM OKL_K_HEADERS okhr ,okc_k_headers_v khr

498: o_end_date OUT NOCOPY DATE,
499: o_term_duration OUT NOCOPY NUMBER) IS
500: CURSOR contract_dates IS
501: SELECT khr.start_date,khr.end_date,okhr.term_duration
502: FROM OKL_K_HEADERS okhr ,okc_k_headers_v khr
503: WHERE okhr.id = khr.id
504: AND khr.id = p_contract_id;
505: BEGIN
506: OPEN contract_dates;

Line 533: FROM okc_k_headers_v okhdr,

529: AND org1.id = orv1.rgp_id
530: AND orv1.rule_information_category = 'LASLL'
531: AND exists
532: ( SELECT 'x'
533: FROM okc_k_headers_v okhdr,
534: okc_rule_groups_b org,
535: okc_rules_v orv,
536: OKL_STRMTYP_SOURCE_V stm
537: WHERE okhdr.id = org1.dnz_chr_id

Line 1446: HZ_PARTIES P,OKC_K_HEADERS_V CHR,OKC_STATUSES_V STAT

1442: -- get org_id for contract
1443: CURSOR get_contract_no (p_cust_acct_id IN VARCHAR2) IS
1444: SELECT COUNT(*)
1445: FROM HZ_CUST_ACCOUNTS CA,
1446: HZ_PARTIES P,OKC_K_HEADERS_V CHR,OKC_STATUSES_V STAT
1447: WHERE CHR.scs_code = 'LEASE' AND
1448: CHR.authoring_org_id = mo_global.get_current_org_id() AND
1449: ca.cust_account_id =chr.cust_acct_id AND
1450: ca.party_id = p.party_id AND

Line 1900: okc_k_headers_v khr

1896: IS
1897: 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))))
1898: payment_remaining
1899: FROM okl_k_headers okhr ,
1900: okc_k_headers_v khr
1901: WHERE okhr.id = khr.id
1902: AND khr.id = p_contract_id;
1903:
1904: l_terms_remaining NUMBER;