APPS.OKL_LEASE_QUOTE_FEE_PVT dependencies on OKL_FEES_B

Line 1974: cursor l_okl_fees_b(cp_id in number) IS

1970: l_p_code VARCHAR2(30);
1971:
1972:
1973: --sechawla 5-aug-2010 9962315 : begin
1974: cursor l_okl_fees_b(cp_id in number) IS
1975: select fee_purpose_code
1976: FROM okl_fees_b
1977: where id = cp_id;
1978: l_fee_purpose_code varchar2(100) ;

Line 1976: FROM okl_fees_b

1972:
1973: --sechawla 5-aug-2010 9962315 : begin
1974: cursor l_okl_fees_b(cp_id in number) IS
1975: select fee_purpose_code
1976: FROM okl_fees_b
1977: where id = cp_id;
1978: l_fee_purpose_code varchar2(100) ;
1979: --sechawla 5-aug-2010 9962315 : end
1980:

Line 1997: open l_okl_fees_b(l_fee_rec.id);

1993: l_expense_level_tbl := p_expense_level_tbl;
1994: l_expense_hdr_rec := p_expense_header_rec;
1995:
1996: --sechawla 5-aug-2010 9962315 : begin
1997: open l_okl_fees_b(l_fee_rec.id);
1998: fetch l_okl_fees_b into l_fee_purpose_code;
1999: close l_okl_fees_b;
2000:
2001: l_fee_rec.fee_purpose_code := l_fee_purpose_code;

Line 1998: fetch l_okl_fees_b into l_fee_purpose_code;

1994: l_expense_hdr_rec := p_expense_header_rec;
1995:
1996: --sechawla 5-aug-2010 9962315 : begin
1997: open l_okl_fees_b(l_fee_rec.id);
1998: fetch l_okl_fees_b into l_fee_purpose_code;
1999: close l_okl_fees_b;
2000:
2001: l_fee_rec.fee_purpose_code := l_fee_purpose_code;
2002: --sechawla 5-aug-2010 9962315 : end

Line 1999: close l_okl_fees_b;

1995:
1996: --sechawla 5-aug-2010 9962315 : begin
1997: open l_okl_fees_b(l_fee_rec.id);
1998: fetch l_okl_fees_b into l_fee_purpose_code;
1999: close l_okl_fees_b;
2000:
2001: l_fee_rec.fee_purpose_code := l_fee_purpose_code;
2002: --sechawla 5-aug-2010 9962315 : end
2003:

Line 2345: FROM OKL_FEES_B

2341: END IF;
2342:
2343: SELECT PARENT_OBJECT_ID
2344: INTO ln_target_quote_id
2345: FROM OKL_FEES_B
2346: WHERE ID = p_target_fee_id;
2347:
2348: -- Set the original asset id for the records
2349: IF (l_lrship_tbl.COUNT > 0) THEN

Line 2620: okl_fees_b fee,

2616: quote.product_id,
2617: quote.end_of_term_option_id
2618: INTO ld_src_start_date, ln_src_pdt_id, ln_src_eot_id
2619: FROM
2620: okl_fees_b fee,
2621: okl_lease_quotes_b quote
2622: WHERE
2623: fee.id = p_source_fee_id
2624: AND fee.parent_object_id = quote.id

Line 2755: SELECT fee_type INTO l_fee_type FROM okl_fees_b WHERE id = p_fee_id;

2751: IF p_init_msg_list = G_TRUE THEN
2752: FND_MSG_PUB.initialize;
2753: END IF;
2754:
2755: SELECT fee_type INTO l_fee_type FROM okl_fees_b WHERE id = p_fee_id;
2756:
2757: i := 0;
2758: FOR l_assoc_assets IN c_fee_sublines (p_fee_type => l_fee_type) LOOP
2759: l_assoc_asset_tbl(i).id := l_assoc_assets.id;

Line 2820: okl_fees_b fee

2816: /*
2817: SELECT qte.parent_object_id,qte.parent_object_code
2818: INTO l_p_id,l_p_code
2819: FROM okl_lease_quotes_b qte,
2820: okl_fees_b fee
2821: WHERE fee.parent_object_id = qte.id
2822: AND fee.parent_object_code= 'LEASEQUOTE'
2823: AND fee.ID = p_fee_id;
2824: OKL_LEASE_QUOTE_PRICING_PVT.handle_parent_object_status(