DBA Data[Home] [Help]

APPS.OKL_RULE_PUB dependencies on OKC_RULES_B

Line 984: FROM OKC_RULES_B

980:
981: --cursor to find out chr id required to flip status at edit point
982: CURSOR chr_id_crs (p_rul_id IN NUMBER) is
983: SELECT DNZ_CHR_ID
984: FROM OKC_RULES_B
985: WHERE ID = P_RUL_ID;
986:
987: l_dnz_chr_id OKC_RULES_B.dnz_chr_id%TYPE;
988:

Line 987: l_dnz_chr_id OKC_RULES_B.dnz_chr_id%TYPE;

983: SELECT DNZ_CHR_ID
984: FROM OKC_RULES_B
985: WHERE ID = P_RUL_ID;
986:
987: l_dnz_chr_id OKC_RULES_B.dnz_chr_id%TYPE;
988:
989: -- Start 14-Sep-2005 Manu
990: CURSOR lc_category_csr (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE) IS
991: SELECT scs_code