APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_RULE_GROUPS_V

Line 1189: l_rgrp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;

1185: l_start_date DATE;
1186: l_lty_code VARCHAR2(30);
1187: l_pricing_method VARCHAR2(2) := 'NA';
1188: l_pricing_engine VARCHAR2(2) := 'NA';
1189: l_rgrp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
1190: CURSOR find_payment_hdr_csr IS
1191: SELECT id
1192: FROM okc_rule_groups_b
1193: WHERE rgd_code = 'LALEVL' AND cle_id = p_cle_id;

Line 1201: FROM OKC_RULE_GROUPS_V RG WHERE

1197: WHERE rgp_id = p_rgp_id AND rule_information_category = 'LASLH';
1198: CURSOR RGP_CLE_CSR(P_CHR_ID IN NUMBER, P_CLE_ID IN NUMBER)IS
1199: SELECT
1200: ID
1201: FROM OKC_RULE_GROUPS_V RG WHERE
1202: RG.DNZ_CHR_ID = P_CHR_ID AND RG.CHR_ID IS NULL
1203: AND RGD_CODE = 'LALEVL'
1204: AND RG.CLE_ID = P_CLE_ID;
1205: BEGIN