DBA Data[Home] [Help]

APPS.OKL_PA_DATA_INTEGRITY dependencies on OKC_STATUSES_B

Line 429: ,okc_statuses_b sts

425: vp_assoc.assoc_object_id,
426: vp_assoc.assoc_object_version
427: FROM okl_vp_associations vp_assoc
428: ,okc_k_headers_b chr
429: ,okc_statuses_b sts
430: WHERE vp_assoc.chr_id = cp_chr_id
431: AND vp_assoc.chr_id = chr.id
432: AND sts.code = chr.sts_code
433: AND sts.ste_Code = 'ENTERED'

Line 531: okc_statuses_b sts

527: SELECT lat.name
528: FROM OKL_LEASEAPP_TMPLS lat,
529: okl_vp_associations_v vpa,
530: okc_k_headers_b chr,
531: okc_statuses_b sts
532: WHERE lat.id = vpa.assoc_object_id
533: AND chr.id = vpa.chr_id
534: AND chr.sts_code = sts.code
535: AND sts.ste_code = 'ENTERED'