APPS.OKL_CLM_PVT dependencies on OKL_INS_POLICIES_B

Line 74: from okl_ins_policies_b

70: ---------------------------------------------------------------------------
71: FUNCTION get_inv_org_id(policy_id IN NUMBER) RETURN NUMBER IS
72: cursor c_inv_org(p_id number) is
73: select org_id
74: from okl_ins_policies_b
75: where id = p_id;
76: l_inv_org_id NUMBER;
77: BEGIN
78: open c_inv_org(policy_id);

Line 1987: FROM okl_ins_claims_b clmb,okl_ins_policies_b ipyb

1983: --Bug 3941692
1984: CURSOR c_claim_seq(c_ipy_id NUMBER,c_ipy_type varchar2,c_claim_like VARCHAR2) is
1985: SELECT nvl(max(to_number(substrb(clmb.claim_number,instr(clmb.claim_number,'-')+1,
1986: length(clmb.claim_number)))) + 1,-1) SEQUENCE_NUMBER
1987: FROM okl_ins_claims_b clmb,okl_ins_policies_b ipyb
1988: WHERE clmb.ipy_id = ipyb.id
1989: and clmb.claim_number like c_claim_like
1990: and ipyb.ipy_type = c_ipy_type
1991: and ipyb.id = c_ipy_id;