eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PRICING_UTILS_PVT dependencies on OKL_LINE_RELATIONSHIPS_B

Line 9106: p_source_id OKL_LINE_RELATIONSHIPS_B.source_line_ID%TYPE,

9102: AND lq.id = p_lq_id;
9103: l_eot_type_code VARCHAR2(30);
9104: -- Cursor to handle the CAPITALIZED Fee amount for each Asset
9105: CURSOR get_asset_cap_fee_amt(p_source_type VARCHAR2,
9106: p_source_id OKL_LINE_RELATIONSHIPS_B.source_line_ID%TYPE,
9107: p_related_line_type OKL_LINE_RELATIONSHIPS_B.related_line_type%TYPE)
9108: IS
9109: SELECT SUM(amount) capitalized_amount
9110: FROM okl_line_relationships_v lre

Line 9107: p_related_line_type OKL_LINE_RELATIONSHIPS_B.related_line_type%TYPE)

9103: l_eot_type_code VARCHAR2(30);
9104: -- Cursor to handle the CAPITALIZED Fee amount for each Asset
9105: CURSOR get_asset_cap_fee_amt(p_source_type VARCHAR2,
9106: p_source_id OKL_LINE_RELATIONSHIPS_B.source_line_ID%TYPE,
9107: p_related_line_type OKL_LINE_RELATIONSHIPS_B.related_line_type%TYPE)
9108: IS
9109: SELECT SUM(amount) capitalized_amount
9110: FROM okl_line_relationships_v lre
9111: WHERE source_line_type = p_source_type

Line 11700: p_source_id OKL_LINE_RELATIONSHIPS_B.source_line_ID%TYPE,

11696: AND lq.id = p_lq_id;
11697: l_eot_type_code VARCHAR2(30);
11698: -- Cursor to handle the CAPITALIZED Fee amount for each Asset
11699: CURSOR get_asset_cap_fee_amt(p_source_type VARCHAR2,
11700: p_source_id OKL_LINE_RELATIONSHIPS_B.source_line_ID%TYPE,
11701: p_related_line_type OKL_LINE_RELATIONSHIPS_B.related_line_type%TYPE)
11702: IS
11703: SELECT SUM(amount) capitalized_amount
11704: FROM okl_line_relationships_v lre

Line 11701: p_related_line_type OKL_LINE_RELATIONSHIPS_B.related_line_type%TYPE)

11697: l_eot_type_code VARCHAR2(30);
11698: -- Cursor to handle the CAPITALIZED Fee amount for each Asset
11699: CURSOR get_asset_cap_fee_amt(p_source_type VARCHAR2,
11700: p_source_id OKL_LINE_RELATIONSHIPS_B.source_line_ID%TYPE,
11701: p_related_line_type OKL_LINE_RELATIONSHIPS_B.related_line_type%TYPE)
11702: IS
11703: SELECT SUM(amount) capitalized_amount
11704: FROM okl_line_relationships_v lre
11705: WHERE source_line_type = p_source_type

Line 11812: P_FEE_SRVC_ID OKL_LINE_RELATIONSHIPS_B.RELATED_LINE_ID%TYPE) IS

11808: l_amount_tbl amount_tabtype;
11809:
11810: --Cursor to get the associated assets count and amount for Service Line
11811: CURSOR CHECK_ASSOC_ASSETS(P_LINE_TYPE VARCHAR2,
11812: P_FEE_SRVC_ID OKL_LINE_RELATIONSHIPS_B.RELATED_LINE_ID%TYPE) IS
11813: SELECT SUM(AMOUNT),
11814: COUNT(*)
11815: FROM OKL_LINE_RELATIONSHIPS_B
11816: WHERE SOURCE_LINE_TYPE = 'ASSET'

Line 11815: FROM OKL_LINE_RELATIONSHIPS_B

11811: CURSOR CHECK_ASSOC_ASSETS(P_LINE_TYPE VARCHAR2,
11812: P_FEE_SRVC_ID OKL_LINE_RELATIONSHIPS_B.RELATED_LINE_ID%TYPE) IS
11813: SELECT SUM(AMOUNT),
11814: COUNT(*)
11815: FROM OKL_LINE_RELATIONSHIPS_B
11816: WHERE SOURCE_LINE_TYPE = 'ASSET'
11817: AND RELATED_LINE_TYPE = P_LINE_TYPE
11818: AND RELATED_LINE_ID = P_FEE_SRVC_ID;
11819:

Line 11822: P_FEE_SRVC_ID OKL_LINE_RELATIONSHIPS_B.RELATED_LINE_ID%TYPE) IS

11818: AND RELATED_LINE_ID = P_FEE_SRVC_ID;
11819:
11820: --Cursor to get the Associated Asset ID and Amount for Service Line
11821: CURSOR GET_ASSOC_ASSETS(P_LINE_TYPE VARCHAR2,
11822: P_FEE_SRVC_ID OKL_LINE_RELATIONSHIPS_B.RELATED_LINE_ID%TYPE) IS
11823: SELECT SOURCE_LINE_ID,
11824: AMOUNT
11825: FROM OKL_LINE_RELATIONSHIPS_B
11826: WHERE SOURCE_LINE_TYPE = 'ASSET'

Line 11825: FROM OKL_LINE_RELATIONSHIPS_B

11821: CURSOR GET_ASSOC_ASSETS(P_LINE_TYPE VARCHAR2,
11822: P_FEE_SRVC_ID OKL_LINE_RELATIONSHIPS_B.RELATED_LINE_ID%TYPE) IS
11823: SELECT SOURCE_LINE_ID,
11824: AMOUNT
11825: FROM OKL_LINE_RELATIONSHIPS_B
11826: WHERE SOURCE_LINE_TYPE = 'ASSET'
11827: AND RELATED_LINE_TYPE = P_LINE_TYPE
11828: AND RELATED_LINE_ID = P_FEE_SRVC_ID;
11829: