DBA Data[Home] [Help]

APPS.OKL_CLM_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 2006: FROM OKL_INS_POLICIES_all_b ins, okc_k_headers_all_b chr -- bug 7335139

2002: lx_ipy_type VARCHAR2(30);
2003: l_row_notfound BOOLEAN := FALSE;
2004: cursor policy_number(p_ipy_id NUMBER) IS
2005: SELECT policy_number ,ipy_type, authoring_org_id -- bug 7335139
2006: FROM OKL_INS_POLICIES_all_b ins, okc_k_headers_all_b chr -- bug 7335139
2007: WHERE ins.ID = p_ipy_id
2008: and ins.khr_id = chr.id; -- bug 7335139
2009:
2010: l_id number; -- bug 7335139