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 1330: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE := null;

1326:
1327: i NUMBER := 0;
1328: l_rulv_rec rulv_rec_type := p_rulv_rec;
1329: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
1330: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE := null;
1331:
1332: l_days boolean := false;
1333: l_days_amt boolean := false;
1334: l_period boolean := false;

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

1953: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1954: l_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;
1955:
1956: l_fee_line_type OKL_K_FEE_LINES_UV.FEE_TYPE%TYPE := null;
1957: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE := null;
1958: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
1959:
1960: ------------- temp
1961: Cursor get_dir is

Line 2012: okc_line_styles_v sty,

2008: -- added for bug 5115701 - start
2009: CURSOR GET_FEE_TYPE_SUB_CSR(P_CHR_ID IN NUMBER, p_service_fee_id IN NUMBER) is
2010: SELECT fee_line.fee_type
2011: FROM okl_k_lines_full_v l,
2012: okc_line_styles_v sty,
2013: okc_statuses_v sts,
2014: okl_k_lines fee_line
2015: WHERE l.lse_id = sty.id
2016: AND l.sts_code = sts.code