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_LA_PAYMENTS_PVT dependencies on OKC_K_LINES_B

Line 222: okc_k_lines_b cle

218: SELECT 'Y'
219: FROM okc_rule_groups_b rgp,
220: okc_rules_b rul,
221: okl_strm_type_b sty,
222: okc_k_lines_b cle
223: WHERE rgp.rgd_code = 'LALEVL'
224: AND rgp.dnz_chr_id = p_chr_id
225: AND rul.dnz_chr_id = rgp.dnz_chr_id
226: AND rul.rgp_id = rgp.id

Line 700: OKC_K_LINES_B.ID%TYPE) RETURN BOOLEAN IS

696: -- Called By:
697: ------------------------------------------------------------------------------
698:
699: FUNCTION is_rollover_fee_payment(p_service_or_fee_id IN
700: OKC_K_LINES_B.ID%TYPE) RETURN BOOLEAN IS
701:
702: l_fee_type VARCHAR2(150) := NULL;
703: CURSOR fee_type_csr(P_ID IN OKC_K_LINES_B.ID%TYPE) IS
704: SELECT FEE_TYPE FROM okc_k_lines_b CLEB, okl_k_lines KLE

Line 703: CURSOR fee_type_csr(P_ID IN OKC_K_LINES_B.ID%TYPE) IS

699: FUNCTION is_rollover_fee_payment(p_service_or_fee_id IN
700: OKC_K_LINES_B.ID%TYPE) RETURN BOOLEAN IS
701:
702: l_fee_type VARCHAR2(150) := NULL;
703: CURSOR fee_type_csr(P_ID IN OKC_K_LINES_B.ID%TYPE) IS
704: SELECT FEE_TYPE FROM okc_k_lines_b CLEB, okl_k_lines KLE
705: WHERE KLE.ID = P_ID
706: AND KLE.ID = CLEB.ID;
707:

Line 704: SELECT FEE_TYPE FROM okc_k_lines_b CLEB, okl_k_lines KLE

700: OKC_K_LINES_B.ID%TYPE) RETURN BOOLEAN IS
701:
702: l_fee_type VARCHAR2(150) := NULL;
703: CURSOR fee_type_csr(P_ID IN OKC_K_LINES_B.ID%TYPE) IS
704: SELECT FEE_TYPE FROM okc_k_lines_b CLEB, okl_k_lines KLE
705: WHERE KLE.ID = P_ID
706: AND KLE.ID = CLEB.ID;
707:
708: BEGIN

Line 734: OKC_K_LINES_B.ID%TYPE) RETURN BOOLEAN IS

730: -- Called By:
731: ------------------------------------------------------------------------------
732:
733: FUNCTION is_eligible_fee_payment(p_service_or_fee_id IN
734: OKC_K_LINES_B.ID%TYPE) RETURN BOOLEAN IS
735:
736: l_fee_type VARCHAR2(150) := NULL;
737: CURSOR fee_type_csr(P_ID IN OKC_K_LINES_B.ID%TYPE) IS
738: SELECT FEE_TYPE FROM okl_k_lines KLE

Line 737: CURSOR fee_type_csr(P_ID IN OKC_K_LINES_B.ID%TYPE) IS

733: FUNCTION is_eligible_fee_payment(p_service_or_fee_id IN
734: OKC_K_LINES_B.ID%TYPE) RETURN BOOLEAN IS
735:
736: l_fee_type VARCHAR2(150) := NULL;
737: CURSOR fee_type_csr(P_ID IN OKC_K_LINES_B.ID%TYPE) IS
738: SELECT FEE_TYPE FROM okl_k_lines KLE
739: WHERE KLE.ID = P_ID;
740:
741: BEGIN

Line 765: l_cle_id OKC_K_LINES_B.ID%TYPE := p_cle_id;

761: p_rgp_id IN NUMBER := NULL )
762: RETURN DATE IS
763:
764: l_chr_id OKC_K_HEADERS_B.ID%TYPE := p_chr_id;
765: l_cle_id OKC_K_LINES_B.ID%TYPE := p_cle_id;
766: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE := p_rgp_id;
767:
768: l_start_date date;
769:

