APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKC_GOVERNANCES

Line 10493: okc_Governances gov

10489: (
10490: select gov.dnz_chr_id chr_id,
10491: crd.ID credit_id
10492: from OKC_K_HEADERS_B crd,
10493: okc_Governances gov
10494: where crd.id = gov.chr_id_referred
10495: and crd.sts_code = 'ACTIVE'
10496: and crd.scs_code = 'CREDITLINE_CONTRACT'
10497: union

Line 10501: okc_Governances gov,

10497: union
10498: select mla_g.dnz_chr_id chr_id,
10499: crd.ID credit_id
10500: from OKC_K_HEADERS_B crd,
10501: okc_Governances gov,
10502: OKC_K_HEADERS_B mla,
10503: okc_Governances mla_g
10504: where crd.id = gov.chr_id_referred
10505: and crd.sts_code = 'ACTIVE'

Line 10503: okc_Governances mla_g

10499: crd.ID credit_id
10500: from OKC_K_HEADERS_B crd,
10501: okc_Governances gov,
10502: OKC_K_HEADERS_B mla,
10503: okc_Governances mla_g
10504: where crd.id = gov.chr_id_referred
10505: and crd.sts_code = 'ACTIVE'
10506: and crd.scs_code = 'CREDITLINE_CONTRACT'
10507: and gov.dnz_chr_id = mla.id

Line 10532: okc_Governances gov

10528: (
10529: select gov.dnz_chr_id chr_id,
10530: crd.ID credit_id
10531: from OKC_K_HEADERS_B crd,
10532: okc_Governances gov
10533: where crd.id = gov.chr_id_referred
10534: and crd.sts_code = 'ACTIVE'
10535: and crd.scs_code = 'CREDITLINE_CONTRACT'
10536: union

Line 10540: okc_Governances gov,

10536: union
10537: select mla_g.dnz_chr_id chr_id,
10538: crd.ID credit_id
10539: from OKC_K_HEADERS_B crd,
10540: okc_Governances gov,
10541: OKC_K_HEADERS_B mla,
10542: okc_Governances mla_g
10543: where crd.id = gov.chr_id_referred
10544: and crd.sts_code = 'ACTIVE'

Line 10542: okc_Governances mla_g

10538: crd.ID credit_id
10539: from OKC_K_HEADERS_B crd,
10540: okc_Governances gov,
10541: OKC_K_HEADERS_B mla,
10542: okc_Governances mla_g
10543: where crd.id = gov.chr_id_referred
10544: and crd.sts_code = 'ACTIVE'
10545: and crd.scs_code = 'CREDITLINE_CONTRACT'
10546: and gov.dnz_chr_id = mla.id