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 726: OKC_K_LINES_B.ID%TYPE) RETURN BOOLEAN IS

722: -- Called By:
723: ------------------------------------------------------------------------------
724:
725: FUNCTION is_rollover_fee_payment(p_service_or_fee_id IN
726: OKC_K_LINES_B.ID%TYPE) RETURN BOOLEAN IS
727:
728: l_fee_type VARCHAR2(150) := NULL;
729: CURSOR fee_type_csr(P_ID IN OKC_K_LINES_B.ID%TYPE) IS
730: SELECT FEE_TYPE FROM okc_k_lines_b CLEB, okl_k_lines KLE

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

725: FUNCTION is_rollover_fee_payment(p_service_or_fee_id IN
726: OKC_K_LINES_B.ID%TYPE) RETURN BOOLEAN IS
727:
728: l_fee_type VARCHAR2(150) := NULL;
729: CURSOR fee_type_csr(P_ID IN OKC_K_LINES_B.ID%TYPE) IS
730: SELECT FEE_TYPE FROM okc_k_lines_b CLEB, okl_k_lines KLE
731: WHERE KLE.ID = P_ID
732: AND KLE.ID = CLEB.ID;
733:

Line 730: SELECT FEE_TYPE FROM okc_k_lines_b CLEB, okl_k_lines KLE

726: OKC_K_LINES_B.ID%TYPE) RETURN BOOLEAN IS
727:
728: l_fee_type VARCHAR2(150) := NULL;
729: CURSOR fee_type_csr(P_ID IN OKC_K_LINES_B.ID%TYPE) IS
730: SELECT FEE_TYPE FROM okc_k_lines_b CLEB, okl_k_lines KLE
731: WHERE KLE.ID = P_ID
732: AND KLE.ID = CLEB.ID;
733:
734: BEGIN

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

756: -- Called By:
757: ------------------------------------------------------------------------------
758:
759: FUNCTION is_eligible_fee_payment(p_service_or_fee_id IN
760: OKC_K_LINES_B.ID%TYPE) RETURN BOOLEAN IS
761:
762: l_fee_type VARCHAR2(150) := NULL;
763: CURSOR fee_type_csr(P_ID IN OKC_K_LINES_B.ID%TYPE) IS
764: SELECT FEE_TYPE FROM okl_k_lines KLE

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

759: FUNCTION is_eligible_fee_payment(p_service_or_fee_id IN
760: OKC_K_LINES_B.ID%TYPE) RETURN BOOLEAN IS
761:
762: l_fee_type VARCHAR2(150) := NULL;
763: CURSOR fee_type_csr(P_ID IN OKC_K_LINES_B.ID%TYPE) IS
764: SELECT FEE_TYPE FROM okl_k_lines KLE
765: WHERE KLE.ID = P_ID;
766:
767: BEGIN

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

787: p_rgp_id IN NUMBER := NULL )
788: RETURN DATE IS
789:
790: l_chr_id OKC_K_HEADERS_B.ID%TYPE := p_chr_id;
791: l_cle_id OKC_K_LINES_B.ID%TYPE := p_cle_id;
792: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE := p_rgp_id;
793:
794: l_start_date date;
795:

Line 806: OKC_K_LINES_B

802:
803: cursor CLE_CSR(P_ID IN NUMBER) is
804: SELECT START_DATE
805: FROM
806: OKC_K_LINES_B
807: WHERE
808: ID = P_ID;
809:
810: cursor RGP_CSR(P_ID IN NUMBER) is

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

851: FUNCTION get_line_end_date(p_rgp_id IN NUMBER )
852: RETURN DATE
853: IS
854: l_chr_id OKC_K_HEADERS_B.ID%TYPE := NULL;
855: l_cle_id OKC_K_LINES_B.ID%TYPE := NULL;
856: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE := p_rgp_id;
857:
858: l_line_end_date date;
859:

Line 867: from okc_k_lines_b

863: where id = p_id;
864:
865: cursor cle_csr(p_id in number) is
866: select end_date
867: from okc_k_lines_b
868: where id = p_id;
869:
870: cursor rgp_csr(p_id in number) is
871: select dnz_chr_id, cle_id

Line 1619: RETURN OKC_K_LINES_B.ID%TYPE IS

1615: FUNCTION get_subline_id(
1616: p_chr_id IN NUMBER,
1617: p_topline_id IN NUMBER,
1618: p_asset_id IN NUMBER)
1619: RETURN OKC_K_LINES_B.ID%TYPE IS
1620:
1621: l_subline_id OKC_K_LINES_B.ID%TYPE := null;
1622: l_lty_code OKC_LINE_STYLES_b.LTY_CODE%TYPE := null;
1623:

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