Line 780: OKC_K_LINES_B

776:
777: cursor CLE_CSR(P_ID IN NUMBER) is
778: SELECT START_DATE
779: FROM
780: OKC_K_LINES_B
781: WHERE
782: ID = P_ID;
783:
784: cursor RGP_CSR(P_ID IN NUMBER) is

Line 829: l_cle_id OKC_K_LINES_B.ID%TYPE := NULL;

825: FUNCTION get_line_end_date(p_rgp_id IN NUMBER )
826: RETURN DATE
827: IS
828: l_chr_id OKC_K_HEADERS_B.ID%TYPE := NULL;
829: l_cle_id OKC_K_LINES_B.ID%TYPE := NULL;
830: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE := p_rgp_id;
831:
832: l_line_end_date date;
833:

Line 841: from okc_k_lines_b

837: where id = p_id;
838:
839: cursor cle_csr(p_id in number) is
840: select end_date
841: from okc_k_lines_b
842: where id = p_id;
843:
844: cursor rgp_csr(p_id in number) is
845: select dnz_chr_id, cle_id

Line 1531: RETURN OKC_K_LINES_B.ID%TYPE IS

1527: FUNCTION get_subline_id(
1528: p_chr_id IN NUMBER,
1529: p_topline_id IN NUMBER,
1530: p_asset_id IN NUMBER)
1531: RETURN OKC_K_LINES_B.ID%TYPE IS
1532:
1533: l_subline_id OKC_K_LINES_B.ID%TYPE := null;
1534: l_lty_code OKC_LINE_STYLES_b.LTY_CODE%TYPE := null;
1535:

Line 1533: l_subline_id OKC_K_LINES_B.ID%TYPE := null;

1529: p_topline_id IN NUMBER,
1530: p_asset_id IN NUMBER)
1531: RETURN OKC_K_LINES_B.ID%TYPE IS
1532:
1533: l_subline_id OKC_K_LINES_B.ID%TYPE := null;
1534: l_lty_code OKC_LINE_STYLES_b.LTY_CODE%TYPE := null;
1535:
1536: cursor LTY_CODE_CSR(P_LINE_ID IN NUMBER) is
1537: SELECT LTY_CODE

Line 1539: OKC_LINE_STYLES_B LS, OKC_K_LINES_B L

1535:
1536: cursor LTY_CODE_CSR(P_LINE_ID IN NUMBER) is
1537: SELECT LTY_CODE
1538: FROM
1539: OKC_LINE_STYLES_B LS, OKC_K_LINES_B L
1540: WHERE LS.ID = L.LSE_ID AND L.ID = P_LINE_ID;
1541:
1542: cursor SERVICES_CSR(P_CHR_ID IN NUMBER, P_TOPLINE_ID IN NUMBER, P_ASSET_ID IN NUMBER) is
1543: SELECT KLINES1.ID

Line 1544: FROM OKL_PYMTS_SERVICE_INSTS_UV SFINTS,OKC_K_LINES_B KLINES,

1540: WHERE LS.ID = L.LSE_ID AND L.ID = P_LINE_ID;
1541:
1542: cursor SERVICES_CSR(P_CHR_ID IN NUMBER, P_TOPLINE_ID IN NUMBER, P_ASSET_ID IN NUMBER) is
1543: SELECT KLINES1.ID
1544: FROM OKL_PYMTS_SERVICE_INSTS_UV SFINTS,OKC_K_LINES_B KLINES,
1545: OKC_K_LINES_B KLINES1, OKC_LINE_STYLES_B LS, OKC_K_ITEMS KITMS
1546: WHERE KLINES.ID = SFINTS.LINE_ID
1547: AND KLINES.ID = KLINES1.CLE_ID
1548: AND KLINES1.LSE_ID = LS.ID AND LS.LTY_CODE = 'LINK_SERV_ASSET'

Line 1545: OKC_K_LINES_B KLINES1, OKC_LINE_STYLES_B LS, OKC_K_ITEMS KITMS

