DBA Data[Home] [Help]

APPS.OKL_PRICING_PVT dependencies on OKL_K_HEADERS

Line 2722: okl_k_headers khr_so,

2718: SELECT trunc(FND_DATE.canonical_to_date(rul_sll.rule_information2)) start_date,
2719: NVL(rul_sll.rule_information10, 'Y') arrears_yn,
2720: khr_so.term_duration
2721: FROM okc_k_headers_b chr_so,
2722: okl_k_headers khr_so,
2723: okc_line_styles_b lse_so,
2724: okc_k_lines_b cle_so,
2725: okc_rule_groups_b rgp_pay,
2726: okc_rules_b rul_slh,

Line 6221: okl_k_headers khr

6217: khr.deal_type,
6218: khr.term_duration,
6219: NVL(khr.generate_accrual_yn, 'Y')
6220: FROM okc_k_headers_b chr,
6221: okl_k_headers khr
6222: WHERE khr.id = p_khr_id
6223: AND chr.id = khr.id;
6224:
6225: l_hdr c_hdr%ROWTYPE;

Line 7424: okl_k_headers khr

7420: khr.deal_type,
7421: khr.term_duration,
7422: NVL(khr.generate_accrual_yn, 'Y')
7423: FROM okc_k_headers_b chr,
7424: okl_k_headers khr
7425: WHERE khr.id = p_khr_id
7426: AND chr.id = khr.id;
7427:
7428: l_hdr c_hdr%ROWTYPE;

Line 8245: okl_k_headers khr,

8241: nvl(pdt.reporting_pdt_id, -1) report_pdt_id,
8242: chr.currency_code currency_code,
8243: khr.term_duration term
8244: from okc_k_headers_v chr,
8245: okl_k_headers khr,
8246: okl_products_v pdt
8247: where khr.id = chr.id
8248: and chr.id = p_khr_id
8249: and khr.pdt_id = pdt.id(+);

Line 9928: okl_k_headers khr

9924: khr.deal_type,
9925: khr.term_duration,
9926: NVL(khr.generate_accrual_yn, 'Y')
9927: FROM okc_k_headers_b chr,
9928: okl_k_headers khr
9929: WHERE khr.id = p_khr_id
9930: AND chr.id = khr.id;
9931:
9932: l_hdr c_hdr%ROWTYPE;