APPS.OKC_QA_DATA_INTEGRITY dependencies on OKC_K_HEADERS_B

Line 237: FROM OKC_K_HEADERS_B chrv,

233:
234:
235: CURSOR l_chrv_csr IS
236: SELECT chrv.*, sub.cls_code
237: FROM OKC_K_HEADERS_B chrv,
238: OKC_SUBCLASSES_B sub
239: WHERE chrv.id = p_chr_id
240: AND sub.code = chrv.scs_code;
241: l_chrv_rec l_chrv_csr%ROWTYPE;

Line 1004: FROM OKC_K_HEADERS_B chr,

1000: ) IS
1001:
1002: CURSOR l_chr_csr IS
1003: SELECT chr.*, sub.cls_code
1004: FROM OKC_K_HEADERS_B chr,
1005: OKC_SUBCLASSES_B sub
1006: WHERE chr.id = p_chr_id
1007: AND sub.code = chr.scs_code;
1008: l_chr_rec l_chr_csr%ROWTYPE;

Line 1111: l_func_curr_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;

1107: l_prev_rgp_rec_id Number := -1;
1108: l_token VARCHAR2(2000);
1109: l_dummy VARCHAR2(1);
1110: l_optional_yn OKC_RG_DEF_RULES.OPTIONAL_YN%TYPE;
1111: l_func_curr_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;
1112: l_return_status VARCHAR2(1);
1113:
1114: l_adv_pricing_profile VARCHAR2(10) := 'N';
1115: l_adv_pricing_warn VARCHAR2(10) := 'N';

Line 1370: FROM OKC_K_HEADERS_B chr

1366: ) IS
1367:
1368: CURSOR l_chr_csr IS
1369: SELECT chr.template_yn,chr.application_id
1370: FROM OKC_K_HEADERS_B chr
1371: WHERE chr.id = p_chr_id;
1372: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
1373:
1374: CURSOR l_rrd_csr IS

Line 1372: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

1368: CURSOR l_chr_csr IS
1369: SELECT chr.template_yn,chr.application_id
1370: FROM OKC_K_HEADERS_B chr
1371: WHERE chr.id = p_chr_id;
1372: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
1373:
1374: CURSOR l_rrd_csr IS
1375: SELECT rgp.id "RGP_ID", rrd.id "RRD_ID", rgp.rgd_code , sre.rle_code,
1376: fndrgd.meaning "RGD_MEANING", fndrle.meaning "RLE_MEANING",

Line 1384: OKC_K_HEADERS_B chr

1380: OKC_SUBCLASS_ROLES sre,
1381: OKC_RG_ROLE_DEFS rrd,
1382: OKC_SUBCLASS_RG_DEFS srd,
1383: OKC_RULE_GROUPS_B rgp,
1384: OKC_K_HEADERS_B chr
1385: WHERE fndrle.LOOKUP_CODE = sre.rle_code
1386: AND fndrle.LOOKUP_TYPE = 'OKC_ROLE'
1387: AND fndrgd.LOOKUP_CODE = srd.rgd_code
1388: AND fndrgd.LOOKUP_TYPE = 'OKC_RULE_GROUP_DEF'

Line 1652: FROM OKC_K_HEADERS_B chrv

1648: p_chr_id IN NUMBER) IS
1649:
1650: CURSOR l_chrv_csr IS
1651: SELECT start_date, end_date
1652: FROM OKC_K_HEADERS_B chrv
1653: WHERE chrv.id = p_chr_id;
1654:
1655: CURSOR l_cle_csr IS
1656: /**