1541:
1542: cursor SERVICES_CSR(P_CHR_ID IN NUMBER, P_TOPLINE_ID IN NUMBER, P_ASSET_ID IN NUMBER) is
1543: SELECT KLINES1.ID
1544: FROM OKL_PYMTS_SERVICE_INSTS_UV SFINTS,OKC_K_LINES_B KLINES,
1545: OKC_K_LINES_B KLINES1, OKC_LINE_STYLES_B LS, OKC_K_ITEMS KITMS
1546: WHERE KLINES.ID = SFINTS.LINE_ID
1547: AND KLINES.ID = KLINES1.CLE_ID
1548: AND KLINES1.LSE_ID = LS.ID AND LS.LTY_CODE = 'LINK_SERV_ASSET'
1549: AND KITMS.CLE_ID = KLINES1.ID AND KITMS.JTOT_OBJECT1_CODE='OKX_COVASST'

Line 1556: FROM OKL_PYMTS_FEE_INSTS_UV SFINTS,OKC_K_LINES_B KLINES,

1552:
1553:
1554: cursor FEES_CSR(P_CHR_ID IN NUMBER, P_TOPLINE_ID IN NUMBER, P_ASSET_ID IN NUMBER) is
1555: SELECT KLINES1.ID
1556: FROM OKL_PYMTS_FEE_INSTS_UV SFINTS,OKC_K_LINES_B KLINES,
1557: OKC_K_LINES_B KLINES1, OKC_LINE_STYLES_B LS, OKC_K_ITEMS KITMS
1558: WHERE KLINES.ID = SFINTS.LINE_ID
1559: AND KLINES.ID = KLINES1.CLE_ID
1560: AND KLINES1.LSE_ID = LS.ID AND LS.LTY_CODE = 'LINK_FEE_ASSET'

Line 1557: OKC_K_LINES_B KLINES1, OKC_LINE_STYLES_B LS, OKC_K_ITEMS KITMS

1553:
1554: cursor FEES_CSR(P_CHR_ID IN NUMBER, P_TOPLINE_ID IN NUMBER, P_ASSET_ID IN NUMBER) is
1555: SELECT KLINES1.ID
1556: FROM OKL_PYMTS_FEE_INSTS_UV SFINTS,OKC_K_LINES_B KLINES,
1557: OKC_K_LINES_B KLINES1, OKC_LINE_STYLES_B LS, OKC_K_ITEMS KITMS
1558: WHERE KLINES.ID = SFINTS.LINE_ID
1559: AND KLINES.ID = KLINES1.CLE_ID
1560: AND KLINES1.LSE_ID = LS.ID AND LS.LTY_CODE = 'LINK_FEE_ASSET'
1561: AND KITMS.CLE_ID = KLINES1.ID AND KITMS.JTOT_OBJECT1_CODE='OKX_COVASST'

Line 1670: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,

1666: x_return_status OUT NOCOPY VARCHAR2,
1667: x_msg_count OUT NOCOPY NUMBER,
1668: x_msg_data OUT NOCOPY VARCHAR2,
1669: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
1670: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1671: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1672: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
1673: x_pym_level OUT NOCOPY VARCHAR2,
1674: x_slh_id OUT NOCOPY OKC_RULES_V.ID%TYPE,

Line 1671: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,

1667: x_msg_count OUT NOCOPY NUMBER,
1668: x_msg_data OUT NOCOPY VARCHAR2,
1669: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
1670: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1671: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1672: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
1673: x_pym_level OUT NOCOPY VARCHAR2,
1674: x_slh_id OUT NOCOPY OKC_RULES_V.ID%TYPE,
1675: x_rgp_id OUT NOCOPY OKC_RULE_GROUPS_V.ID%TYPE,

Line 1676: x_cle_id OUT NOCOPY OKC_K_LINES_B.ID%TYPE) IS

1672: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
1673: x_pym_level OUT NOCOPY VARCHAR2,
1674: x_slh_id OUT NOCOPY OKC_RULES_V.ID%TYPE,
1675: x_rgp_id OUT NOCOPY OKC_RULE_GROUPS_V.ID%TYPE,
1676: x_cle_id OUT NOCOPY OKC_K_LINES_B.ID%TYPE) IS
1677:
1678: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1679: l_api_name CONSTANT VARCHAR2(30) := 'GET_PAYMENT';
1680: l_api_version CONSTANT NUMBER := 1.0;

