APPS.OKL_LA_PAYMENTS_PVT dependencies on OKC_LINE_STYLES_V

Line 548: RETURN OKC_LINE_STYLES_V.LTY_CODE%TYPE IS

544: -- l_out varchar2(25) := 'pym.out';
545:
546: FUNCTION get_lty_code(
547: p_rgp_id IN NUMBER)
548: RETURN OKC_LINE_STYLES_V.LTY_CODE%TYPE IS
549: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE := null;
550: cursor LINE_STYLE_CSR(P_RGP_ID IN NUMBER) is
551: SELECT LS.LTY_CODE
552: FROM

Line 549: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE := null;

545:
546: FUNCTION get_lty_code(
547: p_rgp_id IN NUMBER)
548: RETURN OKC_LINE_STYLES_V.LTY_CODE%TYPE IS
549: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE := null;
550: cursor LINE_STYLE_CSR(P_RGP_ID IN NUMBER) is
551: SELECT LS.LTY_CODE
552: FROM
553: OKC_RULE_GROUPS_V RG, OKL_K_LINES_V LN, OKC_LINE_STYLES_V LS

Line 553: OKC_RULE_GROUPS_V RG, OKL_K_LINES_V LN, OKC_LINE_STYLES_V LS

549: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE := null;
550: cursor LINE_STYLE_CSR(P_RGP_ID IN NUMBER) is
551: SELECT LS.LTY_CODE
552: FROM
553: OKC_RULE_GROUPS_V RG, OKL_K_LINES_V LN, OKC_LINE_STYLES_V LS
554: WHERE
555: RG.ID = P_RGP_ID AND
556: RG.CLE_ID = LN.ID AND
557: LN.ID = LS.ID;

Line 1418: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE := null;

1414:
1415: i NUMBER := 0;
1416: l_rulv_rec rulv_rec_type := p_rulv_rec;
1417: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
1418: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE := null;
1419:
1420: l_days boolean := false;
1421: l_days_amt boolean := false;
1422: l_period boolean := false;

Line 2164: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE := null;

2160: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2161: l_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;
2162:
2163: l_fee_line_type OKL_K_FEE_LINES_UV.FEE_TYPE%TYPE := null;
2164: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE := null;
2165: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
2166:
2167: --Bug# 13973475
2168: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

Line 2223: okc_line_styles_v sty,

2219: -- added for bug 5115701 - start
2220: CURSOR GET_FEE_TYPE_SUB_CSR(P_CHR_ID IN NUMBER, p_service_fee_id IN NUMBER) is
2221: SELECT fee_line.fee_type
2222: FROM okl_k_lines_full_v l,
2223: okc_line_styles_v sty,
2224: okc_statuses_v sts,
2225: okl_k_lines fee_line
2226: WHERE l.lse_id = sty.id
2227: AND l.sts_code = sts.code