DBA Data[Home] [Help]

APPS.OKC_EXP_DATE_ASMBLR_PVT dependencies on OKC_SUBCLASSES_B

Line 49: okc_subclasses_b cls

45: khr.estimated_amount k_estimated_amount,
46: khr.sts_code,
47: khr.authoring_org_id
48: FROM okc_k_headers_b khr,
49: okc_subclasses_b cls
50: WHERE (khr.id = p_chr_id OR p_chr_id IS NULL)
51: AND khr.scs_code = cls.code
52: AND khr.end_date BETWEEN (p_variance + trunc(p_last_rundate) + 1)
53: AND (trunc(sysdate) + p_variance + 0.99999)

Line 312: okc_subclasses_b cls,

308: khr.estimated_amount k_estimated_amount,
309: khr.sts_code,
310: khr.authoring_org_id
311: FROM okc_k_headers_b khr,
312: okc_subclasses_b cls,
313: okc_statuses_b sts ,
314: okc_k_lines_b kln
315: WHERE
316: (khr.id = p_chr_id OR p_chr_id IS NULL)