Line 1683: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;

1679: l_api_name CONSTANT VARCHAR2(30) := 'GET_PAYMENT';
1680: l_api_version CONSTANT NUMBER := 1.0;
1681:
1682: l_pym_level VARCHAR2(30) := 'HEADER';
1683: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1684: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
1685: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
1686: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1687:

Line 1686: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;

1682: l_pym_level VARCHAR2(30) := 'HEADER';
1683: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1684: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
1685: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
1686: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1687:
1688: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
1689:
1690: ------------- temp

Line 1857: FROM okc_k_lines_b cleb,

1853: FROM OKC_K_HEADERS_B
1854: WHERE ID = p_chr_id ;
1855: CURSOR fee_line_amount_csr(p_rgp_id IN NUMBER) is
1856: SELECT kleb.amount amount
1857: FROM okc_k_lines_b cleb,
1858: okl_k_lines kleb,
1859: okc_line_styles_b lseb,
1860: okc_k_headers_b chrb,
1861: okc_rule_groups_b rg

Line 1913: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,

1909: x_return_status OUT NOCOPY VARCHAR2,
1910: x_msg_count OUT NOCOPY NUMBER,
1911: x_msg_data OUT NOCOPY VARCHAR2,
1912: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
1913: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1914: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1915: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
1916: p_pym_hdr_rec IN pym_hdr_rec_type,
1917: p_pym_tbl IN pym_tbl_type,

Line 1914: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,

1910: x_msg_count OUT NOCOPY NUMBER,
1911: x_msg_data OUT NOCOPY VARCHAR2,
1912: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
1913: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1914: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1915: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
1916: p_pym_hdr_rec IN pym_hdr_rec_type,
1917: p_pym_tbl IN pym_tbl_type,
1918: p_update_type IN VARCHAR2,

Line 1950: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;

1946: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type := NULL;
1947: lx_rgpv_rec OKL_RULE_PUB.rgpv_rec_type := NULL;
1948:
1949: l_pym_level VARCHAR2(30) := 'HEADER';
1950: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1951: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
1952: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
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;

Line 1953: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;

1949: l_pym_level VARCHAR2(30) := 'HEADER';
1950: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1951: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
1952: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
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;

Line 1988: FROM okc_k_lines_b cleb,

1984:
1985: --Changed query for performance --dkagrawa
1986: CURSOR FEE_LINE_CSR(P_RGP_ID IN NUMBER) is
1987: SELECT kleb.fee_type fee_type
1988: FROM okc_k_lines_b cleb,
1989: okl_k_lines kleb,
1990: okc_line_styles_b lseb,
1991: okc_k_headers_b chrb,
1992: okc_rule_groups_b rg

Line 2003: FROM OKC_STATUSES_V OKCS, OKC_K_LINES_B CLE

1999:
2000:
2001: CURSOR INVALID_LINE_CSR(P_CLE_ID IN NUMBER) is
2002: SELECT 'Y'
2003: FROM OKC_STATUSES_V OKCS, OKC_K_LINES_B CLE
2004: WHERE CLE.STS_CODE = OKCS.CODE
2005: -- AND OKCS.STE_CODE IN ('EXPIRED','HOLD','CANCELLED','TERMINATED')
2006: AND OKCS.STE_CODE IN ('TERMINATED')
2007: AND CLE.ID = P_CLE_ID;

Line 2566: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;

2562:
2563: l_pym_level VARCHAR2(30) := 'HEADER';
2564: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2565: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2566: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2567:
2568: -- x_return_status varchar2(1);
2569: x_primary_sty_id okl_strm_type_b.ID%TYPE;
2570:

Line 2794: p_service_fee_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,

2790: x_return_status OUT NOCOPY VARCHAR2,
2791: x_msg_count OUT NOCOPY NUMBER,
2792: x_msg_data OUT NOCOPY VARCHAR2,
2793: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
2794: p_service_fee_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
2795: p_asset_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
2796: p_payment_id IN OKL_STRMTYP_SOURCE_V.ID1%TYPE,
2797: p_update_type IN VARCHAR2,
2798: x_rulv_tbl OUT NOCOPY rulv_tbl_type) IS

