DBA Data[Home] [Help]

APPS.OKL_PRICING_PVT dependencies on OKL_K_HEADERS

Line 2322: okl_k_headers khr_so,

2318: SELECT trunc(FND_DATE.canonical_to_date(rul_sll.rule_information2)) start_date,
2319: NVL(rul_sll.rule_information10, 'Y') arrears_yn,
2320: khr_so.term_duration
2321: FROM okc_k_headers_b chr_so,
2322: okl_k_headers khr_so,
2323: okc_line_styles_b lse_so,
2324: okc_k_lines_b cle_so,
2325: okc_rule_groups_b rgp_pay,
2326: okc_rules_b rul_slh,

Line 5831: okl_k_headers khr

5827: khr.deal_type,
5828: khr.term_duration,
5829: NVL(khr.generate_accrual_yn, 'Y')
5830: FROM okc_k_headers_b chr,
5831: okl_k_headers khr
5832: WHERE khr.id = p_khr_id
5833: AND chr.id = khr.id;
5834:
5835: l_hdr c_hdr%ROWTYPE;

Line 7034: okl_k_headers khr

7030: khr.deal_type,
7031: khr.term_duration,
7032: NVL(khr.generate_accrual_yn, 'Y')
7033: FROM okc_k_headers_b chr,
7034: okl_k_headers khr
7035: WHERE khr.id = p_khr_id
7036: AND chr.id = khr.id;
7037:
7038: l_hdr c_hdr%ROWTYPE;

Line 7855: okl_k_headers khr,

7851: nvl(pdt.reporting_pdt_id, -1) report_pdt_id,
7852: chr.currency_code currency_code,
7853: khr.term_duration term
7854: from okc_k_headers_v chr,
7855: okl_k_headers khr,
7856: okl_products_v pdt
7857: where khr.id = chr.id
7858: and chr.id = p_khr_id
7859: and khr.pdt_id = pdt.id(+);

Line 9543: okl_k_headers khr

9539: khr.deal_type,
9540: khr.term_duration,
9541: NVL(khr.generate_accrual_yn, 'Y')
9542: FROM okc_k_headers_b chr,
9543: okl_k_headers khr
9544: WHERE khr.id = p_khr_id
9545: AND chr.id = khr.id;
9546:
9547: l_hdr c_hdr%ROWTYPE;