1617: p_topline_id IN NUMBER,
1618: p_asset_id IN NUMBER)
1619: RETURN OKC_K_LINES_B.ID%TYPE IS
1620:
1621: l_subline_id OKC_K_LINES_B.ID%TYPE := null;
1622: l_lty_code OKC_LINE_STYLES_b.LTY_CODE%TYPE := null;
1623:
1624: cursor LTY_CODE_CSR(P_LINE_ID IN NUMBER) is
1625: SELECT LTY_CODE

Line 1627: OKC_LINE_STYLES_B LS, OKC_K_LINES_B L

1623:
1624: cursor LTY_CODE_CSR(P_LINE_ID IN NUMBER) is
1625: SELECT LTY_CODE
1626: FROM
1627: OKC_LINE_STYLES_B LS, OKC_K_LINES_B L
1628: WHERE LS.ID = L.LSE_ID AND L.ID = P_LINE_ID;
1629:
1630: cursor SERVICES_CSR(P_CHR_ID IN NUMBER, P_TOPLINE_ID IN NUMBER, P_ASSET_ID IN NUMBER) is
1631: SELECT KLINES1.ID

Line 1632: FROM OKL_PYMTS_SERVICE_INSTS_UV SFINTS,OKC_K_LINES_B KLINES,

1628: WHERE LS.ID = L.LSE_ID AND L.ID = P_LINE_ID;
1629:
1630: cursor SERVICES_CSR(P_CHR_ID IN NUMBER, P_TOPLINE_ID IN NUMBER, P_ASSET_ID IN NUMBER) is
1631: SELECT KLINES1.ID
1632: FROM OKL_PYMTS_SERVICE_INSTS_UV SFINTS,OKC_K_LINES_B KLINES,
1633: OKC_K_LINES_B KLINES1, OKC_LINE_STYLES_B LS, OKC_K_ITEMS KITMS
1634: WHERE KLINES.ID = SFINTS.LINE_ID
1635: AND KLINES.ID = KLINES1.CLE_ID
1636: AND KLINES1.LSE_ID = LS.ID AND LS.LTY_CODE = 'LINK_SERV_ASSET'

Line 1633: OKC_K_LINES_B KLINES1, OKC_LINE_STYLES_B LS, OKC_K_ITEMS KITMS

1629:
1630: cursor SERVICES_CSR(P_CHR_ID IN NUMBER, P_TOPLINE_ID IN NUMBER, P_ASSET_ID IN NUMBER) is
1631: SELECT KLINES1.ID
1632: FROM OKL_PYMTS_SERVICE_INSTS_UV SFINTS,OKC_K_LINES_B KLINES,
1633: OKC_K_LINES_B KLINES1, OKC_LINE_STYLES_B LS, OKC_K_ITEMS KITMS
1634: WHERE KLINES.ID = SFINTS.LINE_ID
1635: AND KLINES.ID = KLINES1.CLE_ID
1636: AND KLINES1.LSE_ID = LS.ID AND LS.LTY_CODE = 'LINK_SERV_ASSET'
1637: AND KITMS.CLE_ID = KLINES1.ID AND KITMS.JTOT_OBJECT1_CODE='OKX_COVASST'

Line 1644: FROM OKL_PYMTS_FEE_INSTS_UV SFINTS,OKC_K_LINES_B KLINES,

1640:
1641:
1642: cursor FEES_CSR(P_CHR_ID IN NUMBER, P_TOPLINE_ID IN NUMBER, P_ASSET_ID IN NUMBER) is
1643: SELECT KLINES1.ID
1644: FROM OKL_PYMTS_FEE_INSTS_UV SFINTS,OKC_K_LINES_B KLINES,
1645: OKC_K_LINES_B KLINES1, OKC_LINE_STYLES_B LS, OKC_K_ITEMS KITMS
1646: WHERE KLINES.ID = SFINTS.LINE_ID
1647: AND KLINES.ID = KLINES1.CLE_ID
1648: AND KLINES1.LSE_ID = LS.ID AND LS.LTY_CODE = 'LINK_FEE_ASSET'

Line 1645: OKC_K_LINES_B KLINES1, OKC_LINE_STYLES_B LS, OKC_K_ITEMS KITMS

1641:
1642: cursor FEES_CSR(P_CHR_ID IN NUMBER, P_TOPLINE_ID IN NUMBER, P_ASSET_ID IN NUMBER) is
1643: SELECT KLINES1.ID
1644: FROM OKL_PYMTS_FEE_INSTS_UV SFINTS,OKC_K_LINES_B KLINES,
1645: OKC_K_LINES_B KLINES1, OKC_LINE_STYLES_B LS, OKC_K_ITEMS KITMS
1646: WHERE KLINES.ID = SFINTS.LINE_ID
1647: AND KLINES.ID = KLINES1.CLE_ID
1648: AND KLINES1.LSE_ID = LS.ID AND LS.LTY_CODE = 'LINK_FEE_ASSET'
1649: AND KITMS.CLE_ID = KLINES1.ID AND KITMS.JTOT_OBJECT1_CODE='OKX_COVASST'

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

