DBA Data[Home] [Help]

APPS.OKL_FUNDING_PVT dependencies on OKL_K_LINES_FULL_V

Line 2309: from OKL_K_LINES_FULL_V cle,

2305: IS
2306: select nvl(cle.AMOUNT,0),
2307: cle.id,
2308: nvl(cle.start_date,k.start_date)
2309: from OKL_K_LINES_FULL_V cle,
2310: okc_k_party_roles_b cpl,
2311: okc_line_styles_b ls,
2312: okc_k_headers_b k
2313: where k.id = cle.dnz_chr_id

Line 2357: OKL_K_LINES_FULL_V cle,

2353: --cklee end 10/3/2007 bug: 6128765
2354:
2355: from okc_rule_groups_v crg,
2356: okc_rules_v cr,
2357: OKL_K_LINES_FULL_V cle,
2358: okc_k_headers_b k
2359: where crg.dnz_chr_id = p_contract_id
2360: and cle.dnz_chr_id = k.id
2361: and crg.id = cr.rgp_id

Line 2547: from OKL_K_LINES_FULL_V cle,

2543: IS
2544: select nvl(cle.AMOUNT,0),
2545: cle.id,
2546: nvl(cle.start_date,k.start_date)
2547: from OKL_K_LINES_FULL_V cle,
2548: okc_k_party_roles_b cpl,
2549: okc_line_styles_b ls,
2550: okc_k_headers_b k
2551: where k.id = cle.dnz_chr_id

Line 2594: OKL_K_LINES_FULL_V cle,

2590: , months_between(trunc(p_due_date), nvl(cle.start_date, k.start_date))))
2591: --cklee end 10/3/2007 bug: 6128765
2592: from okc_rule_groups_v crg,
2593: okc_rules_v cr,
2594: OKL_K_LINES_FULL_V cle,
2595: okc_k_headers_b k
2596: where crg.dnz_chr_id = p_contract_id
2597: and cle.dnz_chr_id = k.id
2598: and crg.id = cr.rgp_id

Line 8474: from OKL_K_LINES_FULL_V cle,

8470: IS
8471: select nvl(cle.AMOUNT,0),
8472: cle.id,
8473: nvl(cle.start_date,k.start_date)
8474: from OKL_K_LINES_FULL_V cle,
8475: okc_k_party_roles_b cpl,
8476: okc_line_styles_b ls,
8477: okc_k_headers_b k
8478: where k.id = cle.dnz_chr_id

Line 8517: OKL_K_LINES_FULL_V cle,

8513: , 'S', months_between(p_effective_date, nvl(cle.start_date, k.start_date))/6
8514: , months_between(p_effective_date, nvl(cle.start_date, k.start_date))))
8515: from okc_rule_groups_v crg,
8516: okc_rules_v cr,
8517: OKL_K_LINES_FULL_V cle,
8518: okc_k_headers_b k
8519: where crg.dnz_chr_id = p_contract_id
8520: and cle.dnz_chr_id = k.id
8521: and crg.id = cr.rgp_id