DBA Data[Home] [Help]

APPS.OKL_PRICING_UTILS_PVT dependencies on OKL_LINE_RELATIONSHIPS_B

Line 8766: p_source_id OKL_LINE_RELATIONSHIPS_B.source_line_ID%TYPE,

8762: AND lq.id = p_lq_id;
8763: l_eot_type_code VARCHAR2(30);
8764: -- Cursor to handle the CAPITALIZED Fee amount for each Asset
8765: CURSOR get_asset_cap_fee_amt(p_source_type VARCHAR2,
8766: p_source_id OKL_LINE_RELATIONSHIPS_B.source_line_ID%TYPE,
8767: p_related_line_type OKL_LINE_RELATIONSHIPS_B.related_line_type%TYPE)
8768: IS
8769: SELECT SUM(amount) capitalized_amount
8770: FROM okl_line_relationships_v lre

Line 8767: p_related_line_type OKL_LINE_RELATIONSHIPS_B.related_line_type%TYPE)

8763: l_eot_type_code VARCHAR2(30);
8764: -- Cursor to handle the CAPITALIZED Fee amount for each Asset
8765: CURSOR get_asset_cap_fee_amt(p_source_type VARCHAR2,
8766: p_source_id OKL_LINE_RELATIONSHIPS_B.source_line_ID%TYPE,
8767: p_related_line_type OKL_LINE_RELATIONSHIPS_B.related_line_type%TYPE)
8768: IS
8769: SELECT SUM(amount) capitalized_amount
8770: FROM okl_line_relationships_v lre
8771: WHERE source_line_type = p_source_type

Line 10706: p_source_id OKL_LINE_RELATIONSHIPS_B.source_line_ID%TYPE,

10702: AND lq.id = p_lq_id;
10703: l_eot_type_code VARCHAR2(30);
10704: -- Cursor to handle the CAPITALIZED Fee amount for each Asset
10705: CURSOR get_asset_cap_fee_amt(p_source_type VARCHAR2,
10706: p_source_id OKL_LINE_RELATIONSHIPS_B.source_line_ID%TYPE,
10707: p_related_line_type OKL_LINE_RELATIONSHIPS_B.related_line_type%TYPE)
10708: IS
10709: SELECT SUM(amount) capitalized_amount
10710: FROM okl_line_relationships_v lre

Line 10707: p_related_line_type OKL_LINE_RELATIONSHIPS_B.related_line_type%TYPE)

10703: l_eot_type_code VARCHAR2(30);
10704: -- Cursor to handle the CAPITALIZED Fee amount for each Asset
10705: CURSOR get_asset_cap_fee_amt(p_source_type VARCHAR2,
10706: p_source_id OKL_LINE_RELATIONSHIPS_B.source_line_ID%TYPE,
10707: p_related_line_type OKL_LINE_RELATIONSHIPS_B.related_line_type%TYPE)
10708: IS
10709: SELECT SUM(amount) capitalized_amount
10710: FROM okl_line_relationships_v lre
10711: WHERE source_line_type = p_source_type