1873: x_return_status OUT NOCOPY VARCHAR2,
1874: x_msg_count OUT NOCOPY NUMBER,
1875: x_msg_data OUT NOCOPY VARCHAR2,
1876: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
1877: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1878: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1879: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
1880: x_pym_level OUT NOCOPY VARCHAR2,
1881: x_slh_id OUT NOCOPY OKC_RULES_V.ID%TYPE,

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

1874: x_msg_count OUT NOCOPY NUMBER,
1875: x_msg_data OUT NOCOPY VARCHAR2,
1876: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
1877: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1878: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1879: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
1880: x_pym_level OUT NOCOPY VARCHAR2,
1881: x_slh_id OUT NOCOPY OKC_RULES_V.ID%TYPE,
1882: x_rgp_id OUT NOCOPY OKC_RULE_GROUPS_V.ID%TYPE,

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

1879: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
1880: x_pym_level OUT NOCOPY VARCHAR2,
1881: x_slh_id OUT NOCOPY OKC_RULES_V.ID%TYPE,
1882: x_rgp_id OUT NOCOPY OKC_RULE_GROUPS_V.ID%TYPE,
1883: x_cle_id OUT NOCOPY OKC_K_LINES_B.ID%TYPE) IS
1884:
1885: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1886: l_api_name CONSTANT VARCHAR2(30) := 'GET_PAYMENT';
1887: l_api_version CONSTANT NUMBER := 1.0;

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

1886: l_api_name CONSTANT VARCHAR2(30) := 'GET_PAYMENT';
1887: l_api_version CONSTANT NUMBER := 1.0;
1888:
1889: l_pym_level VARCHAR2(30) := 'HEADER';
1890: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1891: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
1892: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
1893: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1894:

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

1889: l_pym_level VARCHAR2(30) := 'HEADER';
1890: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1891: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
1892: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
1893: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1894:
1895: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
1896:
1897: ------------- temp

Line 2064: FROM okc_k_lines_b cleb,

2060: FROM OKC_K_HEADERS_B
2061: WHERE ID = p_chr_id ;
2062: CURSOR fee_line_amount_csr(p_rgp_id IN NUMBER) is
2063: SELECT kleb.amount amount
2064: FROM okc_k_lines_b cleb,
2065: okl_k_lines kleb,
2066: okc_line_styles_b lseb,
2067: okc_k_headers_b chrb,
2068: okc_rule_groups_b rg

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

2116: x_return_status OUT NOCOPY VARCHAR2,
2117: x_msg_count OUT NOCOPY NUMBER,
2118: x_msg_data OUT NOCOPY VARCHAR2,
2119: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
2120: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
2121: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
2122: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
2123: p_pym_hdr_rec IN pym_hdr_rec_type,
2124: p_pym_tbl IN pym_tbl_type,

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

2117: x_msg_count OUT NOCOPY NUMBER,
2118: x_msg_data OUT NOCOPY VARCHAR2,
2119: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
2120: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
2121: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
2122: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
2123: p_pym_hdr_rec IN pym_hdr_rec_type,
2124: p_pym_tbl IN pym_tbl_type,
2125: p_update_type IN VARCHAR2,

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

2153: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type := NULL;
2154: lx_rgpv_rec OKL_RULE_PUB.rgpv_rec_type := NULL;
2155:
2156: l_pym_level VARCHAR2(30) := 'HEADER';
2157: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2158: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2159: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
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;

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

2156: l_pym_level VARCHAR2(30) := 'HEADER';
2157: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2158: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2159: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
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;

Line 2199: FROM okc_k_lines_b cleb,

2195:
2196: --Changed query for performance --dkagrawa
2197: CURSOR FEE_LINE_CSR(P_RGP_ID IN NUMBER) is
2198: SELECT kleb.fee_type fee_type
2199: FROM okc_k_lines_b cleb,
2200: okl_k_lines kleb,
2201: okc_line_styles_b lseb,
2202: okc_k_headers_b chrb,
2203: okc_rule_groups_b rg

Line 2214: FROM OKC_STATUSES_V OKCS, OKC_K_LINES_B CLE

2210:
2211:
2212: CURSOR INVALID_LINE_CSR(P_CLE_ID IN NUMBER) is
2213: SELECT 'Y'
2214: FROM OKC_STATUSES_V OKCS, OKC_K_LINES_B CLE
2215: WHERE CLE.STS_CODE = OKCS.CODE
2216: -- AND OKCS.STE_CODE IN ('EXPIRED','HOLD','CANCELLED','TERMINATED')
2217: AND OKCS.STE_CODE IN ('TERMINATED')
2218: AND CLE.ID = P_CLE_ID;

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

