11426: (
11427: select gov.dnz_chr_id chr_id,
11428: crd.ID credit_id
11429: from OKC_K_HEADERS_B crd,
11430: okc_Governances gov
11431: where crd.id = gov.chr_id_referred
11432: and crd.sts_code = 'ACTIVE'
11433: and crd.scs_code = 'CREDITLINE_CONTRACT'
11434: union
11434: union
11435: select mla_g.dnz_chr_id chr_id,
11436: crd.ID credit_id
11437: from OKC_K_HEADERS_B crd,
11438: okc_Governances gov,
11439: OKC_K_HEADERS_B mla,
11440: okc_Governances mla_g
11441: where crd.id = gov.chr_id_referred
11442: and crd.sts_code = 'ACTIVE'
11436: crd.ID credit_id
11437: from OKC_K_HEADERS_B crd,
11438: okc_Governances gov,
11439: OKC_K_HEADERS_B mla,
11440: okc_Governances mla_g
11441: where crd.id = gov.chr_id_referred
11442: and crd.sts_code = 'ACTIVE'
11443: and crd.scs_code = 'CREDITLINE_CONTRACT'
11444: and gov.dnz_chr_id = mla.id
11467: (
11468: select gov.dnz_chr_id chr_id,
11469: crd.ID credit_id
11470: from OKC_K_HEADERS_B crd,
11471: okc_Governances gov
11472: where crd.id = gov.chr_id_referred
11473: and crd.sts_code = 'ACTIVE'
11474: and crd.scs_code = 'CREDITLINE_CONTRACT'
11475: union
11475: union
11476: select mla_g.dnz_chr_id chr_id,
11477: crd.ID credit_id
11478: from OKC_K_HEADERS_B crd,
11479: okc_Governances gov,
11480: OKC_K_HEADERS_B mla,
11481: okc_Governances mla_g
11482: where crd.id = gov.chr_id_referred
11483: and crd.sts_code = 'ACTIVE'
11477: crd.ID credit_id
11478: from OKC_K_HEADERS_B crd,
11479: okc_Governances gov,
11480: OKC_K_HEADERS_B mla,
11481: okc_Governances mla_g
11482: where crd.id = gov.chr_id_referred
11483: and crd.sts_code = 'ACTIVE'
11484: and crd.scs_code = 'CREDITLINE_CONTRACT'
11485: and gov.dnz_chr_id = mla.id