Line 2795: p_asset_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,

2791: x_msg_count OUT NOCOPY NUMBER,
2792: x_msg_data OUT NOCOPY VARCHAR2,
2793: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
2794: p_service_fee_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
2795: p_asset_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
2796: p_payment_id IN OKL_STRMTYP_SOURCE_V.ID1%TYPE,
2797: p_update_type IN VARCHAR2,
2798: x_rulv_tbl OUT NOCOPY rulv_tbl_type) IS
2799:

Line 2805: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;

2801: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_PAYMENT2';
2802: l_api_version CONSTANT NUMBER := 1.0;
2803:
2804: l_pym_level VARCHAR2(30) := 'HEADER';
2805: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2806: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2807: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2808: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2809: l_stream_id OKL_STRMTYP_SOURCE_V.ID1%TYPE := OKL_API.G_MISS_NUM;

Line 2808: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;

2804: l_pym_level VARCHAR2(30) := 'HEADER';
2805: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2806: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2807: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2808: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2809: l_stream_id OKL_STRMTYP_SOURCE_V.ID1%TYPE := OKL_API.G_MISS_NUM;
2810:
2811: lx_rulv_tbl rulv_tbl_type;
2812:

Line 3185: okc_k_lines_b cleb

3181: CURSOR l_pymt_cle_csr(p_rgp_id IN NUMBER) IS
3182: SELECT rgp.cle_id pymt_cle_id,
3183: cleb.cle_id parent_cle_id
3184: FROM okc_rule_groups_b rgp,
3185: okc_k_lines_b cleb
3186: WHERE rgp.id = p_rgp_id
3187: AND cleb.id = rgp.cle_id;
3188:
3189: l_pymt_cle_rec l_pymt_cle_csr%ROWTYPE;

Line 3190: l_cle_id OKC_K_LINES_B.id%TYPE;

3186: WHERE rgp.id = p_rgp_id
3187: AND cleb.id = rgp.cle_id;
3188:
3189: l_pymt_cle_rec l_pymt_cle_csr%ROWTYPE;
3190: l_cle_id OKC_K_LINES_B.id%TYPE;
3191: l_chr_id OKC_K_HEADERS_B.id%TYPE;
3192:
3193: begin
3194:

Line 3394: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;

3390:
3391: l_pym_level VARCHAR2(30) := 'HEADER';
3392: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
3393: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
3394: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3395:
3396: x_primary_sty_id okl_strm_type_b.ID%TYPE;
3397:
3398: l_deal_type OKL_K_HEADERS.deal_type%TYPE;

Line 3640: okc_k_lines_b cle,

3636: slh.id rul_laslh_id,
3637: rgp.cle_id
3638: FROM okc_rule_groups_b rgp,
3639: okc_rules_b slh,
3640: okc_k_lines_b cle,
3641: okc_statuses_b sts
3642: WHERE rgp.dnz_chr_id = p_chr_id
3643: AND rgp.rgd_code = 'LALEVL'
3644: AND slh.rgp_id = rgp.id

Line 3658: okc_k_lines_b cle,

3654: slh.id rul_laslh_id,
3655: rgp.cle_id
3656: FROM okc_rule_groups_b rgp,
3657: okc_rules_b slh,
3658: okc_k_lines_b cle,
3659: okc_statuses_b sts
3660: WHERE rgp.dnz_chr_id = p_chr_id
3661: AND (rgp.cle_id = p_cle_id OR
3662: rgp.cle_id IN (SELECT cle_sub.id

Line 3663: FROM okc_k_lines_b cle_sub

3659: okc_statuses_b sts
3660: WHERE rgp.dnz_chr_id = p_chr_id
3661: AND (rgp.cle_id = p_cle_id OR
3662: rgp.cle_id IN (SELECT cle_sub.id
3663: FROM okc_k_lines_b cle_sub
3664: WHERE cle_sub.cle_id = p_cle_id
3665: AND cle_sub.dnz_chr_id = p_chr_id))
3666: AND rgp.rgd_code = 'LALEVL'
3667: AND slh.rgp_id = rgp.id