2830:
2831: l_pym_level VARCHAR2(30) := 'HEADER';
2832: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2833: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2834: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2835:
2836: -- x_return_status varchar2(1);
2837: x_primary_sty_id okl_strm_type_b.ID%TYPE;
2838:

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

3058: x_return_status OUT NOCOPY VARCHAR2,
3059: x_msg_count OUT NOCOPY NUMBER,
3060: x_msg_data OUT NOCOPY VARCHAR2,
3061: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
3062: p_service_fee_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
3063: p_asset_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
3064: p_payment_id IN OKL_STRMTYP_SOURCE_V.ID1%TYPE,
3065: p_update_type IN VARCHAR2,
3066: x_rulv_tbl OUT NOCOPY rulv_tbl_type) IS

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

3059: x_msg_count OUT NOCOPY NUMBER,
3060: x_msg_data OUT NOCOPY VARCHAR2,
3061: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
3062: p_service_fee_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
3063: p_asset_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
3064: p_payment_id IN OKL_STRMTYP_SOURCE_V.ID1%TYPE,
3065: p_update_type IN VARCHAR2,
3066: x_rulv_tbl OUT NOCOPY rulv_tbl_type) IS
3067:

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

3069: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_PAYMENT2';
3070: l_api_version CONSTANT NUMBER := 1.0;
3071:
3072: l_pym_level VARCHAR2(30) := 'HEADER';
3073: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3074: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
3075: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
3076: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3077: l_stream_id OKL_STRMTYP_SOURCE_V.ID1%TYPE := OKL_API.G_MISS_NUM;

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

3072: l_pym_level VARCHAR2(30) := 'HEADER';
3073: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3074: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
3075: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
3076: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3077: l_stream_id OKL_STRMTYP_SOURCE_V.ID1%TYPE := OKL_API.G_MISS_NUM;
3078:
3079: lx_rulv_tbl rulv_tbl_type;
3080:

Line 3456: okc_k_lines_b cleb

3452: CURSOR l_pymt_cle_csr(p_rgp_id IN NUMBER) IS
3453: SELECT rgp.cle_id pymt_cle_id,
3454: cleb.cle_id parent_cle_id
3455: FROM okc_rule_groups_b rgp,
3456: okc_k_lines_b cleb
3457: WHERE rgp.id = p_rgp_id
3458: AND cleb.id = rgp.cle_id;
3459:
3460: l_pymt_cle_rec l_pymt_cle_csr%ROWTYPE;

Line 3461: l_cle_id OKC_K_LINES_B.id%TYPE;

3457: WHERE rgp.id = p_rgp_id
3458: AND cleb.id = rgp.cle_id;
3459:
3460: l_pymt_cle_rec l_pymt_cle_csr%ROWTYPE;
3461: l_cle_id OKC_K_LINES_B.id%TYPE;
3462: l_chr_id OKC_K_HEADERS_B.id%TYPE;
3463:
3464: --Bug# 13973475
3465: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

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

3688:
3689: l_pym_level VARCHAR2(30) := 'HEADER';
3690: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
3691: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
3692: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3693:
3694: x_primary_sty_id okl_strm_type_b.ID%TYPE;
3695:
3696: l_deal_type OKL_K_HEADERS.deal_type%TYPE;

Line 3938: okc_k_lines_b cle,

3934: slh.id rul_laslh_id,
3935: rgp.cle_id
3936: FROM okc_rule_groups_b rgp,
3937: okc_rules_b slh,
3938: okc_k_lines_b cle,
3939: okc_statuses_b sts
3940: WHERE rgp.dnz_chr_id = p_chr_id
3941: AND rgp.rgd_code = 'LALEVL'
3942: AND slh.rgp_id = rgp.id

Line 3956: okc_k_lines_b cle,

3952: slh.id rul_laslh_id,
3953: rgp.cle_id
3954: FROM okc_rule_groups_b rgp,
3955: okc_rules_b slh,
3956: okc_k_lines_b cle,
3957: okc_statuses_b sts
3958: WHERE rgp.dnz_chr_id = p_chr_id
3959: AND (rgp.cle_id = p_cle_id OR
3960: rgp.cle_id IN (SELECT cle_sub.id

Line 3961: FROM okc_k_lines_b cle_sub

3957: okc_statuses_b sts
3958: WHERE rgp.dnz_chr_id = p_chr_id
3959: AND (rgp.cle_id = p_cle_id OR
3960: rgp.cle_id IN (SELECT cle_sub.id
3961: FROM okc_k_lines_b cle_sub
3962: WHERE cle_sub.cle_id = p_cle_id
3963: AND cle_sub.dnz_chr_id = p_chr_id))
3964: AND rgp.rgd_code = 'LALEVL'
3965: AND slh.rgp_id = rgp.id