APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_RULE_GROUPS_V

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

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

Line 1206: FROM OKC_RULE_GROUPS_V RG WHERE

1202: WHERE rgp_id = p_rgp_id AND rule_information_category = 'LASLH';
1203: CURSOR RGP_CLE_CSR(P_CHR_ID IN NUMBER, P_CLE_ID IN NUMBER)IS
1204: SELECT
1205: ID
1206: FROM OKC_RULE_GROUPS_V RG WHERE
1207: RG.DNZ_CHR_ID = P_CHR_ID AND RG.CHR_ID IS NULL
1208: AND RGD_CODE = 'LALEVL'
1209: AND RG.CLE_ID = P_CLE_ID;
1210: BEGIN