eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKL_LTE_INT_PVT dependencies on OKL_LATE_POLICIES_V

Line 41: l_late_policy okl_late_policies_v.name%TYPE;

37: --start code pgomes 12/18/2002
38: l_func_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
39: l_contract_currency okl_k_headers_full_v.currency_code%TYPE;
40: l_prev_contract_currency okl_k_headers_full_v.currency_code%TYPE;
41: l_late_policy okl_late_policies_v.name%TYPE;
42: l_prev_late_policy okl_late_policies_v.name%TYPE;
43:
44: l_minimum_late_interest okl_late_policies_b.minimum_late_interest%TYPE;
45: l_maximum_late_interest okl_late_policies_b.maximum_late_interest%TYPE;

Line 42: l_prev_late_policy okl_late_policies_v.name%TYPE;

38: l_func_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
39: l_contract_currency okl_k_headers_full_v.currency_code%TYPE;
40: l_prev_contract_currency okl_k_headers_full_v.currency_code%TYPE;
41: l_late_policy okl_late_policies_v.name%TYPE;
42: l_prev_late_policy okl_late_policies_v.name%TYPE;
43:
44: l_minimum_late_interest okl_late_policies_b.minimum_late_interest%TYPE;
45: l_maximum_late_interest okl_late_policies_b.maximum_late_interest%TYPE;
46: l_late_int_minimum_balance okl_late_policies_b.late_int_minimum_balance%TYPE;

Line 64: l_late_int_fixed_yn OKL_LATE_POLICIES_V.LATE_INT_FIXED_YN%TYPE;

60: ------------------------------------------------------------
61: p_bpd_acc_rec Okl_Acc_Call_Pub.bpd_acc_rec_type;
62:
63: -- Variables for Late Interest rules Call
64: l_late_int_fixed_yn OKL_LATE_POLICIES_V.LATE_INT_FIXED_YN%TYPE;
65: l_late_int_rate OKL_LATE_POLICIES_V.LATE_INT_RATE%TYPE;
66: l_adder_rate OKL_LATE_POLICIES_V.ADDER_RATE%TYPE;
67: l_index_rate OKL_INDEX_VALUES.VALUE%TYPE;
68: l_days_in_year OKL_LATE_POLICIES_V.DAYS_IN_YEAR%TYPE;

Line 65: l_late_int_rate OKL_LATE_POLICIES_V.LATE_INT_RATE%TYPE;

61: p_bpd_acc_rec Okl_Acc_Call_Pub.bpd_acc_rec_type;
62:
63: -- Variables for Late Interest rules Call
64: l_late_int_fixed_yn OKL_LATE_POLICIES_V.LATE_INT_FIXED_YN%TYPE;
65: l_late_int_rate OKL_LATE_POLICIES_V.LATE_INT_RATE%TYPE;
66: l_adder_rate OKL_LATE_POLICIES_V.ADDER_RATE%TYPE;
67: l_index_rate OKL_INDEX_VALUES.VALUE%TYPE;
68: l_days_in_year OKL_LATE_POLICIES_V.DAYS_IN_YEAR%TYPE;
69: l_days_calc NUMBER := 0;

Line 66: l_adder_rate OKL_LATE_POLICIES_V.ADDER_RATE%TYPE;

62:
63: -- Variables for Late Interest rules Call
64: l_late_int_fixed_yn OKL_LATE_POLICIES_V.LATE_INT_FIXED_YN%TYPE;
65: l_late_int_rate OKL_LATE_POLICIES_V.LATE_INT_RATE%TYPE;
66: l_adder_rate OKL_LATE_POLICIES_V.ADDER_RATE%TYPE;
67: l_index_rate OKL_INDEX_VALUES.VALUE%TYPE;
68: l_days_in_year OKL_LATE_POLICIES_V.DAYS_IN_YEAR%TYPE;
69: l_days_calc NUMBER := 0;
70: l_held_until_date DATE;

Line 68: l_days_in_year OKL_LATE_POLICIES_V.DAYS_IN_YEAR%TYPE;

64: l_late_int_fixed_yn OKL_LATE_POLICIES_V.LATE_INT_FIXED_YN%TYPE;
65: l_late_int_rate OKL_LATE_POLICIES_V.LATE_INT_RATE%TYPE;
66: l_adder_rate OKL_LATE_POLICIES_V.ADDER_RATE%TYPE;
67: l_index_rate OKL_INDEX_VALUES.VALUE%TYPE;
68: l_days_in_year OKL_LATE_POLICIES_V.DAYS_IN_YEAR%TYPE;
69: l_days_calc NUMBER := 0;
70: l_held_until_date DATE;
71:
72: l_sty_id OKL_STRM_TYPE_V.ID%TYPE;

Line 113: , OKL_LATE_POLICIES_V LTE

109: , OKC_RULE_GROUPS_B RGP
110: , OKC_RULES_B RUL
111: , okc_rules_b rul_exm
112: ,okc_rules_b rul_hld
113: , OKL_LATE_POLICIES_V LTE
114: WHERE
115: AR_REC.APPLY_DATE > (AR_PAY.DUE_DATE + nvl(LTE.late_int_grace_period, 0))
116: AND ARL.RECEIVABLES_INVOICE_ID = AR_PAY.CUSTOMER_TRX_ID
117: AND AR_PAY.PAYMENT_SCHEDULE_ID = AR_REC.APPLIED_PAYMENT_SCHEDULE_ID

Line 173: , OKL_LATE_POLICIES_V LTE

169: , OKC_RULE_GROUPS_B RGP
170: , OKC_RULES_B RUL
171: , okc_rules_b rul_exm
172: ,okc_rules_b rul_hld
173: , OKL_LATE_POLICIES_V LTE
174: WHERE
175: AR_REC.APPLY_DATE > (AR_PAY.DUE_DATE + nvl(LTE.late_int_grace_period, 0)) AND
176: CNSLD.RECEIVABLES_INVOICE_ID = AR_PAY.CUSTOMER_TRX_ID
177: AND AR_PAY.PAYMENT_SCHEDULE_ID = AR_REC.APPLIED_PAYMENT_SCHEDULE_ID

Line 230: FROM OKL_LATE_POLICIES_V LTE

226: , NVL(LTE.MINIMUM_LATE_INTEREST,0) MINIMUM_LATE_INTEREST
227: , NVL(LTE.MAXIMUM_LATE_INTEREST,9999999999) MAXIMUM_LATE_INTEREST
228: , NVL(IDX.value,0) INDEX_RATE
229: , NVL(LTE.DAYS_IN_YEAR, 'ACTUAL') DAYS_IN_YEAR
230: FROM OKL_LATE_POLICIES_V LTE
231: , OKL_INDEX_VALUES IDX
232: WHERE LTE.NAME = cp_name
233: AND LTE.idx_id = IDX.idx_id(+)
234: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(IDX.DATETIME_VALID, SYSDATE)) AND TRUNC(NVL(IDX.DATETIME_INVALID, SYSDATE));