APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_INS_POLICIES_B

Line 44: FROM OKL_INS_POLICIES_B IPYB

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

Line 131: FROM OKL_INS_POLICIES_B IPYB

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

Line 136: ls_payment_freq OKL_INS_POLICIES_B.IPF_CODE%TYPE;

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

Line 137: date_to OKL_INS_POLICIES_B.DATE_TO%TYPE ;

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

Line 138: date_from OKL_INS_POLICIES_B.DATE_FROM%TYPE ;

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

Line 139: cancel_date OKL_INS_POLICIES_B.CANCELLATION_DATE%TYPE;

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