APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_INS_POLICIES_B

Line 43: FROM OKL_INS_POLICIES_B IPYB

39:
40: CURSOR c_monthly_premium (p_contract_id NUMBER,p_contract_line_id NUMBER )
41: IS
42: SELECT PREMIUM , IPF_CODE, DATE_TO , DATE_FROM
43: FROM OKL_INS_POLICIES_B IPYB
44: WHERE IPYB.kle_id = p_contract_line_id
45: AND IPYB.khr_id = p_contract_id ;
46:
47: BEGIN

Line 130: FROM OKL_INS_POLICIES_B IPYB

126:
127: CURSOR c_monthly_premium (p_contract_id NUMBER,p_contract_line_id NUMBER )
128: IS
129: SELECT IPF_CODE, DATE_TO , DATE_FROM --, CANCELLATION_DATE --++Effective DatedTermination ++---
130: FROM OKL_INS_POLICIES_B IPYB
131: WHERE IPYB.kle_id = p_contract_line_id
132: AND IPYB.khr_id = p_contract_id ;
133:
134:

Line 135: ls_payment_freq OKL_INS_POLICIES_B.IPF_CODE%TYPE;

131: WHERE IPYB.kle_id = p_contract_line_id
132: AND IPYB.khr_id = p_contract_id ;
133:
134:
135: ls_payment_freq OKL_INS_POLICIES_B.IPF_CODE%TYPE;
136: date_to OKL_INS_POLICIES_B.DATE_TO%TYPE ;
137: date_from OKL_INS_POLICIES_B.DATE_FROM%TYPE ;
138: cancel_date OKL_INS_POLICIES_B.CANCELLATION_DATE%TYPE;
139: l_stm_type_id OKL_STRM_TYPE_TL.ID%TYPE := 0;

Line 136: date_to OKL_INS_POLICIES_B.DATE_TO%TYPE ;

132: AND IPYB.khr_id = p_contract_id ;
133:
134:
135: ls_payment_freq OKL_INS_POLICIES_B.IPF_CODE%TYPE;
136: date_to OKL_INS_POLICIES_B.DATE_TO%TYPE ;
137: date_from OKL_INS_POLICIES_B.DATE_FROM%TYPE ;
138: cancel_date OKL_INS_POLICIES_B.CANCELLATION_DATE%TYPE;
139: l_stm_type_id OKL_STRM_TYPE_TL.ID%TYPE := 0;
140:

Line 137: date_from OKL_INS_POLICIES_B.DATE_FROM%TYPE ;

133:
134:
135: ls_payment_freq OKL_INS_POLICIES_B.IPF_CODE%TYPE;
136: date_to OKL_INS_POLICIES_B.DATE_TO%TYPE ;
137: date_from OKL_INS_POLICIES_B.DATE_FROM%TYPE ;
138: cancel_date OKL_INS_POLICIES_B.CANCELLATION_DATE%TYPE;
139: l_stm_type_id OKL_STRM_TYPE_TL.ID%TYPE := 0;
140:
141:

Line 138: cancel_date OKL_INS_POLICIES_B.CANCELLATION_DATE%TYPE;

134:
135: ls_payment_freq OKL_INS_POLICIES_B.IPF_CODE%TYPE;
136: date_to OKL_INS_POLICIES_B.DATE_TO%TYPE ;
137: date_from OKL_INS_POLICIES_B.DATE_FROM%TYPE ;
138: cancel_date OKL_INS_POLICIES_B.CANCELLATION_DATE%TYPE;
139: l_stm_type_id OKL_STRM_TYPE_TL.ID%TYPE := 0;
140:
141:
142: l_profile_value NUMBER := 0;