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 328: okc_subclasses_b cls,

324: khr.estimated_amount k_estimated_amount,
325: khr.sts_code,
326: khr.authoring_org_id
327: FROM okc_k_headers_b khr,
328: okc_subclasses_b cls,
329: okc_statuses_b sts ,
330: okc_k_lines_b kln
331: WHERE
332: (khr.id = p_chr_id OR p_chr_id IS NULL)